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

select distinct(m.music_name)
from music_likes as ml
left join music as m
on ml.music_id=m.id
where ml.user_id in 
(
 SELECT distinct(follower_id)
 from follow 
 where user_id=1
)
and ml.music_id not in
(
 select distinct(music_id)
 from music_likes
 where user_id=1
)
order by m.id;