search

cs50 / problems

Checks for check50
145 stars 238 forks source link

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

Open chriscarrollsmith opened 4 months ago

chriscarrollsmith commented 4 months ago

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;