4.sql

来自「ssd7的练习1」· SQL 代码 · 共 14 行

SELECT memno,fname,lname
FROM member
WHERE memno IN (
    SELECT DISTINCT borrowermemno
    FROM book
    WHERE callnumber IN (
        SELECT callnumber
        FROM Author
        WHERE lname = 'Collins'
        )
    GROUP BY borrowermemno
    HAVING COUNT(DISTINCT callnumber) = 2
);