Free practice · ordering · medium

Practice

Trace a CASE expression

Order the steps used to interpret a searched CASE expression.

Arrange in the correct order
  1. 1. Apply the result alias after END
  2. 2. Use ELSE when no condition matches
  3. 3. Return the first matching THEN value
  4. 4. Test WHEN conditions from top to bottom