CodeAgeBy Sitezack
SQL for ProsSQL with SQLite0 XP
Chapter progress0/6

Lesson 3 of 7

WHERE: filter rows

WHERE restricts the returned rows: SELECT name FROM customers WHERE city = 'Berlin'.

SQL strings use single quotes. Conditions combine with AND and OR.

SELECT name FROM customers WHERE age > 40;

🎯 Exercise

Write the query that returns the name of customers whose city is Berlin.

PRO lesson

This advanced chapter is part of CodeAge PRO. Unlock it to keep your adventure going.

Discover PRO