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

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))