SELECT IFNULL(c1,'total') AS 项目名称,
SUM(IF(c2='20',C3,0)) AS 第20周线上,
SUM(IF(c2='20',C4,0)) AS 第20周所有,
CONCAT(LEFT(IF(SUM(IF(c2='20',C3,0))=0,0,SUM(IF(c2='20',C3,0)) /SUM(IF(c2='20',C4,0)) )*100 ,6),'%') AS 漏出占比,
SUM(IF(c2='21',C3,0)) AS 第21周线上,
SUM(IF(c2='21',C4,0)) AS 第21周所有,
CONCAT(LEFT(IF(SUM(IF(c2='21',C3,0