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

1 vote116 views1 answer
Full text index mysql
SQL
0 vote219 views1 answer
Mysql wsrep ls
SQL
0 vote166 views2 answers
How to delete the rows with null values in mysql
SQL
3 votes205 views1 answer
Delete all content in table mysql
SQL
48 votes272 views3 answers
Psql create database
SQL
-1 vote167 views1 answer
Mysql #1064 error
SQL
0 vote175 views3 answers
Delete in SQL SERVER
SQL
7 votes161 views3 answers
Postgresql dump and restore db
SQL
11 votes184 views5 answers
Sql server reset identity
SQL
0 vote232 views1 answer
Postgres select from values
SQL