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

可以直接做多个JOIN

SELECT music_name
FROM (
    SELECT DISTINCT m.id, m.music_name
    FROM follow f
    JOIN music_likes ml ON f.follower_id = ml.user_id
    JOIN music m ON ml.music_id = m.id
    WHERE f.user_id = 1
      AND ml.music_id NOT IN (
            SELECT music_id
            FROM music_likes
            WHERE user_id = 1
      )
) t
ORDER BY t.id;