SELECT
count( id ) a,
sum( CASE sf_education WHEN '否' THEN 1 ELSE 0 END ) b,
sum( CASE sf_education WHEN '是' THEN 1 ELSE 0 END ) c,
sum( CASE WHEN swork = '是' AND sf_education = '否' THEN 1 ELSE 0 END ) d,
sum( CASE WHEN swork = '否' AND sf_education = '否' THEN 1 ELSE 0 END ) e,
project_name
FROM
zt_hwbk_safety
GROUP BY
project_name
CASE WHEN 字段一 = '是' AND 字段二 = '否' THEN 1 ELSE 0 END