Stack Exchange Network
Stack Exchange network consists of 181 Q&A communities including
Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
CS50 Stack Exchange is a question and answer site for students of Harvard University's CS50. It only takes a minute to sign up.
Sign up to join this community
Anybody can ask a question
The best answers are voted up and rise to the top
3 years ago
when writing a query to produce a table that lists the titles of all movies with a release date on or after 2018, in alphabetical order I produce a table with 35,755 rows. The CS50 pset states that I should have 35,775 rows. Could anyone help me work out why I am not selecting 20 of the tiles?
my query is:
SELECT title FROM movies
WHERE year > 2017
ORDER BY title;
Thanks in advance.
Mar 11, 2020 at 23:15
Where did you find the number of 35,775? On
https://cs50.harvard.edu/x/2020/psets/7/movies/, I find
3.sql results in a table with 1 column and 35,755 rows.
Maybe a typo on their end in some older version.
Mar 12, 2020 at 21:01
20.8k 2 2 gold badges 11 11 silver badges 22 22 bronze badges
log in to answer this question.
Not the answer you're looking for? Browse other questions tagged
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our
Accept all cookies
Necessary cookies only
>2018? Next, run the following query on your db to see if there's any missing data:
select count from movies where year >2017. If the count is low, then data is missing. Try deleting and reloading the db.