List the full names of all countries where English is spoken as an official language. Do this as a single query. (JOIN) Expected results:
+--------------------------------------+ | name | +--------------------------------------+ | American Samoa | | Anguilla | | Antigua and Barbuda | | Australia | | Barbados | ... +--------------------------------------+ 44 rows in set (0.02 sec)
SELECT c.name FROM countries c JOIN languages l on l.country_code = c.code WHERE l.language = 'English' AND l.official = 'T';