关于mysql单表根据按照某一字段按照年份统计总数

单表某一字段根据月份进行统计总量

SELECT
    COUNT(1) AS countNumber,
    DATE_FORMAT(created_at,'%Y-%m') AS dateTime,
    school_id
FROM log WHERE school_id>0 
GROUP BY dateTime, school_id ORDER B![在这里插入图片描述](https://img-blog.csdnimg.cn/352cd987b9ec4707a265d98e64d42ae1.png#pic_center)
Y dateTime DESC;```

**统计结果为：**
![在这里插入图片描述](https://img-blog.csdnimg.cn/0da7174c430f4a55881d4152a48bea04.png)