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

with t1 as (select distinct
    a.user_id,
    a.follower_id,
    b.music_id
from
    follow a
    left join music_likes b on a.follower_id = b.user_id
where
    a.user_id = 1
    and b.music_id not in(
        select
            music_id
        from
           music_likes 
        where
            user_id = 1
    )),

t2 as (select distinct
    b.id,
    b.music_name
from t1
left join music b on t1.music_id=b.id
order by b.id asc)

select
    music_name
from t2