![](https://csdnimg.cn/release/download_crawler_static/89270368/bg1.jpg)
P103
第十题
(3)SELECT 职工号,姓名
FROM 职工 WHERE 职工号 IN (SELECT 职工号
FROM 参加 WHERE 编号 IN (SELECT 编号 FROM 社会 团体 WHERE
名称='唱歌队' OR 名称=‘篮球队’))
(4)SELECT *
FROM 职工
WHERE 职工号 NOT IN (SELECT 职工号 FROM 参加)
(5)SELECT *
FROM 职工
WHERE NOT EXISTS (SELECT *
FROM 社团 WHERE NOT EXISTS(SELECT *
FROM 参加 WHERE 职工、职工号=职工号 AND 社团、编号=编号))
(6)SELECT *
FROM 职工
WHERE NOT EXISTS (SELECT *
FROM 参加 A
Where A、职工号=‘1001’ and not exists
(select *
From 参加 B
Where 职工、职工号=B、职工号 and A、编号=B、编号))