select Rname from report group by Rname having min(Rmark)>=80;(查询每门成绩都大于80分以上的学生)
select Rname from report group by Rname having min(Rmark)>=80;(查询每门成绩都大于80分以上的学生)
select Rname,avg(Rmark) from report GROUP BY Rname HAVING avg(Rmark)>80;查询平均成绩大于80分以上的学生