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

select music_name from ( select distinct music_id, music_name

from ( select f1.user_id,f1.follower_id,ml.music_id,mc.music_name from follow as f1 join music_likes as ml

on f1.follower_id = ml.user_id join music as mc on ml.music_id = mc.id

where ml.music_id not in ( select ml.music_id from follow as f1 join music_likes as ml

on f1.user_id = ml.user_id where f1.user_id = 1 ) ) cc1 where cc1.user_id = 1) cc2 order by music_id