题解 | 网易云音乐推荐(网易校招笔试真题)

SELECT m.music_name
FROM music m
WHERE EXISTS (
    SELECT 1
    FROM follow f
    JOIN music_likes ml ON f.follower_id = ml.user_id
    WHERE f.user_id = 1
      AND ml.music_id = m.id
)
AND NOT EXISTS (
    SELECT 1
    FROM music_likes self
    WHERE self.user_id = 1
      AND self.music_id = m.id
)