Exercise : World Official Languages

List all of the official languages spoken around the world in reverse alphabetical order.

+------------------+
| language         |
+------------------+
| Zulu             |
| Xhosa            |
| Wolof            |
| Vietnamese       |
| Uzbek            |
...
+------------------+
102 rows in set (0.02 sec)

Exercise Solution

SELECT DISTINCT language
FROM languages
WHERE official='T'
ORDER BY language DESC;