CASE Statements & Conditional Logic: Next

WHERE Clause & Filtering

Conditional Aggregation with CASE & FILTER

NULL Handling

Categorize employees by salary band

Create status labels from codes

Calculate conditional discounts

Write a CASE expression for mutually exclusive ranges and explain why branch order matters.

Comparison & Logical Operators

NULL Handling

Conditional Aggregation with CASE & FILTER