This article provides an example to display average item price of item table using avg() function.
Selectavg(itemprice) from item; Output: AVG(ITEMPRICE) -------------- 317