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

select
    music_name
from
    music
where
    id in (
        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
                where
                    user_id = 1
            )
        order by
            music_id
    )