SQL Quest › SQL Interview Questions › Aggregation & Grouping

Department Compensation Report

MediumFreeQuerying BasicsAggregation & GroupingConditional Logic

For departments with 3 or more employees, show: department, headcount, total_salary_budget (SUM), avg_salary (rounded to nearest dollar), max_salary, and high_performer_pct (% with performance_rating >= 4.0, 1 decimal). Sort by total_salary_budget descending.

Solve it in the browser editor →

Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect".

Schema

employees

emp_id	name	department	position	salary	hire_date	manager_id	performance_rating
1	Alice Johnson	Engineering	Senior Developer	95000	2019-03-15	5	4.5
2	Bob Smith	Engineering	Developer	75000	2020-06-01	1	3.8
3	Carol Williams	Marketing	Marketing Manager	85000	2018-09-20	NULL	4.2

Expected output: Departments with 3+ employees and full compensation stats

Hint

HAVING COUNT(*) >= 3 filters small departments. high_performer_pct = ROUND(100.0 * SUM(CASE WHEN performance_rating >= 4.0 THEN 1 ELSE 0 END) / COUNT(*), 1)

Concepts

SELECT GROUP BY HAVING Aggregation CASE

Practise the topic: SQL practice questions · GROUP BY exercises · CASE WHEN practice

In these company practice sets

Snowflake

A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.

Department Compensation Report

Schema

Hint

Concepts

In these company practice sets

Related questions