SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Average Salary by Department

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

Problem Statement

Calculate the average salary for each department that has employees.

Relevant Tables

departmentsemployees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: