查询平均成绩大于60分的同学的学号和平均成绩

select S_ID,avg(score) from sc group by S_ID having avg(score) >60;

原文地址:https://www.cnblogs.com/Sorry-/p/14030224.html