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: 'Eligible' if (salary > 60000 AND experience_years > 5) OR (salary > 80000 AND experience_years > 3); else 'Not Eligible'. Return employee_id, first_name, last_name, salary, experience_years, promotion_eligibility — ordered by employee_id.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: