Practice · easy · dataset: ecom
July 2025 signups
Growth is reviewing the customers who signed up in July 2025. Return customer_id, email,
country, and signup_date for every customer whose signup_date falls in that month.
Treat July as a half-open range from 2025-07-01 up to but not including 2025-08-01. Sort by
signup_date ascending, then by customer_id ascending.
Tables available
| Table | Columns |
|---|---|
customers |
customer_id, email, country, signup_date |
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.