mysql查询当前年份每个月学生的数量

SELECT DATE_FORMAT(DATE_ADD(
    CONCAT(YEAR(DATE(CONCAT('2021','-12-01'))),'-01-    01'),INTERVAL (CAST( help_topic_id AS SIGNED INTEGER )) MONTH ),'%Y-%m') dateForMonth
FROM mysql.help_topic
WHERE help_topic_id < 12

select
   left(created_time,7) AS checkTime,
   count(1) AS totalNum
from student_info
where left(created_time,4) ='2021'
group by checkTime

 select
   monthTable.dateForMonth,
   case when dataTable.totalNum is null then 0 else dataTable.totalNum end totalNum
   from
   (
    SELECT DATE_FORMAT(DATE_ADD(
       CONCAT(YEAR(DATE(CONCAT('2021','-12-01'))),'-01-01'),INTERVAL (CAST( help_topic_id AS SIGNED INTEGER )) MONTH ),'%Y-%m') dateForMonth
    FROM mysql.help_topic
    WHERE help_topic_id < 12
    ORDER BY dateForMonth
    ) AS monthTable
    left join
    (select
       left(created_time,7) AS checkTime,
        count(1) AS totalNum
  from student_info
  where left(created_time,4) ='2021'
  group by checkTime) AS dataTable
  on monthTable.dateForMonth = dataTable.checkTime