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

select music_name from (select  distinct music_id,music_name
from follow f
         join (select *
               from music_likes ml
                        join music m on m.id = ml.music_id) a on follower_id = a.user_id
where f.user_id = 1
  and music_name not in (select music_name
                         from music_likes ml
                                  join music m on m.id = ml.music_id
                         where user_id = 1)
order by music_id) a;