SELECT city_name, SUM(confirmed_cases) confirmed_cases , SUM(recovered_cases) recovered_cases, SUM(death_cases) death_cases FROM cases JOIN dati ON dati.code = cases.dati_code GROUP BY city_name ORDER BY confirmed_cases DESC;
-- Code Here- SELECT
- city_name,
- SUM(confirmed_cases) confirmed_cases ,
- SUM(recovered_cases) recovered_cases,
- SUM(death_cases) death_cases
- FROM cases
- JOIN dati
- ON dati.code = cases.dati_code
- GROUP BY city_name
- ORDER BY confirmed_cases DESC;