SQL 一年内每月数据统计

https://blog.csdn.net/ao123056/article/details/79443788

demo：

SELECT YEAR(insert_time) AS year, MONTH(insert_time) AS month, count(*) as count FROM tb1 WHERE YEAR(insert_time)=2019 GROUP BY YEAR(insert_time), MONTH(insert_time);