SQL > SQL Functions >
SQL uses the AVG( ) function to calculate the average of a column. The syntax for using this function is,
For example, if we want to get the average of all sales from the following table,
we would type in,
SELECT AVG(Sales) FROM Store_Information;
687.5 represents the average of all Sales entries: (1500 + 250 + 300 + 700) / 4.