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

19 votes276 views2 answers
Mysql add column after another
SQL
0 vote276 views1 answer
How to export only procedures mysql
SQL
32 votes298 views6 answers
How to change column name in sql
SQL
1 vote269 views1 answer
Create temporal table in sql
SQL
0 vote294 views1 answer
Microsoft sql server python connection
SQL
0 vote299 views1 answer
Postgresql port 5432 not open
SQL
0 vote352 views1 answer
Split first name and last name in sql
SQL
17 votes308 views4 answers
Show tables sql server
SQL
7 votes284 views2 answers
Mysql get year from date
SQL
13 votes287 views2 answers
Get date from now() mysql
SQL