Scenario SQL Question

Department Salary Statistics

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

Problem Statement

For every department that has employees, return department_id, department_name, employee_count, min_salary, max_salary, avg_salary (rounded 2). Order by avg_salary DESC, department_id.

Relevant Tables

departmentsemployees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

INNER JOIN Deep DiveJoins & Relationships
LEFT/RIGHT/FULL OUTER JOINJoins & Relationships
Multiple Table JoinsJoins & Relationships