Check50 passes incorrect solution for 'movies' using distinct name instead of id

[chriscarrollsmith]

Instructions for 'movies' include this line:

"Executing 9.sql results in a table with 1 column and 19,325 rows."

My initial, incorrect solution passed check50 even though it returned only 19,261 rows. (My error was in using DISTINCT on 'name' rather than 'id', which evidently excludes some distinct people who have identical names.)

Here's the incorrect solution that passed the check:

SELECT DISTINCT(name)) FROM people JOIN stars ON people.id = stars.person_id WHERE movie_id IN (SELECT id FROM movies WHERE year = 2004) ORDER BY birth;