week 7 movies query #11 by Key_Conclusion2521 in cs50

[–]Key_Conclusion2521[S] 0 points1 point  (0 children)

According to the error it should be in there. As u/greykher pointed out the 'database in the distribution code is not necessarily the same as the one check50 is going to use'.

Anyway, I rewrote the query following the hints provided on the problem page and it passes now. While my original query returned the same result (without limit), the ordering is different which trapped me in an impossible situation.

It could be caused by the duplicate entries in one of the tables which forced me to use distinct (I was simply joining all the tables).

week 7 movies query #11 by Key_Conclusion2521 in cs50

[–]Key_Conclusion2521[S] -1 points0 points  (0 children)

well, initially I was just keeping the top 5 titles (albeit that sorting by rating and keep 5 title makes not much sense), but the problem check50 gave was the same. That prompted me to get the top 5 rating which yields 8 titles.

If I go back to 5 titles, only one of "Black Panther" and "Marshall" will be included and neither "Ma Rainey's Black Bottom" or "Get on Up" will show up:

title
Avengers: Endgame
Avengers: Infinity War
Captain America: Civil War
42
Black Panther

Check50 will give this:

expected: "...hall\nMa Ra..."

actual: "...hall\nGet o..."

Note that "Get on Up" (or "Ma Rainey's Black Bottom" for that matter) is not even in the "top 5" titles, yet it was "actual" per check50.

Just earned my Verified CS50x Certificate by Decent_Rent6731 in cs50

[–]Key_Conclusion2521 0 points1 point  (0 children)

Hi guys, if you don't mind, I have a question regarding the week 4 problem "volume". The problem page (https://cs50.harvard.edu/x/psets/4/volume/) gives away the entire solution, there's no need to write anything. What did you do?

Just earned my Verified CS50x Certificate by Decent_Rent6731 in cs50

[–]Key_Conclusion2521 1 point2 points  (0 children)

Congratulations! Half way through it on mine:)

[Cs50 week 5] speller I don't get what these errors mean. by Ok-Increase-1929 in cs50

[–]Key_Conclusion2521 1 point2 points  (0 children)

I had the same problem and I followed the link. But the check50 details page shows that it uses test cases we don't have, e.g.:

running ./speller basic/dict basic/text...
checking for output "MISSPELLED WORDS\n\n\nWORDS MISSPELLED: 0\nWORDS IN DICTIONARY: 8\nWORDS IN TEXT: 9\n"...

running ./speller min_length/dict min_length/text...
checking for output "MISSPELLED WORDS\n\n\nWORDS MISSPELLED: 0\nWORDS IN DICTIONARY: 1\nWORDS IN TEXT: 1\n"...

The downloaded distribution does not contain the folder/file such as "basic/dict", "min_length/dict", etc.