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 vote311 views1 answer
Get time component of datetime sql
SQL
3 votes312 views1 answer
Oracle undo tablespace list by user
SQL
2 votes348 views1 answer
Mysql set value as null
SQL
0 vote314 views1 answer
Count the table indatabase
SQL
2 votes324 views1 answer
Oracle list grants on procedure
SQL
5 votes321 views1 answer
How to check port number for postgresql
SQL
0 vote304 views2 answers
Avg() sql
SQL
1 vote321 views2 answers
Setval max id postgresql sequence
SQL
2 votes326 views1 answer
Oracle drop sequence if exists
SQL
0 vote309 views1 answer
Concatenate columns in table
SQL