Grouping & Business KPIs

📋 Source Dataset (4 Sample Records)

1. COUNT & AVG Functions

Definition: COUNT tallies total logged profiles while AVG calculates the numerical mathematical mean within grouped segments.

SELECT department, COUNT(*) AS emp_count, AVG(salary) AS avg_sal 
FROM employees 
GROUP BY department;

2. SUM & MAX Aggregations

Definition: SUM calculates full financial expense pipelines, while MAX extracts peak values per sector group.

SELECT city, SUM(salary) AS total_budget, MAX(salary) AS max_sal 
FROM employees 
GROUP BY city;

3. HAVING Filter Clause

Definition: Evaluates filter logic strictly after aggregation groups are built (since WHERE cannot handle summary functions).

SELECT department, AVG(salary) AS average_salary 
FROM employees 
GROUP BY department 
HAVING AVG(salary) > 70000;