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

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