Advanced value expressions
NULLIF
NULLIF is shorthand for a frequently used variation of CASE.
Syntax
NULLIF(value1, target_value)
is equivalent to
CASE
WHEN value1 = = target_value THEN NULL
ELSE value1
END
Example
... WHERE sales_revenue / NULLIF(our_cost, -1) > 50
