题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select distinct music_name
from music
where id in (select c.music_id
from(select
a.user_id as a_id,
a.follower_id,
b.user_id as b_id,
b.music_id
from
(follow a)
inner join music_likes b
on a.user_id = 1 and a.follower_id = b.user_id) AS c
where c.music_id not in (SELECT DISTINCT music_id
FROM music_likes
WHERE user_id=1))
查看1道真题和解析