Here are the parameters for running a SQL query in the file 9.sql:
In 9.sql, write a SQL query to list the names of all people who starred in a movie released in 2004, ordered by birth year.
Your query should output a table with a single column for the name of each person.
People with the same birth year may be listed in any order.
No need to worry about people who have no birth year listed, so long as those who do have a birth year are listed in order.
If a person appeared in more than one movie in 2004, they should only appear in your results once.
Here is what my file currently looks like:
SELECT DISTINCT name FROM people, stars, movies WHERE people.id = stars.person_id AND stars.movie_id = movies.id AND year = 2004 ORDER BY birth ASC;
When I plug the query into phpliteadmin, it shows 17,965 rows, while the pset assignment explains that testing the query should output 18,013 rows. I'm wondering if anyone ran into this same issue and knows what the solution is.