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

select
   music_name
from
    (
        select
            music_id
        from
            music_likes ml
        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
            )
    ) as l
    join music m on l.music_id = m.id
    group by music_name,m.id
    order by m.id asc