The Busiest Month

easy
Unit 3 · Aggregation II0/3 to milestone

Return the month (YYYY-MM) with the most orders and its orders count. If months tie, return the earliest.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#aggregation#limit1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
The Busiest Month · TechGradify