Customers Who Ordered in Their Signup Month

medium
Unit 21 · Aggregation & Joins II0/3 to milestone

Return the id and name of customers who placed at least one order in the same calendar month they signed up, sorted by id.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#joins#dates#exists1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Customers Who Ordered in Their Signup Month · TechGradify