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 vote173 views1 answer
Suhaib
SQL
0 vote152 views4 answers
What is unique key in sql
SQL
12 votes146 views4 answers
Mysql version
SQL
0 vote149 views1 answer
How to set up an anonymous function to variable in swift
SQL
2 votes165 views1 answer
Find column in all stored procedures sql server
SQL
0 vote140 views1 answer
Stored procedure function relation
SQL
0 vote147 views1 answer
Sort by last two number sql
SQL
1 vote184 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote149 views1 answer
Mysql cast null to string
SQL
9 votes143 views4 answers
Postgresql export database
SQL