题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select music_name
from (
select follower_id
from follow
where user_id=1
) a join music_likes b on a.follower_id=b.user_id
join music c on b.music_id=c.id
where music_id not in (select music_id from music_likes where user_id=1)
group by c.id, music_name
order by c.id
，接着当手孝子