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 vote249 views1 answer
Casterar postgres
SQL
18 votes247 views6 answers
Drop table if exists
SQL
0 vote271 views1 answer
SQL column name Oracle
SQL
3 votes265 views1 answer
Unsigned int in mysql
SQL
9 votes271 views4 answers
Postgresql export database
SQL
1 vote286 views2 answers
Postgresql check privileges on schema
SQL
0 vote251 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
10 votes256 views1 answer
Query to find object dependencies in oracle
SQL
0 vote295 views1 answer
Min varias colunas spark sql
SQL
10 votes247 views2 answers
Sql merge statement
SQL