Customers Active in Both Halves of the Period

medium
Checkpoint challenge
Solve this to show you know the material and jump straight to Unit 23. Everything before it counts as cleared.

Split the data at 2024-02-15: the first half is orders before that date, the second half is orders on or after it. Return the id and name of customers who ordered in both halves, sorted by id.

Schema

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