Whenever you're ready, walk me through how you'd approach this.
How would you use CASE WHEN in SQL to create a derived category?
Explain the syntax, how conditions are evaluated, and how you would handle values that match no condition or contain NULL. Include a concise SQL example and discuss how overlapping conditions affect the result.