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

0 vote204 views5 answers
Mode sql course
SQL
0 vote213 views1 answer
Sql server concat null
SQL
2 votes195 views1 answer
Postgresql update sequence next value
SQL
7 votes246 views5 answers
Sql remove spaces
SQL
2 votes243 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote227 views3 answers
Join
SQL
0 vote237 views1 answer
Virtuoso sql query tutorial
SQL
0 vote204 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote229 views1 answer
Oracle list datafiles
SQL
0 vote194 views1 answer
What is the difference between now() and current_date()?
SQL