nested case expression in sql

The CASE statement has the functionality of an IF-THEN-ELSE . It goes through conditions and returns a value when the first condition is met . So, once a condition is true, it will stop reading and return the result.