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

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