SELECT o.*
FROM 订单表 o
WHERE o.客户ID IN (
    SELECT DISTINCT 客户ID
    FROM 订单表 o
    JOIN 面包表 b ON o.面包ID = b.面包ID
    WHERE b.面包名称 = '全麦吐司'
)
AND NOT EXISTS (
    SELECT 1
    FROM 订单表 o2
    JOIN 面包表 b2 ON o2.面包ID = b2.面包ID
    WHERE o2.订单ID = o.订单ID
    AND b2.面包名称 = '全麦吐司'
);
SELECT DISTINCT c.客户ID, c.姓名, c.会员等级
FROM 客户表 c
JOIN 订单表 o ON c.客户ID = o.客户ID
WHERE o.数量 > 50;SELECT e.姓名, e.职位
FROM 员工表 e
WHERE e.基本工资 > (SELECT AVG(基本工资) FROM 员工表);SELECT TOP 1 e.姓名, e.生日, e.基本工资
FROM 员工表 e
ORDER BY e.生日 DESC;SELECT c.姓名, c.联系电话
FROM 客户表 c
WHERE c.客户ID NOT IN (
    SELECT DISTINCT o.客户ID
    FROM 订单表 o
    JOIN 面包表 b ON o.面包ID = b.面包ID
    WHERE b.面包名称 = '巧克力面包'
);