pgsql sum switch case code example
Example: pgsql sum switch case
SELECT
SUM(
CASE
WHEN condition_1 THEN result_1
WHEN condition_2 THEN result_2
[WHEN ...]
[ELSE else_result]
END
)
FROM ...
SELECT
SUM(
CASE
WHEN condition_1 THEN result_1
WHEN condition_2 THEN result_2
[WHEN ...]
[ELSE else_result]
END
)
FROM ...