代码:
select sc.cno '课程号',cname '课程名',Max(grade) '最高成绩',min(grade) '最低成绩',avg(grade) '平均成绩'
from sc left join cou on sc.cno=cou.cno
group by sc.cno,cname
having count(*)>=2 and min(grade)>=60 and count(*) = count(grade)
ps:
count(*) = count(grade)是为了去null