题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select music_name
FROM(
select
music_name,
m.id
from music m
join music_likes ml on m.id = ml.music_id
where user_id in (select
follower_id
from follow
where user_id = 1
)
)b
where music_name not in(select
music_name
from music m
join music_likes ml on m.id = ml.music_id
where user_id = 1
)
group by id
order by id
从0开始的SQL之旅 文章被收录于专栏
从0开始的SQL之旅
拼多多集团-PDD二面350人在聊