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

2 votes199 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote234 views1 answer
Sql cursor example multiple columns
SQL
0 vote208 views1 answer
Sql select with apostrohpe
SQL
0 vote210 views1 answer
Mysql order by where condition sub query
SQL
-1 vote235 views2 answers
Sql truncate number
SQL
0 vote201 views1 answer
How to see password mysql vestacp
SQL
0 vote201 views1 answer
Drop a field in psql django
SQL
0 vote195 views1 answer
Psql no such file or directory
SQL
1 vote213 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
3 votes201 views4 answers
Order by desc postgres
SQL