Getting everything ready for you…

Loading courses, problems and your progress. This takes just a moment.

0s

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