Beginner#02 · WHERE

Customers in Lisbon

The Lisbon branch is running a launch event. Return the first_name and last_name of every customer whose city is Lisbon.

Write your query in the lab. It runs in your browser and tells you exactly what's wrong if it doesn't match.

Hints

Hint 1

Filter rows with a WHERE clause.

Hint 2

Text values go in single quotes: city = 'Lisbon'.

Your result should match this, in any order (4 rows).

Show the solution

SELECT first_name, last_name
FROM customers
WHERE city = 'Lisbon';

Other queries that return the same rows are correct too. The lab checks your result, not your exact wording.