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

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