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

6 votes158 views3 answers
Commit in sql
SQL
0 vote224 views1 answer
Example database query
SQL
0 vote144 views1 answer
Get number of rows in every table mysql
SQL
3 votes197 views2 answers
How to list columns for particular tables in postgresql
SQL
3 votes163 views2 answers
See mysql users ubuntu
SQL
1 vote145 views1 answer
Find logged in users mysql
SQL
3 votes163 views2 answers
Create schema postgres
SQL
14 votes160 views6 answers
Auto_increment mysql
SQL
0 vote195 views1 answer
CONVERT time string into 12 hours in sql
SQL
2 votes177 views3 answers
Sql function
SQL