题解 | #网易云音乐推荐(网易校招笔试真题)#

#关注用户喜欢的音乐
select  mn1 music_name
from
(select distinct music_name mn1,m.id md
from follow f left join music_likes ml on f.follower_id = ml.user_id 
left join music m on ml.music_id=m.id
where f.user_id=1) t1
where t1.mn1 not in
# 自己喜欢的音乐
(select music_name mn2
from music_likes ml left join music m on ml.music_id=m.id
where ml.user_id=1)
order by t1.md asc