Customers active in both halves — practice · DataDesk

UNION, INTERSECT & EXCEPT(17 / 20)

Advanced

Customers active in both halves

List customer_ids who ordered in both halves of 2024 — January–June and July–December. Use INTERSECT.

Tables

customers

customer_idinteger
namevarchar
cityvarchar
statevarchar
signup_datedate
emailvarchar
phonevarchar
referred_byinteger

order_items

order_idinteger
product_idinteger
quantityinteger
unit_priceinteger

orders

order_idinteger
customer_idinteger
order_datedate
statusvarchar
payment_methodvarchar

products

product_idinteger
product_namevarchar
categoryvarchar
priceinteger
stockinteger

Expected output

7 rows with column customer_id — first 3 shown:

#
1	1
2	2
3	3

Hints(0/2)

Solution

Unlocks after you solve it or after 3 submissions

SQL (DuckDB)

Ctrl + Enter to runLog in to save progress and earn XP

Run your code to see the output here.