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

select
mc1.music_name
from(
SELECT 
distinct
mc.id,
mc.music_name 
FROM follow fw
left join music_likes ml on ml.user_id = fw.follower_id
left join music mc on mc.id = ml.music_id
WHERE fw.user_id = 1
AND ml.music_id NOT IN (SELECT music_id from music_likes where user_id = 1)
order by mc.id
) mc1
order by mc1.id