AVG()
The AVG()
function is used to find the mean, or average, value of a column. For example, if you want to find the average of the attendance, we can run this query.
xxxxxxxxxx
SELECT MAX(Attendance) FROM Class;
OUTPUT
:001 > Cmd/Ctrl-Enter to run, Cmd/Ctrl-/ to comment