select a.class,count(b.student) as '学生数量'from grade as a left join student as bon a.class = b.classgroup by a.class
