mysql符合条件的字段相加，这样的语句怎么简化

带s的是判断列，不带的是数值列，判断s_1605到s_1702是0还是1，把判断列是0的全部相加，

select sum(判断列的属性名) from 表名 where 判断列的属性名 = '0';

select _1605+sum(qiankuan) from suoyin where s_1607 = 0 and s_1608 = 0 and s_1609 = 0 and s_1610 = 0 and s_1611 = 0 and s_1612 = 0 and s_1701 = 0 and s_1702 = 0;

SELECT NAME1,
SUM(IF s_1605 == 0 THEN _1605 ELSE 0 END IF,
IF s_1606 == 0 THEN _1606 ELSE 0 END IF,
IF s_1607 == 0 THEN _1607 ELSE 0 END IF)
FROM 表名;

SELECT    name1,
               SUM(IF s_1605 == 0 THEN _1605 ELSE 0 END IF,
                        IF s_1606 == 0 THEN _1606 ELSE 0 END IF,
                        IF s_1607 == 0 THEN _1607 ELSE 0 END IF) 
FROM 表名;