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

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