AVG Computes the Mean

`AVG` calculates the average value of a numeric column.

SELECT AVG(amount) AS average_sale
FROM sales

`AVG` is useful when you want a typical value instead of a total or an extreme. For example, it can tell you the average sale size or average score.

`AVG` ignores `NULL` values, just like `SUM`.