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

3 votes150 views1 answer
Oracle undo tablespace schema
SQL
1 vote145 views1 answer
Mysql change root mysql_native_password
SQL
0 vote150 views1 answer
Compression of dabatase mysqldumo
SQL
4 votes134 views1 answer
Mysql ip address
SQL
0 vote145 views1 answer
Select lowest values sql
SQL
2 votes136 views1 answer
Oracle drop table free up space
SQL
0 vote101 views1 answer
Expose db in virtualbox
SQL
2 votes187 views1 answer
Flask sqlalchemy boolean field
SQL
-1 vote144 views3 answers
Psql get last rows
SQL
1 vote129 views1 answer
Delete triger pl pg sql
SQL