给一个班级成绩表 student (name,subject,score) ,

查询出所有总分数>600分的学员

select name,sum(score) from student group by name having sum(score)>600;

select name,sum(score) s from student group by name having sum(score)>600 and min(score)>60 order by s desc;

select name from student  where score<60 group by name having count(name)>=3;