Select Git revision
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;