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

with t1 as(
    select distinct 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
    )
)
select m.music_name
from t1
join music m on t1.music_id=m.id
order by m.id asc;

注意：当select中有distinct时，同时需要order by m.id，则select中需要有m.id