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 vote248 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
2 votes338 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote282 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote298 views1 answer
Oracle for loop on list
SQL
25 votes303 views6 answers
Import mysql database command line
SQL
0 vote307 views1 answer
Oracle sql copy table without data
SQL
1 vote285 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote284 views1 answer
Get yesterday date ISO in psql
SQL
1 vote280 views2 answers
Mysql type conversion
SQL
8 votes315 views1 answer
Oracle search stored procedures for text
SQL