-- Code Here
select
  d.city_name as kota,
  sum(c.confirmed_cases) as confirmed_cases,
  sum(c.recovered_cases) as recovered_cases,
  sum(c.death_cases) as death_cases
from cases c
left join dati d
on d.code = c.dati_code
group by 1
order by 2 desc