题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select distinct music_name from ( select f.user_id, f.follower_id, l.music_id, m.music_name from follow f, music_likes l, music m where f.follower_id=l.user_id and l.music_id=m.id and f.user_id=1 group by f.user_id, f.follower_id, l.music_id order by music_id ) a where music_id not in (select music_id from music_likes where user_id =1)
投递吉利控股等公司10个岗位
OPPO成长空间 895人发布