2、需要保证历史有的但是当天没有的数据能够显示
--能源科技
SELECT COMPANY_CODE,'2022-05-23' AS DATE,'能源科技' as PROD_LINE
,sum(CASE WHEN WORK_DATE='20220523' THEN CONFIRM_WGT else 0 end) as PROD_YIELD_INDEX_VALUE_DAY
,sum(CONFIRM_WGT) AS PROD_YIELD_INDEX_VALUE_SUM --累计指标
FROM GBSC00.TDELT09_CDM
WHERE LEFT(WORK_DATE,6)='202205' AND WORK_DATE<='20220523'
GROUP BY COMPANY_CODE