Customers Active in Two Months (INTERSECT)

easy
Unit 5 · Dates & Set Operations0/3 to milestone

Which customers ordered in both January 2024 and February 2024? Return their names, sorted.

Use INTERSECT to combine the two sets of customer ids.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#set-operations#subqueries1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Customers Active in Two Months (INTERSECT) · TechGradify