select sno,avg(score) as 平均成绩 from sc where avg(score)>70 group by sno into table good
Select sno,avg(score) as avgscore into good From sc group by sno Having avg(score)>70
