Exercise : Regions

List all continents and all regions within them. Make it easy to see regions for each contient.

+---------------+---------------------------+
| continent     | region                    |
+---------------+---------------------------+
| Asia          | Eastern Asia              |
| Asia          | Middle East               |
| Asia          | Southeast Asia            |
| Asia          | Southern and Central Asia |
| Europe        | Baltic Countries          |
...
+---------------+---------------------------+
25 rows in set (0.00 sec)

Exercise Solution

SELECT DISTINCT continent, region
FROM countries
ORDER BY continent, region;