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

select music_name
from music as t1 inner join 
(select distinct music_id
from music_likes
where user_id in (select follower_id from follow where user_id=1)
and music_id not in (select music_id from music_likes where user_id=1)) as t2
on t1.id=t2.music_id
order by id