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

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