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

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

posted @ 2020-11-24 14:42  抬头就能看到阳光  阅读(885)  评论(0编辑  收藏  举报