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

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