All Problems
63

Monthly Order Count

MediumSUBSTRGROUP BYdates

Problem Description

Write a SQL query to count orders placed each month in 2023.

Expected Columns

  • month
  • order_count

Example Output

| month | order_count | |-------|-------------| | 01 | 2 | | 02 | 2 | | 03 | 3 | | 04 | 4 | | 05 | 2 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#63 Monthly Order Count
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results