Mysql count by month

select year(order_date),month(order_date),count(*)
     from sales
     group by year(order_date),month(order_date)
     order by year(order_date),month(order_date);
+------------------+-------------------+-----------+
| year(order_date) | month(order_date) | count(*) |
+------------------+-------------------+-----------+
|             2020 |                 1 |       408 |
|             2020 |                 2 |       320 |
|             2020 |                 3 |       540 |
|              ... |               ... |       ... |
+------------------+-------------------+-----------+

Source: ubiq.co

Similar codes

12 votes309 views3 answers
Duplicate a column in sql
SQL
0 vote375 views1 answer
Sql basic commands
SQL
0 vote314 views1 answer
Comma seperated join mssql
SQL
0 vote317 views1 answer
Laravel eloquent get generated sql
SQL
2 votes308 views1 answer
How to select first row of database sql
SQL
2 votes309 views2 answers
Sqlite_busy: database is locked
SQL
0 vote365 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote346 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote344 views1 answer
How to find the most occuring in SQL
SQL
0 vote316 views1 answer
Storing RGBA in mysql db
SQL