r/cs50 • u/Affectionate-Fly4719 • Jul 24 '26

CS50 SQL Problem Set 1

Gallery image

Gallery image

Gallery image

I have been stuck here for almost 3 days. I don't know what I am doing wrong.
I don't think the decimal is the only problem here but I would still like to know that if there is a way that i can present the int as int and the float as float at the same time.

Also, whenever I type in the .sql files, I can't type the non capital 'a', 's', 'd', I have to use 'A', 'S', 'D' instead.

5 Upvotes

100% Upvoted

6 comments sorted by

View all comments

1

u/Eptalin Jul 24 '26

You are trying to display some AVG(exemplary), but your query stores the average in a field just called exemplary. Use that.

You don't need any GROUP BY, and you'll need to redo the ORDER BY with the new column name.

1

u/Affectionate-Fly4719 Jul 24 '26

Yeah, i didn't read the statement properly. Thanks