Only output some rows

You can add a WHERE column with a condition to avoid listing all rows.

Change the select below to only list the name and population of 'France'.

SELECT name, population FROM world WHERE name='France'

NEXT EXERCISE

You might have noticed that we type the SQL special words (like select, where..) uppercase. It's not required, typing them lowercase works too, but it helps with readability.