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

select t.music_name from (select distinct
    msc.id,msc.music_name
from
    follow f
    inner join music_likes m on f.follower_id = m.user_id
    inner join music msc on m.music_id = msc.id
where
    f.user_id = 1
    and msc.id not in (
        select
            music_id
        from
            music_likes
        where
            user_id = 1
    )
order by
    msc.id
) t