Scenario SQL Question
Compare Department Salary with Company Average
Build mastery in Case Statements with this scenario-based SQL challenge and live execution support.
Problem Statement
Compare each department's average salary with the company's overall average salary. Label as 'Higher', 'Lower', or 'Same'. Include department name and average salary.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: