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 votes193 views2 answers
Brew start mysql
SQL
0 vote192 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote196 views1 answer
How to see which columns are indexxed mysql
SQL
20 votes186 views2 answers
Counting in sql
SQL
12 votes194 views4 answers
Install mysql ubuntu 18.04
SQL
-2 votes219 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote193 views1 answer
If column value is null then in mysql
SQL
1 vote212 views3 answers
Rows, INSERT INTO
SQL
1 vote201 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
12 votes198 views1 answer
Docker run mysql image
SQL