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

1 vote247 views1 answer
Import database from a file using mysql commandline
SQL
-1 vote279 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote282 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote280 views1 answer
How to find table lock and row lock in mysql
SQL
2 votes270 views1 answer
Removing view
SQL
7 votes268 views1 answer
Sql limit decimal places
SQL
1 vote271 views2 answers
Copy database mysql
SQL
0 vote318 views1 answer
Osm2pgsql mac
SQL
0 vote280 views1 answer
Timestamp(0) postgresql
SQL
0 vote302 views1 answer
How to compile a function in oracle
SQL