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