CASE Expression in SQL
The CASE expression checks conditions and returns a value when the first condition is met (similar to an if-then-else statement). As a result, if a condition is met, it will finish reading and return the result. If none of the conditions are met, it returns the value specified in the ELSE clause.