Ad
m-nandavs.rishadharis

SQL Left Join 1 (BIE)

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