📊 SQL AVG() Function: Calculate the Average Value in SQL

The SQL AVG() function is an essential aggregate function used to calculate the average value of a numeric column. Whether you’re analyzing sales, ratings, or other performance metrics, AVG() helps you understand central tendencies in your data.

In this comprehensive guide, you’ll learn:

✅ What the SQL AVG() function does
📘 Syntax and usage
💡 Real-world examples for hands-on learning
⚙️ Best practices and performance tips

📘 What is SQL AVG()?

The AVG() function returns the average of non-null numeric values in a column.

🔧 Syntax:

SELECT AVG(column_name)
FROM table_name
WHERE condition;

💡 Note: The AVG() function ignores NULL values during calculation.

🔍 SQL AVG() Function Example

Example: Calculate the Average Salary

SELECT AVG(salary) AS average_salary
FROM employees;

📌 Explanation:

This query returns the average salary of all employees in the employees table.
AS average_salary renames the output column for clarity.

🎯 Use AVG() with GROUP BY

You can use AVG() alongside the GROUP BY clause to compute averages per category.

Example: Average Salary by Department

SELECT department_id, AVG(salary) AS avg_salary
FROM employees
GROUP BY department_id;

🔍 This query shows the average salary for each department.

💥 Combine AVG() with WHERE Clause

You can filter data before averaging.

Example: Average Salary of Employees in a Specific Department

SELECT AVG(salary) AS avg_sales_salary
FROM employees
WHERE department_id = 3;

❗ Exclude NULL Values

The AVG() function automatically excludes NULL values from its calculation.

Example: Safe Average Calculation

If some employees don’t have a salary entered:

SELECT AVG(salary) AS avg_salary
FROM employees;

✅ Only non-null salaries are used in the result.

🧠 Real-World Use Cases

📈 Average revenue per customer
⭐ Average product rating
🏆 Average exam score by subject
💰 Average order value in e-commerce

⚠️ Performance Tips

Ensure the column you’re averaging is indexed if used with WHERE.
Use CAST() if you’re averaging integers and need decimal precision:

SELECT AVG(CAST(salary AS DECIMAL(10,2))) FROM employees;

📌 Summary

The SQL AVG() function is perfect for:

Measuring central tendencies
Summarizing numeric data
Creating powerful dashboards and insights

Once you master AVG(), you can combine it with GROUP BY, JOIN, and other aggregate functions for even deeper analysis.

AVG Function