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