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

6 votes75 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote117 views1 answer
Delete row mssql
SQL
0 vote121 views2 answers
2nd max salary query in sql
SQL
5 votes126 views1 answer
Oracle asynchronous update
SQL
0 vote114 views1 answer
Create a table from one field of another table
SQL
0 vote122 views1 answer
SQL get max per id
SQL
0 vote138 views1 answer
Drop all data from tables
SQL
1 vote110 views1 answer
Importance of comment in mysql
SQL
6 votes174 views2 answers
Non relational database
SQL
9 votes143 views3 answers
Date format in sql
SQL