select dw,
(case zc when 初级 then value else 0 end) 初级,
(case zc when 副高职 then value else 0 end) 副高职,
(case zc when 正高职 then value else 0 end) 正高职
from table
group by dw
select dw,
sum(case zc when 初级 then value else 0 end) 初级,
sum(case zc when 副高职 then value else 0 end) 副高职,
sum(case zc when 正高职 then value else 0 end) 正高职
from yourtable
group by dw,初级,副高职,正高职