sql语句问题：表有四个字段，A，B，C和D, 判断A的值为‘1’则计算A+B，若A值为‘0’则计算B+C

select case when a = 1 then a + b when a = 0 then b + c end abcfrom tabnamewhere ...