Oracle 4种等价SQL

SELECT COUNT (1) FROM (SELECT k001 FROM ( SELECT k001 FROM kbib GROUP BY k001) k
WHERE NOT EXISTS ( SELECT 1 FROM ( SELECT k003 FROM calb GROUP BY k003) c WHERE k.k001 = c.k003))

SELECT COUNT (1) FROM (SELECT k001 FROM ( SELECT k001 FROM kbib GROUP BY k001) k
WHERE NOT EXISTS ( SELECT k003 FROM calb WHERE k.k001 = k003 GROUP BY k003))

SELECT count (1) FROM (SELECT * FROM ( SELECT k001 FROM kbib GROUP BY k001) k
WHERE k.k001 NOT IN ( SELECT k003 FROM calb c WHERE k.k001 = c.k003 GROUP BY k003))


SELECT count (1) FROM (SELECT * FROM ( SELECT DISTINCT k001 FROM kbib) k
WHERE k.k001 NOT IN ( SELECT DISTINCT k003 FROM calb c WHERE k.k001 = k003))