搜索 |
原始数据(统计完成的占计划的多少)
sql1:
SELECT wc.`value` AS 已完成,zs.`value` AS 总数,wc.`name` as 部门 FROM `销售计划2` wc
LEFT JOIN `销售计划2` zs ON wc.`name`=zs.`name`
WHERE wc.type='完成' AND zs.type='计划'
sql2:
SELECT name,sum(case when type='完成' then value else 0 end) as 已完成 ,sum(case when type='计划' then value else 0 end) as 总数
FROM `销售计划2` GROUP BY `name`