(效果希望当我的customvalue为极小型时用1*各占比的值)SELECT p.pname, i.SUMMARY,(case D.customvalueWHEN '极小型' THEN '1'WHEN '小型' THEN '2'WHEN '中型' THEN '5'WHEN '大型' THEN '10'WHEN '超大型' THEN '20'ELSE D.customvalueEND) as 任务数,D.customvalue, ci.OLDSTRING, (case ci.OLDSTRINGWHEN '功能组长验收' THEN '0.94'WHEN '产品验收交互' THEN '0.9'WHEN '团队评审' THEN '0.8'WHEN '产品验收视觉审' THEN '0.75'WHEN '开发评审' THEN '0.7'WHEN '测试用例审核' THEN '0.65'WHEN '研发组员问题解决中' THEN '0.5'WHEN '测试组员测试验收中' THEN '0.25'WHEN '交互验收' THEN '0.19'WHEN '功能验收' THEN '0.15'WHEN '视觉产品验收' THEN '0.1'WHEN '产品负责人最终确认' THEN '0'ELSE NULLEND)as 任务占比, ci.NEWSTRING FROM changegroup cg