Skip to content
Snippets Groups Projects
Select Git revision
  • dc581774ffa93217115e044ae9c8965e871df87b
  • master default protected
2 results

README.md

Blame
  • To learn more about this project, read the wiki.
    ex18.sql 212 B
    SELECT countriesAndTerritories AS "country name", ((CAST(sum(deaths) AS REAL) * 100) / sum(cases)) AS perc
    FROM Report
    NATURAL JOIN Country
    NATURAL JOIN CountryName
    GROUP BY countryId
    ORDER BY perc DESC
    LIMIT 10;