WHERE Clause & Filtering

CASE Statements

Aggregate Functions

Find employees without managers (IS NULL)

Calculate total compensation handling NULL bonus

Count employees with and without bonuses

Replace NULL values with defaults using COALESCE

Q

R