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

select
    music_name
from
    music
where
    id in (
        SELECT DISTINCT
            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
            )
    )
    order by id asc