CREATE TABLE #tb (a int ,b int ,c int )
 INSERT INTO #TB select '1', '2', '0'
       union all select '0', '0', '1'
       union all select '0', '1', '0'
       union all select '1', '1', '1'
       union all select '0', '0', '0'
       union all select '2', '2', '1'
 
 
 select sum(case when a=0 then 1 else 0 end) AS a,
  sum(case when b=0 then 1 else 0 end) as b,
  sum(case when c=0 then 1 else 0 end) as c
 from #tb
 /*
 a           b           c
 ----------- ----------- -----------
 3           2           3
 
 (1 行受影响)
 */