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

select music_name from(
select distinct music_id from(
select follower_id
from follow
where user_id = 1) as t1
left join music_likes ml on t1.follower_id = ml.user_id
where music_id not in (select music_id from music_likes ml2 where user_id = 1)
order by music_id) as t2
left join music on t2.music_id = music.id

层层筛选