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

with t as 
(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 m
where user_id = "1" )),

t2 as (select m.music_name, t.music_id
from music m right join t 
on m.id = t.music_id
),

t3 as (select distinct music_name, music_id from t2 
order by music_id)

select music_name from t3