用SQL语句如何列出各班平均成绩的前30%?班级在名为student的表上,各科成绩在名为score的表上.

select * from student where sno in
(select top 30 percent sno from score group by sno
order by avg(grade) desc)