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

2 votes324 views2 answers
Mysql all columns
SQL
2 votes340 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote338 views1 answer
Sqlite check if row exists
SQL
3 votes352 views2 answers
How to list columns for particular tables in postgresql
SQL
2 votes330 views1 answer
Oracle sql drop table purge
SQL
0 vote325 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
1 vote411 views1 answer
Opensuse restart MySQL
SQL
4 votes362 views3 answers
Rename table column postgresql
SQL
1 vote340 views1 answer
Mysql show table character set
SQL
0 vote344 views1 answer
Contact mysql column field
SQL