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: