DB2如何使用多个条件的用例？

CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    ...
    ELSE result
END

SELECT 
    customer_name,
    CASE 
        WHEN purchase_amount > 1000 THEN 'VIP'
        WHEN purchase_amount > 500 THEN 'Gold'
        WHEN purchase_amount > 100 THEN 'Silver'
        ELSE 'Regular'
    END AS customer_category
FROM
    customers;