Multiple Business Rules

How can we classify employees using several business rules?

Advanced⏱ 3 Minutes⭐ 1270 XP

🤔 THE QUESTION

How can we classify employees using several business rules?

💡 WHAT IS IT?

Combining status checks and compensation thresholds in ordered WHEN clauses implements complex enterprise business logic.

🎯 WHAT IS IT USED FOR?

Employee seniority modeling, customer risk tiering, product inventory status classification.

💻 EXAMPLE

SELECT
name,
salary,
status,
CASE
    WHEN status = 'Inactive' THEN 'Inactive'
    WHEN salary >= 120000 THEN 'Executive'
    WHEN salary >= 90000 THEN 'Senior'
    ELSE 'Standard'
END AS employee_level
FROM employees;

🎯 Mission Objectives

Practice typing production-grade SQL code for Multiple Business Rules.

✓ Multi-condition CASE
✓ Status and compensation rules
✓ Enterprise classification
✓ Ordered evaluations

🚀 Start Mission

← Prev (SUM with CASE)Next Lesson (CASE with NULL) →