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

17 votes372 views2 answers
Mysql date to string
SQL
0 vote395 views2 answers
How to get max from each department in sql
SQL
0 vote349 views1 answer
Find most frequent value in SQL column
SQL
0 vote390 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote362 views1 answer
Find difference in dates sql
SQL
0 vote372 views1 answer
SQL division of an integer by another integer get float CAST
SQL
2 votes392 views1 answer
Dbms transaction (psql)
SQL
6 votes332 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote399 views1 answer
Querry mysql by 2 columns
SQL
1 vote357 views1 answer
Moodle query first user access
SQL