SQL 经典题型解答(3)

11、查询没有学全所有课程的同学的信息

SELECT
    b.* 
FROM
    student b 
WHERE
    b.S IN (
    SELECT
        a.s 
    FROM
        ( SELECT a.S s, COUNT( a.C ) NUM FROM sc a GROUP BY a.s ) a 
    WHERE
    a.NUM NOT IN ( SELECT COUNT( Cname ) FROM course ) 
    )SELECT
    b.* 
FROM
    s