0

i have tried to exclude the name from the list but most of the solution aren't doing anything. anyone have idea how to solve.

SELECT name  FROM movies JOIN 
stars ON movies.id=stars.movie_id JOIN
people ON stars.person_id = people.id
WHERE movie_id IN(SELECT movie_id FROM movies JOIN 
stars ON movies.id=stars.movie_id JOIN
people ON stars.person_id = people.id
WHERE name ="Kevin Bacon" AND birth=1958) 
Group BY name"
1

Use

and person_id not in (select id from people where name ="Kevin Bacon" AND birth=1958)

before the group statement. Also, Use "select distinct" on first line in place of "select".

If this helped, please click the tickmark.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .