Question

sql语句求助，查询平均成绩大于70的学生学号和平均成绩

如题，表sc中有sno、score两个字段，并要求把查询出的结果插入到good表中

Answer 1

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

Answer 2

Select sno,avg(score) as avgscore into good From sc group by sno Having avg(score)>70