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

select distinct B.music_name from (select music_name from music_likes join music on music_likes.music_id = music.id where user_id =1)A
right join
(select distinct music_name,music.id from music_likes join music on music_likes.music_id = music.id where user_id in (select f.follower_id from follow f  where f.user_id=1) order by music.id)B#搜索喜欢的音乐
 on A.music_name=B.music_name where A.music_name is null