假设s#为学号（主键）classno(班级号） 学生表students
select classno,count(s#)as sumstudent from students group by classno
