Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Filtering by row
Extracting data by column
10. Select many columns
Practice using filter() and select()
The pipe operator
Sorting rows


Good job! Usually, we need to extract more than one column at a time. Again, we use a comma separator (,) between the column names to do this. Important: In this context, the comma means "or". In filter(), it meant "and".

To choose information about country names and continents, we would use:

select(countries, country_name, continent)


Select information about country names (country_name) and populations (population).

Stuck? Here's a hint!


select(countries, country_name, population)