case....when ...多重判断

CASE...WHEN 进行多重判断

CASE WHEN A  IS NOT NULL
THEN B
WHEN C IS NULL
THEN
CASE WHEN D IS NOT NULL
THEN E
ELSE 0
END
END contract_amount_total,