Exercise : Not In Africa

List all countries that are not in Africa.

+----------------------------------------------+
| name                                         |
+----------------------------------------------+
| Afghanistan                                  |
| Netherlands                                  |
| Netherlands Antilles                         |
| Albania                                      |
| American Samoa                               |
...
+----------------------------------------------+
181 rows in set (0.00 sec)

Exercise Solution

SELECT name
FROM countries
WHERE continent != 'Africa';

Could also use:

SELECT name
FROM countries 
WHERE continent <> 'Africa';