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

2 votes283 views1 answer
Mysql sysdate
SQL
1 vote310 views1 answer
Postgresql escape single quote
SQL
10 votes308 views5 answers
Mysql create user
SQL
7 votes309 views2 answers
Mysql default value
SQL
0 vote313 views1 answer
SQL Server rename foreign key constraint
SQL
1 vote308 views1 answer
Join to find results not in another table
SQL
7 votes351 views2 answers
Sql remove duplicates based on column
SQL
0 vote308 views1 answer
How to connect pgadmin with excel
SQL
3 votes315 views1 answer
Null sql
SQL
5 votes307 views3 answers
Select tables from mysql database
SQL