SQL 练习32

  • 查询不及格的课程
SELECT * from Course WHERE CId IN (SELECT cid from sc WHERE score < 60 GROUP BY cid)

image

posted @ 2021-08-20 17:41  弩哥++  阅读(30)  评论(0)  编辑  收藏  举报