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

select   
             t4.music_name
from
                music_likes t3
    inner join  music   t4  on  t3.music_id = t4.id
where t3.user_id in(
    select
                follower_id
    from
                    follow  
    where
                user_id = 1
)  and t3.music_id not in (
    select
            music_id
from
            music_likes
where
            user_id = 1
)
group by    t4.music_name,t3.music_id
order by    t3.music_id