非单调SQL查询(查找只喜欢某些内容的名称)

-- 用户表
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(100)
);

-- 喜好表
CREATE TABLE preferences (
    user_id INT,
    content_id INT,
    PRIMARY KEY (user_id, content_id),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

-- 插入用户数据
INSERT INTO users (id, name) VALUES (1, 'Alice'), (2, 'Bob'), (3, 'Charlie');

-- 插入喜好数据
INSERT INTO preferences (user_id, content_id) VALUES 
(1, 101), (1, 102),
(2, 101),
(3, 102);

SELECT u.name 
FROM users u 
WHERE u.id IN (
    SELECT p.user_id 
    FROM preferences p 
    WHERE p.content_id = 101
) 
AND u.id NOT IN (
    SELECT p.user_id 
    FROM preferences p 
    WHERE p.content_id <> 101
);