Exercise : Countries

List all countries in Europe, Oceania, and Antarctica, sorted by continent.

+------------+----------------------------------------------+
| continent  | name                                         |
+------------+----------------------------------------------+
| Europe     | Albania                                      |
| Europe     | Andorra                                      |
| Europe     | Austria                                      |
| Europe     | Belarus                                      |
| Europe     | Belgium                                      |
...
+------------+----------------------------------------------+
79 rows in set (0.03 sec)

Exercise Solution

SELECT continent, name
FROM countries
WHERE continent IN ('Europe', 'Oceania', 'Antarctica')
ORDER BY continent, name;