select unitName, sum(case when TenDaysType = 0 then 1 else 0 end)
,sum(case when TenDaysType = 1 then 1 else 0 end)
,sum(case when TenDaysType = 2 then 1 else 0 end)
from 表
where [Year] = 1999 and [Month]=8
group by unitName
select unitName, sum(case when TenDaysType = 0 then 1 else 0 end)
,sum(case when TenDaysType = 0 then 1 else 0 end)
,sum(case when TenDaysType = 0 then 1 else 0 end)
from 表
where [Year] = 1999 and [Month]=8
group by unitName