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

24 votes190 views5 answers
Sql server insert into select
SQL
0 vote200 views1 answer
Add a new column into table
SQL
0 vote212 views1 answer
Where field is null sql knex
SQL
1 vote194 views2 answers
Extract weekday from date in sql
SQL
5 votes182 views1 answer
Postgres integer to serial
SQL
0 vote201 views1 answer
Psql datestyle
SQL
0 vote193 views1 answer
Sql developer search all packages for text
SQL
1 vote185 views1 answer
Create table tablename as select * from tablename
SQL
0 vote225 views1 answer
Sql tablo hangi sp de
SQL
5 votes212 views1 answer
Oracle list functions
SQL