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

0 vote208 views1 answer
Plpgsql if statement
SQL
0 vote196 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote170 views2 answers
Mysql password error create datbase
SQL
0 vote185 views2 answers
How covert into int in maria db
SQL
2 votes172 views1 answer
Sql to char function with date
SQL
0 vote176 views1 answer
How to install sql in anaconda
SQL
0 vote176 views1 answer
Inserted row count tsql
SQL
0 vote167 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote205 views2 answers
How to get max from each department in sql
SQL
0 vote227 views2 answers
Check if sql temp table exists
SQL