题解 | #网易云音乐推荐(网易校招笔试真题)#

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