? MySQL COUNT, SUM, MIN, MAX, AVG

? Quick Overview

MySQL aggregate functions summarize data across multiple rows and return a single value. They are commonly used with GROUP BY to analyze datasets efficiently.

? Key Concepts

• COUNT() counts rows
• SUM() totals numeric values
• MIN() finds smallest value
• MAX() finds largest value
• AVG() calculates averages

? Syntax / Theory

// General aggregate function syntax
SELECT FUNCTION(column_name)
FROM table_name;

? COUNT()

// Count total rows in employees table
SELECT COUNT(*) FROM employees;

? SUM()

// Calculate total salary of employees
SELECT SUM(salary) FROM employees;

? MIN()

// Find minimum salary value
SELECT MIN(salary) FROM employees;

? MAX()

// Find maximum salary value
SELECT MAX(salary) FROM employees;

? AVG()

// Calculate average employee salary
SELECT AVG(salary) FROM employees;

? Live Output / Explanation

Each query returns a single numeric result representing a summary of the selected column values.

? Interactive Example

Try combining aggregate functions with GROUP BY to analyze department-wise salary statistics.

? Use Cases

• Payroll and finance summaries
• Sales and revenue analytics
• Employee performance metrics