CODE EXAMPLE FOR SQL

oracle avg

SELECT AVG(col_name) FROM table_name;

SELECT customer, AVG(prices)
 FROM buys
 GROUP BY customer;