题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select m.music_name from music m where m.id not in (select music_id from music_likes where user_id = 1) and m.id in (select music_id from music_likes where user_id in (select follower_id from follow where user_id = 1))
这么写应该是相对简洁的了,感觉不用太复杂的代码
