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.