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.

Improve this question

1 Answer 1

Reset to default
3

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.

Improve this answer
1
  • 1
    This helped me, so don't say you're sorry! Commented Jul 28, 2020 at 15:47

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.