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

select music_name
from(
    select distinct music_likes.music_id musicid
    from(
        select follower_id from follow
    where user_id=1
    )t join music_likes on t.follower_id= music_likes.user_id
    WHERE NOT music_id IN(
        select music_id from music_likes
        where user_id=1
    )
    order by music_likes.music_id
)t3 left join music on music.id = t3.musicid