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