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

select
    a.music_name
from
    (
        SELECT distinct
            music_name,
            id
        from
            test.follow tf
            join test.music_likes ml on tf.follower_id = ml.user_id
            join test.music mu on ml.music_id = mu.id
        where
            tf.user_id = 1
    ) a
where
    a.music_name not in (
        select
            music_name
        from
            test.music_likes ml
            join test.follow fo on ml.user_id = fo.user_id
            join test.music mu on ml.music_id = mu.id
        where
            ml.user_id = 1
    )
order by
    a.id