题解 | 网易云音乐推荐(网易校招笔试真题)
网易云音乐推荐(网易校招笔试真题)
https://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select music_name
from (select distinct music_name ,a.music_id
from (
select music_id
from music_likes
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
)
) a
join music on a.music_id =music.id
) b
order by music_id
