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