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

select a.music_name from (select distinct m.music_name,m.id
from music_likes l join follow f join music m 
 on l.user_id=f.follower_id and f.user_id=1 and l.music_id=m.id 
 order by m.id) as a where a.id not in( select music_id from music_likes where user_id=1)