题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
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
层层筛选
