Exercise : Antarctic Countries

List the names of all countries in Antarctica.

+----------------------------------------------+
| name                                         |
+----------------------------------------------+
| Antarctica                                   |
| Bouvet Island                                |
| South Georgia and the South Sandwich Islands |
| Heard Island and McDonald Islands            |
| French Southern territories                  |
+----------------------------------------------+
5 rows in set (0.02 sec)

Exercise Solution

SELECT name 
FROM countries
WHERE continent = 'Antarctica';