实现'case'语句以匹配多个'when'条件

CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    WHEN condition3 THEN result3
    ELSE default_result
END

CASE
    WHEN value IN (value1, value2, value3) THEN result1
    WHEN value IN (value4, value5, value6) THEN result2
    ELSE default_result
END

CASE
    WHEN value BETWEEN value1 AND value2 THEN result1
    WHEN value BETWEEN value3 AND value4 THEN result2
    ELSE default_result
END