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)
SELECT DISTINCT continent, region FROM countries ORDER BY continent, region;