Scenario SQL Question

Departments with Multiple Conditions

Build mastery in Aggregations with this scenario-based SQL challenge and live execution support.

Problem Statement

Find departments that satisfy BOTH: more than 1 employee AND average salary above $65,000. Return department_name, employee_count, avg_salary (rounded to 2 decimals). Sort by avg_salary descending.

Relevant Tables

departmentsemployees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

COUNT, SUM, AVG, MIN, MAXAggregate Functions & Grouping
GROUP BY FundamentalsAggregate Functions & Grouping
HAVING ClauseAggregate Functions & Grouping