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

3 votes253 views2 answers
Update part of a string in mysql
SQL
10 votes217 views1 answer
Oracle dependency
SQL
13 votes255 views3 answers
Change data type postgresql
SQL
0 vote259 views1 answer
SQL Where-Klausel
SQL
0 vote259 views1 answer
Python mysql show databases
SQL
0 vote230 views1 answer
Mysql find missing values
SQL
2 votes228 views1 answer
Pandas to sql index
SQL
7 votes241 views5 answers
Show details of table postgres
SQL
25 votes238 views6 answers
Sql update query
SQL
24 votes199 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL