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

-- music表中应该是默认没有重复的歌曲，所以不用distinct也可以
select music_name
from music
where id in (
    select music_id
    from music_likes
    where user_id in (
        select follower_id
        from follow
        where user_id = 1
    )
    and music_id not in (
        select music_id
        from music_likes
        where user_id = 1
    )
)
order by id