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 vote115 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote103 views1 answer
Oracle last user logon
SQL
3 votes108 views3 answers
Create a view postgres
SQL
2 votes66 views1 answer
Sql float to int
SQL
0 vote109 views1 answer
Drop constraint in ms sql
SQL
0 vote74 views1 answer
Create duplicate table postgres
SQL
0 vote102 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote110 views1 answer
Get role postgres
SQL
0 vote113 views4 answers
Sql server date format yyyy-mm-dd
SQL
16 votes103 views1 answer
Sqlserver add column to table
SQL