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 vote145 views1 answer
Sql get user account
SQL
4 votes152 views3 answers
Employee name starting with in sql
SQL
0 vote142 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote152 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
3 votes146 views1 answer
Mysql set field unique
SQL
0 vote235 views1 answer
Oracle sql alter view add column
SQL
5 votes174 views1 answer
Oracle ora-00054 resource busy
SQL
3 votes168 views3 answers
Start postgresql ubuntu
SQL
10 votes135 views4 answers
Primary key in sql
SQL
1 vote163 views2 answers
Mysql insert generate serie
SQL