SQL practice › Joins & grouping
Orders per Month
Medium · Joins & grouping
Return the month (as YYYY-MM) and the number of orders placed in it, ordered by month.
Hint
In SQLite, strftime('%Y-%m', date) gives the year-month.
Write your query on this page — it runs against the sample company database in your browser and is checked instantly.
Next problem: Total Spend per Customer