SQL Avg Function


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 | +-----------+------------------+----------------+

This article needs improvement. You can help improve this article. You can also write similar articles and help the community.