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

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