Exercise : Same Name

Which countries have the same local name as their official name? Show them in sorted order.

+----------------------------------------------+
| name                                         |
+----------------------------------------------+
| Andorra                                      |
| Angola                                       |
| Anguilla                                     |
| Antigua and Barbuda                          |
| Argentina                                    |
...
+----------------------------------------------+
104 rows in set (0.00 sec)

Exercise Solution

SELECT name
FROM countries
WHERE name = local_name
ORDER BY name;