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)
SELECT continent, name FROM countries WHERE continent IN ('Europe', 'Oceania', 'Antarctica') ORDER BY continent, name;