Lists possible values

The word IN allows us to check if an item is in a list. The example shows the name and population for the countries 'Brazil', 'Russia', 'India' and 'China'.

Show the name and the population for 'Sweden', 'Norway' and 'Denmark'.

SELECT name, population FROM world WHERE name IN ('Sweden', 'Norway' and 'Denmark');

NEXT EXERCISE

Another way to do this filtering is to list those as = conditions with OR operators, as you'll discover later. There's generally more than one way to solve a problem in SQL. This website only checks the resulting rows, you can use any query you want as long as it works.