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

select music_name from music
where id in (select distinct(music_id) from music_likes
where user_id in (select follower_id from follow
where user_id=1))
and id not in (select music_id from music_likes
where user_id=1)
order by id