Exercise : World Languages

What languages are spoken in the United States (country_code 'USA')? Show the language and the percentage. Order by percentage from largest to smallest.

+------------+------------+
| language   | percentage |
+------------+------------+
| English    |       86.2 |
| Spanish    |        7.5 |
| French     |        0.7 |
| German     |        0.7 |
| Chinese    |        0.6 |
...
+------------+------------+
12 rows in set (0.11 sec)

Exercise Solution

SELECT language, percentage
FROM languages
WHERE country_code = 'USA'
ORDER BY percentage DESC;