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

select distinct music_name
from music m
where m.id in (
    select music_id
    from music_likes
    where user_id in 
    (
        select f.follower_id 
        from follow f
        where f.user_id = 1
    ) and 
    music_id not in
    (
        select music_id
        from music_likes
        where user_id = 1
    )
    order by music_id
);