task SELECT columns · warm-up
Shopper contact list
Return the name and email of every shopper.
what to return
- Columns
nameemailin this order- Rows
- 17 rows · any order
- Watch for
- Include shoppers whose email is missing (it shows as NULL).
- Skill
- Choose specific columns with SELECT. Refresher: Meet your first SELECT →
expected result
Your query should return exactly these columns and values. Run it and compare.
expected result17 rows · any order
| name | |
|---|---|
| Ana Ruiz | ana@harbor.test |
| Ben Okafor | ben@harbor.test |
| Chloe Park | chloe@harbor.test |
first 3 of 17 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.