-- Code Here

SELECT 
  city_name AS kota,
  sum(confirmed_cases) AS confirmed_cases,
  sum(recovered_cases) AS recovered_cases,
  sum(death_cases) AS death_cases
FROM cases
INNER JOIN dati ON cases.dati_code = dati.code
GROUP BY city_name
ORDER BY confirmed_cases DESC

-- Code here
select * from customers;