with recursive bacon_movies as (
        select
            a.id as actor_id
            , 0 as bacon_degree
        from
            actors a
        where
            a.name = 'Kevin Bacon'
        union
        select
            r1.actor_id
            , b.bacon_degree + 1 as bacon_degree
        from
            bacon_movies b
        join roles r on r.actor_id = b.actor_id
        join roles r1 on r.movie_id = r1.movie_id and r1.actor_id <> b.actor_id
        where b.bacon_degree < 6
    )
    select
        a.name
        , min(b1.bacon_degree) as bacon_degree
    from bacon_movies b1
    join actors a on a.id = b1.actor_id
    group by a.name
    order by bacon_degree asc;