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

ex18.sql

Blame
  • p9malino26's avatar
    pm3g19 authored
    6d8832f8
    History
    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;