SQL Average (AVG) Function
“Average” is an Aggregate (Group By) Function. It’s used to calculate the average of a numeric column from the set of rows returned by a SQL statement.
Here is the syntax for using the function:
select groupingField, avg(num_field)
from table1
group by groupingField
- Here’s an example using the student table:
select studentID, FullName, avg(sat_score)
from student
group by studentID, FullName;
Result :
+-----------+------------------+----------------+ | studentID | FullName | avg(sat_score) | +-----------+------------------+----------------+ | 1 | Monique Davis | 400.0000 | | 2 | Teri Gutierrez | 800.0000 | | 3 | Spencer Pautier | 1000.0000 | | 4 | Louis Ramsey | 1200.0000 | | 5 | Alvin Greene | 1400.0000 | | 6 | Sophie Freeman | 1600.0000 | | 7 | Maximo Smith | 1800.0000 | +-----------+------------------+----------------+