0

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.

2

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.

1
  • 1
    This helped me, so don't say you're sorry! – Anna-Aleksandra Jul 28 '20 at 15:47

You must log in to answer this question.

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