题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
http://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select distinct m.music_name from music_likes ml
join follow f on ml.user_id = f.follower_id
join music m on m.id = ml.music_id
where f.user_id = 1 and (f.user_id, ml.music_id) not in (select user_id, music_id from music_likes)
order by m.id asc
中移(苏州)软件技术有限公司工作强度 29人发布
投递哔哩哔哩等公司10个岗位
