CS50 PSET7 Movies "query did not return results" 12.sql

Question

First timer asking on Stack Exchange. I have a SQL query that returns 6 results in the terminal but does not work with check50 resulting in

"Query did not return any results"

I read in a similar question using to swop from using IDs to using the names of the actors instead. This does nothing to change the result in the VS code terminal but when I submit to check50 I still get the error.

The result I am expecting is

Alice Through the Looking Glass
Alice in Wonderland
Charlie and the Chocolate Factory
Corpse Bride
Dark Shadows
Sweeney Todd: The Demon Barber of Fleet Street

My code is here:

SELECT movies.title
FROM movies
INNER JOIN stars 
    ON stars.movie_id = movies.id
INNER JOIN people 
    ON people.id = stars.person_id
    WHERE people.id = 136
    INTERSECT
    SELECT movies.title
    FROM movies
    INNER JOIN stars 
        ON stars.movie_id = movies.id
    INNER JOIN people 
        ON people.id = stars.person_id
    -- HELENA BONHAM CARTER
    WHERE people.id = 307; 

Can anyone see any error in this code or is there something else I should consider.

Answer 1

Consider the potential problems that might result from hardcoding an id and running the query on a different database.

Hint: you know the name of the person to look for.