题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select e.music_name from (select distinct m.id,m.music_name from follow f join music_likes ml on ml.user_id = f.follower_id join music m on m.id = ml.music_id where f.user_id = 1 and ml.music_id not in (select music_id from music_likes where user_id = 1) ) e order by e.id 此处需要注意，去重和order by同时出现时要配合，必须是两边都存在的字段
