题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select music_name
from(
select distinct music_likes.music_id musicid
from(
select follower_id from follow
where user_id=1
)t join music_likes on t.follower_id= music_likes.user_id
WHERE NOT music_id IN(
select music_id from music_likes
where user_id=1
)
order by music_likes.music_id
)t3 left join music on music.id = t3.musicid
字节跳动一面294人在聊
查看30道真题和解析
影石Insta360公司氛围 6人发布
投递影石Insta360等公司10个岗位 >