题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select music_name from
music m
where m.id in(
select
ml.music_id
from follow f
left join music_likes ml
on f.follower_id = ml.user_id
where f.user_id = 1
)
and m.id not in (select music_id from music_likes where user_id = 1)
为什么这个是最低通过率的sql题
查看10道真题和解析