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)
SELECT DISTINCT name, government_form FROM countries WHERE government_form LIKE '%monarchy%' ORDER BY government_form, name;