这是一个oracle计税公式，运行时出错missing right parenthesis

Question

update 表名 t set 扣税= case (t.计税工资)
when ((t.计税工资 <= 1500) and (t.计税工资 > 0)) then t.计税工资*0.03
when ((t.计税工资 <= 4500) and (t.计税工资 > 1500)) then t.计税工资*0.1-105
when ((t.计税工资 <= 9000) and (t.计税工资 > 4500)) then t.计税工资*0.2-555
when ((t.计税工资 <= 35000) and (t.计税工资 > 9000)) then t.计税工资*0.25-1005
when ((t.计税工资 <= 55000) and (t.计税工资 > 35000)) then t.计税工资*0.30-2775
else 0 end
where t.工资类别='月薪'
请哪位高手指点一下，谢谢！

Answer 1

update 表名 t set 扣税= case (t.计税工资)
when ((t.计税工资 <= 1500) and (t.计税工资 > 0)) then t.计税工资*0.03

case后面的 (t.计税工资) 去掉