Orders from New vs Returning Customers

medium
Unit 15 · Window Functions VIII0/2 to milestone

For each month with orders (YYYY-MM), return month, new_orders (orders that were a customer's first ever order) and returning_orders (all others). Sort by month.

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
Orders from New vs Returning Customers · TechGradify