查询Score表中至少有5名学生选修的并以3开头的课程的平均分数:
select avg(degree),cno
from score
where cno like '3%'
group by cno
having count(sno)>= 5;
查询Score表中至少有5名学生选修的并以3开头的课程的平均分数:
select avg(degree),cno
from score
where cno like '3%'
group by cno
having count(sno)>= 5;
转载于:https://www.cnblogs.com/gaara-zhang/p/8611026.html