题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select music_name from follow f join music_likes l on f.follower_id=l.user_id join music m on l.music_id=m.id where f.user_id=1 and music_name not in(select distinct music_name from follow f join music_likes l on f.user_id=l.user_id join music m on l.music_id=m.id where f.user_id=1) group by m.id order by m.id#sql刷题#