Project 9: Destinations Filter

SQL Architect

Builds on these lessons

Query Task

WHERE filters which rows come back — only rows where the condition is true are included. Without it, every single row in the table is returned.

You're given a destinations table with columns id, name, country, and best_season.

Task: write a query that returns every column, for rows where country is exactly 'Japan'.

query.sql

SELECT * FROM destinations WHERE country = 'Japan';

* Hint: Correct characters turn green, incorrect ones turn red.

Query Results

🗄️

Execute your query to see results