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

SELECT sub_t.music_name
FROM(
    SELECT DISTINCT a.music_id,b.music_name
    FROM music_likes a
    INNER JOIN music b
    ON a.music_id = b.id
    WHERE user_id IN(
        SELECT follower_id
        FROM follow
        WHERE user_id = 1
    )
    AND a.music_id NOT IN(
        SELECT music_id
        FROM music_likes
        WHERE user_id = 1)
)sub_t
ORDER BY sub_t.music_id