[TABLE] CASE

<cell> Conditional <cell> CASE <cell> Evaluates the condition of each successive WHEN clause and returns the first result where the condition is true; any remaining WHEN and ELSE clauses are not evaluated. If all conditions are false or NULL, returns else_result if present; if not present, returns NULL. [Learn more](/looker/docs/studio/case-searched) `

CASE
    WHEN condition THEN result
    [WHEN condition THEN result]
    [...]
    [ELSE else_result]
END

`