Pset7 8.sql is not giving output

Question

i am in problem set 7 now, and i'm stuck in '8.sql'. Specifications is to write a SQL query to list the names of all people who starred in Toy Story. When i run my code, i get no output, i have written this as my code:

SELECT title FROM people 
JOIN stars ON people.id = stars.person_id 
JOIN movies ON stars.movie_id = movies.id 
WHERE movies.title = "Toy Story%";

I can't seem to find anything wrong about my code above and yet it does not give me output. Thanks in advance.

Answer 1

Ok, nevermind i found it. It was literally a "%" after the 'Toy Story' in the last line of movies.title.

But then it printed out 'Toy Story' in the output of 4 rows instead of the people who starred. I accidentally wrote SELECT title FROM people instead of SELECT name FROM people.

Sorry for wasting your time.