Exercise : A/B Countries

List the countries whose names start with either A or B.

+--------------------------------+
| name                           |
+--------------------------------+
| Afghanistan                    |
| Albania                        |
| Algeria                        |
| American Samoa                 |
| Andorra                        |
...
+--------------------------------+
35 rows in set (0.00 sec)

Exercise Solution

SELECT name
FROM countries
WHERE name LIKE 'A%' OR name LIKE 'B%';