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

with a as(
    select distinct music_id
from (
    select follower_id
    from follow
    where user_id=1) f 
    join music_likes on f.follower_id=music_likes.user_id 
)
select music_name
from (
    select *
    from a
    where music_id not in(
        select music_id
        from music_likes
        where user_id=1)
) temp join music on music.id=temp.music_id
order by id;