Exercise : High Life Expectancy

What countries have a life expectancy of 78 years or more? List the county names and life expectancies, sorted by greatest to least life expectancy.

+----------------------+-----------------+
| name                 | life_expectancy |
+----------------------+-----------------+
| Andorra              |            83.5 |
| Macao                |            81.6 |
| San Marino           |            81.1 |
| Japan                |            80.7 |
| Singapore            |            80.1 |
...
+----------------------+-----------------+
27 rows in set (0.00 sec)

Exercise Solution

SELECT name, life_expectancy
FROM countries
WHERE life_expectancy >= 78
ORDER BY life_expectancy DESC;