I can't figure out why my pset7 movies Q12 code isn't working. Can anyone tell me why?

Here is my code:

SELECT DISTINCT title FROM movies, stars, people WHERE movie_id IN (SELECT movie_id FROM stars WHERE person_id IN (SELECT id FROM people WHERE id = (SELECT id FROM people WHERE name = "Johnny Depp" OR name = "Helena Bonham Carter"))) AND stars.movie_id = movies.id AND stars.person_id = people.id ORDER BY title;

This code looks correct but it doesn't work, and I don't get why. Please help me! Thank you!

1 Answer 1


I used JOIN instead of nesting so many SELECTs

You must log in to answer this question.

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