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

select
    t2.music_name
from
(select
    m.id,
    m.music_name
from 
    (select 
        distinct 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)
    ) t1
left join 
    music m 
on 
    t1.music_id=m.id
order by 
    t1.music_id asc
) t2