07-CS50-CÓDIGO - SQL - MOVIE - 13

-- listar os nomes de todas as pessoas que estrelaram um filme no qual Kevin Bacon também estrelou --

SELECT DISTINCT people.name
FROM people
  JOIN stars ON people.id = stars.person_id
WHERE stars.movie_id IN (
  SELECT stars.movie_id
  FROM stars
    JOIN people ON people.id = stars.person_id
  WHERE people.name = "Kevin Bacon" AND people.birth = 1958
) AND people.name != "Kevin Bacon"