Scenario SQL Question

Multi-Condition Promotion Eligibility

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

Problem Statement

Determine promotion eligibility based on multiple conditions: 'Eligible' if (salary > 60000 AND experience > 5 years) OR (salary > 80000 AND experience > 3 years), otherwise 'Not Eligible'. Include employee details.

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