题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
http://www.nowcoder.com/questionTerminal/048ed413ac0e4cf4a774b906fc87e0e7
select c.music_name
from follow a
left join music_likes b on a.follower_id = b.user_id
left join music c on b.music_id = c.id
where a.user_id = 1
and c.music_name not in
(select distinct c.music_name from music_likes b
left join music c on b.music_id = c.id where b.user_id = 1)
group by c.id
order by c.id asc
美团公司福利 3017人发布