SQL AVG (Average) Statement
The AVG command is again used with the select statement, and delivers the average value of range of integers. The command is used thus:-
SELECT AVG (Balance) As Avg_Balance
FROM SecA_Bal
WHERE Balance >0;
This will deliver a result called Avg_Balance which will be the average amount owed by customer, ignoring customers whose accounts are in debit.
