What is SUM and AVG used for?

Parthiban Kannan

Updated on January 8, 2026

< 1 min read

SUM is used to calculate the total of numeric values across rows.
AVG is used to calculate the average value of a numeric column.
They are commonly used in financial and performance reporting.
In my project, SUM was used to calculate total revenue.
AVG was used to find average order value per customer.
Both functions are typically combined with GROUP BY.
They help convert raw data into meaningful business metrics.