为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8
行转列出现字符串转换错误，下附sql语句
Select sum(case a.json_key when 'totalInvestment' then a.json_val else 0 end) as totalInvestment,
sum(case a.json_key when 'industryCategory' then a.json_val else 0 end) as industryCategory,
sum(case a.json_key when 'landUseProjectApproval' then a.json_val else 0 end) as landUseProjectApproval,
sum(case a.json_key when 'constructionProjectApproval' then a.json_val else 0 end) as constructionProjectApproval,
sum(case a.json_key when 'contactPersonTel' then a.json_val else 0 end) as contactPersonTel,

sum(case a.json_key when 'application_unit' then a.json_val else 0 end) as application_unit,
sum(case a.json_key when 'Declaration_name' then a.json_val else 0 end) as Declaration_name,
sum(case a.json_key when 'project_file' then a.json_val else 0 end) as project_file,
sum(case a.json_key when 'project_signing' then a.json_val else 0 end) as project_signing,
sum(case a.json_key when 'mold' then a.json_val else 0 end) as mold,
sum(case a.json_key when 'code' then a.json_val else 0 end) as code,
sum(case a.json_key when 'code_name' then a.json_val else 0 end) as code_name,

sum(case a.json_key when 'type_of_industry' then a.json_val else 0 end) as type_of_industry,
sum(case a.json_key when 'owner_type' then a.json_val else 0 end) as owner_type,
sum(case a.json_key when 'build_type' then a.json_val else 0 end) as build_type,
sum(case a.json_key when 'in_place' then a.json_val else 0 end) as in_place,
sum(case a.json_key when 'provincial_project' then a.json_val else 0 end) as provincial_project,
sum(case a.json_key when 'municipal_project' then a.json_val else 0 end) as municipal_project,
sum(case a.json_key when 'central_budget_item' then a.json_val else 0 end) as central_budget_item,
sum(case a.json_key when 'provincial_budget_line' then a.json_val else 0 end) as provincial_budget_line,
sum(case a.json_key when 'special_debt_item' then a.json_val else 0 end) as special_debt_item,
sum(case a.json_key when 'national_debt_project' then a.json_val else 0 end) as national_debt_project,
sum(case a.json_key when 'four_modernizations_fund' then a.json_val else 0 end) as four_modernizations_fund,
sum(case a.json_key when 'guarantee_item' then a.json_val else 0 end) as guarantee_item,
sum(case a.json_key when 'four_modernizations_type' then a.json_val else 0 end) as four_modernizations_type,
sum(case a.json_key when 'audit_reserve_type' then a.json_val else 0 end) as audit_reserve_type,
sum(case a.json_key when 'storage_time' then a.json_val else 0 end) as storage_time,
sum(case a.json_key when 'bid_tender' then a.json_val else 0 end) as bid_tender,
sum(case a.json_key when 'licence' then a.json_val else 0 end) as licence,
sum(case a.json_key when 'remark' then a.json_val else 0 end) as remark,
sum(case a.json_key when 'domain' then a.json_val else 0 end) as domain,
sum(case a.json_key when 'category' then a.json_val else 0 end) as category,
sum(case a.json_key when 'plnaStartDate' then a.json_val else 0 end) as plnaStartDate,
sum(case a.json_key when 'plnaEndDate' then a.json_val else 0 end) as plnaEndDate,
sum(case a.json_key when 'remarks' then a.json_val else 0 end) as remarks,
sum(case a.json_key when 'name' then a.json_val else 0 end) as name,
sum(case a.json_key when 'gcsxbl' then a.json_val else 0 end) as gcsxbl,
a.flow_id,
a.place place,
a.creator creator,
a.status status
from pmp_basic_load a