-- Code Here select city_name, sum(confirmed_cases) confirmed_cases , sum(recovered_cases) recovered_cases, sum(death_cases) death_cases from cases c join dati d on d.code = c.dati_code group by city_name order by confirmed_cases desc
- -- Code Here
selectcity_name,- select city_name,
- sum(confirmed_cases) confirmed_cases ,
- sum(recovered_cases) recovered_cases,
- sum(death_cases) death_cases
from casesjoin dation dati.code = cases.dati_code- from cases c
- join dati d
- on d.code = c.dati_code
- group by city_name
- order by confirmed_cases desc