task Date filtering · easy
Signups in the last 30 days
Return the name and signup_date of shoppers who signed up in the 30 days ending on 2025-03-31.
what to return
- Columns
namesignup_datein this order- Rows
- 5 rows · any order
- Watch for
- The 30 days are 2025-03-02 through 2025-03-31, both included.
- Skill
- Turn a rolling period into exact date boundaries. Refresher: Date boundaries & monthly buckets →
expected result
Your query should return exactly these columns and values. Run it and compare.
expected result5 rows · any order
| name | signup_date |
|---|---|
| Lena Fischer | 2025-03-10 |
| Mo Haddad | 2025-03-15 |
| Nia Brooks | 2025-03-21 |
first 3 of 5 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.