task WHERE · warm-up
Shoppers in the West region
Return the id and name of shoppers whose region is West.
what to return
- Columns
idnamein this order- Rows
- 4 rows · any order
- Watch for
- Region values are capitalised exactly as 'West'.
- Skill
- Filter rows with WHERE and a text value. Refresher: Filter with WHERE →
expected result
Your query should return exactly these columns and values. Run it and compare.
expected result4 rows · any order
| id | name |
|---|---|
| 1 | Ana Ruiz |
| 3 | Chloe Park |
| 9 | Ivan Petrov |
first 3 of 4 rows
data you can query
Sample rows from each table. Each column shows its type underneath; → marks a link to another table.
shoppers5 columns · 17 rows
| idinteger · key | nametext | emailtext | regiontext | signup_datetext |
|---|---|---|---|---|
| 1 | Ana Ruiz | ana@harbor.test | West | 2025-01-03 |
| 2 | Ben Okafor | ben@harbor.test | East | 2025-01-05 |
| 3 | Chloe Park | chloe@harbor.test | West | 2025-01-09 |
| 4 | Dmitri Volkov | dmitri@harbor.test | North | 2025-01-14 |
| 5 | Esi Mensah | NULL | South | 2025-01-20 |
showing 5 of 17 rows
solution.sql
Hints and the answer are always available. Using them counts the question as solved with help.