Scenario SQL Question

Identify Highest and Lowest Salary in Each Department

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

Problem Statement

For each department, identify employees with the highest and lowest salary and label them accordingly. Return department, employee name, salary, and label (Highest/Lowest/N/A).

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

CASE Statements & Conditional LogicSQL Fundamentals
Conditional Aggregation with CASE & FILTERAggregate Functions & Grouping
Complex WHERE Conditions & Boolean LogicAdvanced Filtering