Not like

You can use not like to find strings that do not contain a substring.

Show the name of countries that have a space but no letter A.

SELECT name FROM world WHERE name NOT LIKE '%A%' AND name LIKE '% %'

NEXT EXERCISE