select year(入学日期) as 入学年份,count(*) as 人数
from students
group by year(入学日期)
从students表中分组统计出每个年份入学的学生人数。
select year(入学日期) as 入学年份,count(*) as 人数
from students
group by year(入学日期)
从students表中分组统计出每个年份入学的学生人数。
