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 →