runtimetask Date filtering · easy
Users created in March 2025
Return user_id, account_id and created_at for users created in March 2025.
what to return
- Columns
user_idaccount_idcreated_atin this order- Rows
- 1086 rows · any order
- Skill
- Select a calendar month with a half-open range. Refresher: Date boundaries & monthly buckets →
expected result
Your query should return exactly these columns and values. Run it and compare.
expected result1086 rows · any order
| user_id | account_id | created_at |
|---|---|---|
| 7377 | 1952 | 2025-03-01 00:08:11 |
| 7002 | 1849 | 2025-03-01 00:09:05 |
| 7307 | 1935 | 2025-03-01 00:43:53 |
first 3 of 1086 rows
data you can query
Product / SaaS Analytics dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.
users9 columns · 11,348 rows
| user_idnumber · unique id | account_idnumber · links to accounts | full_nametext | emailtext | roletext | signup_sourcetext | referred_by_user_idnumber · links to users | created_atdate & time | deactivated_attext |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | Omar Jackson | omar.jackson@ironcapital1.example | owner | workspace_creator | NULL | 2024-01-14 18:52:14 | NULL |
| 2 | 1 | Imani Kang | imani.kang@ironcapital1.example | admin | invitation | NULL | 2024-01-24 03:43:14 | NULL |
| 3 | 1 | Chloe Mitchell | chloe.mitchell@ironcapital1.example | admin | invitation | NULL | 2024-02-02 21:34:25 | NULL |
| 4 | 1 | Jaya Carter | jaya.carter@ironcapital1.example | member | domain_join | NULL | 2024-03-31 03:39:32 | NULL |
| 5 | 1 | Zoe Turner | zoe.turner@ironcapital1.example | member | domain_join | NULL | 2024-02-12 02:53:31 | NULL |
| 6 | 2 | Esther Smith | esther.smith@vectordata2.example | owner | workspace_creator | NULL | 2024-01-15 13:21:52 | NULL |
- user_idnumber · unique id
- 1
- account_idnumber · links to accounts
- 1
- full_nametext
- Omar Jackson
- emailtext
- omar.jackson@ironcapital1.example
- roletext
- owner
- signup_sourcetext
- workspace_creator
- referred_by_user_idnumber · links to users
- NULL
- created_atdate & time
- 2024-01-14 18:52:14
- deactivated_attext
- NULL
- user_idnumber · unique id
- 2
- account_idnumber · links to accounts
- 1
- full_nametext
- Imani Kang
- emailtext
- imani.kang@ironcapital1.example
- roletext
- admin
- signup_sourcetext
- invitation
- referred_by_user_idnumber · links to users
- NULL
- created_atdate & time
- 2024-01-24 03:43:14
- deactivated_attext
- NULL
- user_idnumber · unique id
- 3
- account_idnumber · links to accounts
- 1
- full_nametext
- Chloe Mitchell
- emailtext
- chloe.mitchell@ironcapital1.example
- roletext
- admin
- signup_sourcetext
- invitation
- referred_by_user_idnumber · links to users
- NULL
- created_atdate & time
- 2024-02-02 21:34:25
- deactivated_attext
- NULL
- user_idnumber · unique id
- 4
- account_idnumber · links to accounts
- 1
- full_nametext
- Jaya Carter
- emailtext
- jaya.carter@ironcapital1.example
- roletext
- member
- signup_sourcetext
- domain_join
- referred_by_user_idnumber · links to users
- NULL
- created_atdate & time
- 2024-03-31 03:39:32
- deactivated_attext
- NULL
- user_idnumber · unique id
- 5
- account_idnumber · links to accounts
- 1
- full_nametext
- Zoe Turner
- emailtext
- zoe.turner@ironcapital1.example
- roletext
- member
- signup_sourcetext
- domain_join
- referred_by_user_idnumber · links to users
- NULL
- created_atdate & time
- 2024-02-12 02:53:31
- deactivated_attext
- NULL
- user_idnumber · unique id
- 6
- account_idnumber · links to accounts
- 2
- full_nametext
- Esther Smith
- emailtext
- esther.smith@vectordata2.example
- roletext
- owner
- signup_sourcetext
- workspace_creator
- referred_by_user_idnumber · links to users
- NULL
- created_atdate & time
- 2024-01-15 13:21:52
- deactivated_attext
- NULL
first 6 of 11,348 rows · your queries use all of them
solution.sql
Hints and the answer are always available. Using them counts the question as solved with help.