In SQL problem "Appartments" it requires calling 'AVG' to calculate average for a particular column | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

In SQL problem "Appartments" it requires calling 'AVG' to calculate average for a particular column

However when I test the code it returns an error : " aggregate functions are not allowed" Can someone help me find the issue ?

4th Nov 2021, 2:37 PM
Toy
2 Answers
+ 2
select avg(score) as avg from sam_grades where semester=1 -- Keep learning & happy coding :D
4th Nov 2021, 3:24 PM
SoloProg
SoloProg - avatar
+ 1
Oh thx SoloProg
4th Nov 2021, 3:36 PM
Toy