Customers Who Ordered Every Month

hard
Unit 24 · Window Functions & Cohorts0/0 to milestone

Find the most loyal customers: return the name of every customer who placed at least one order in every month that has any orders in the data. Sort by name.

Pro problem

Unlock this and every premium problem across all tracks — plus hidden-test grading, advanced AI engineering modules and new content every week.

Start 7-day free trial
query.sql · SQLite
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Customers Who Ordered Every Month · TechGradify