Customers Active in Both Halves of the Period

medium
Unit 22 · Joins0/2 to milestone

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