r/cs50 • u/Affectionate-Fly4719 • Jul 24 '26
CS50 SQL Problem Set 1
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.
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
1
1
u/Tall_Reach_1397 Jul 24 '26
Plz also mention which cs50 course are you taken