题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select music_name
from music_likes m1
join follow m2
on m1.user_id = m2.follower_id
join music m3
on m1.music_id = m3.id
where m2.user_id = '1' and m1.music_id not in (
select music_id
from music_likes
where user_id = '1'
)
group by id
order by id