SQL : 练习题-30题

查询存在不及格的课程
可以用group by 来取唯一，也可以用distinct

select cid from sc
where score< 60
group by cid;

select DISTINCT sc.CId
from sc
where sc.score <60;