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 vote135 views1 answer
File /etc/init.d/mysql not exists
SQL
10 votes132 views1 answer
Oracle view dependencies
SQL
0 vote182 views1 answer
Django mysqlclient connection string
SQL
2 votes260 views3 answers
Xampp mysql database not starting
SQL
2 votes180 views1 answer
Rails execute sql
SQL
1 vote186 views1 answer
Postgresql substring last
SQL
0 vote277 views1 answer
Having all mysql
SQL
0 vote211 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
1 vote177 views1 answer
Local sql server
SQL
2 votes178 views1 answer
How to add where command in update comand with joins
SQL