Exercise : Monarchs

What countries have a monarchy as their form of government?

+----------------------------------+-------------------------------------+
| name                             | government_form                     |
+----------------------------------+-------------------------------------+
| Antigua and Barbuda              | Constitutional Monarchy             |
| Bahamas                          | Constitutional Monarchy             |
| Barbados                         | Constitutional Monarchy             |
| Belize                           | Constitutional Monarchy             |
| Cambodia                         | Constitutional Monarchy             |
...
+----------------------------------+-------------------------------------+
43 rows in set (0.01 sec)

Exercise Solution

SELECT DISTINCT name, government_form
FROM countries
WHERE government_form LIKE '%monarchy%'
ORDER BY government_form, name;