WITH A AS(SELECT SYB_NAME, NVL(ATT_VALUES01,'健康消费品事业部') ATT_VALUES01, SUM( REAL_SALE_AM ) / 10000 DANGTIAN FROM ADS_BUSS_PERFORMANCE_KPI_DETAIL WHERE 1 = 1 AND YMD_ID = '${YM_ID}' GROUP BY SYB_NAME, ATT_VALUES01 ),B AS ( SELECT SYB_NAME, NVL(ATT_VALUES01,'健康消费品事业部') ATT_VALUES01, SUM( REAL_SALE_AM ) / 10000 BENYUE FROM ADS_BUSS_PERFORMANCE_KPI_DETAIL WHERE 1 = 1 AND YM_ID = SUBSTR('${YM_ID}',1,7) AND YMD_ID <= '${YM_ID}' GROUP BY SYB_NAME, ATT_VALUES01),C AS (SELECT SYB_NAME, NVL(ATT_VALUES01,'健康消费品事业部') ATT_VALUES01, SUM(REAL_SALE_AM ) / 10000 YUELEIJI, SUM(BASIC_TASK_SALE_AM) / 10000 AS BASIC_TASK_SALE, SUM(TQ_SALE_AM) / 10000 TONGQIFROM ADS_BUSS_PERFORMANCE_KPI_DETAIL WHERE 1 = 1 AND YEAR_ID = SUBSTR('${YM_ID}',1,4) AND YMD_ID <= '${YM_ID}' GROUP BY SYB_NAME, ATT_VALUES01),D AS ( SELECT SYB_NAME, NVL(ATT_VALUES01,'健康消费品事业部') ATT_VALUES01, SUM(REAL_SALE_AM)/10000 AS NIANDU, SUM(BASIC_TASK_SALE_AM)/10000 AS ANNUAL_BASIC_TASK, SUM(SPRINT_TASK_SALE_AM)/10000 AS ANNUAL_SPRINT_TASK FROM ADS_BUSS_PERFORMANCE_KPI_DETAIL T WHERE YEAR_ID = SUBSTR('${YM_ID}',1,4) GROUP BY SYB_NAME, ATT_VALUES01 ) SELECT COALESCE(A.SYB_NAME, B.SYB_NAME, C.SYB_NAME, D.SYB_NAME) AS SYB_NAME, A.ATT_VALUES01, NVL(A.DANGTIAN,0) DANGTIAN, B.BENYUE, C.BASIC_TASK_SALE, C.YUELEIJI, C.TONGQI, D.ANNUAL_BASIC_TASK, D.ANNUAL_SPRINT_TASK FROM A FULL OUTER JOIN B ON A.SYB_NAME = B.SYB_NAME AND A.ATT_VALUES01 = B.ATT_VALUES01 FULL OUTER JOIN C ON COALESCE(A.SYB_NAME, B.SYB_NAME) = C.SYB_NAME AND A.ATT_VALUES01 = C.ATT_VALUES01 FULL OUTER JOIN D ON COALESCE(A.SYB_NAME, B.SYB_NAME, C.SYB_NAME) = D.SYB_NAME AND A.ATT_VALUES01 = D.ATT_VALUES01WHERE COALESCE(A.SYB_NAME, B.SYB_NAME, C.SYB_NAME, D.SYB_NAME) = '健康消费品事业部'数据集二：：、：WITH A AS(SELECT SYB_NAME, NVL(ATT_VALUES01,'健康消费品事业部') ATT_VALUES01, SUM( REAL_SALE_AM ) / 10000 DANGTIAN FROM ADS_BUSS_PERFORMANCE_KPI_DETAIL WHERE 1 = 1 AND YMD_ID = '${YM_ID}' GROUP BY SYB_NAME, ATT_VALUES01 ),B AS ( SELECT SYB_NAME, NVL(ATT_VALUES01,'健康消费品事业部') ATT_VALUES01, SUM( REAL_SALE_AM ) / 10000 BENYUE FROM ADS_BUSS_PERFORMANCE_KPI_DETAIL WHERE 1 = 1 AND YM_ID = SUBSTR('${YM_ID}',1,7) AND YMD_ID <= '${YM_ID}' GROUP BY SYB_NAME, ATT_VALUES01),C AS (SELECT SYB_NAME, NVL(ATT_VALUES01,'健康消费品事业部') ATT_VALUES01, SUM(REAL_SALE_AM ) / 10000 YUELEIJI, SUM(BASIC_TASK_SALE_AM) / 10000 AS BASIC_TASK_SALE, SUM(TQ_SALE_AM) / 10000 TONGQIFROM ADS_BUSS_PERFORMANCE_KPI_DETAIL WHERE 1 = 1 AND YEAR_ID = SUBSTR('${YM_ID}',1,4) AND YMD_ID <= '${YM_ID}' GROUP BY SYB_NAME, ATT_VALUES01),D AS ( SELECT SYB_NAME, NVL(ATT_VALUES01,'健康消费品事业部') ATT_VALUES01, SUM(REAL_SALE_AM)/10000 AS NIANDU, SUM(BASIC_TASK_SALE_AM)/10000 AS ANNUAL_BASIC_TASK, SUM(SPRINT_TASK_SALE_AM)/10000 AS ANNUAL_SPRINT_TASK FROM ADS_BUSS_PERFORMANCE_KPI_DETAIL T WHERE YEAR_ID = SUBSTR('${YM_ID}',1,4) GROUP BY SYB_NAME, ATT_VALUES01 ) SELECT COALESCE(A.SYB_NAME, B.SYB_NAME, C.SYB_NAME, D.SYB_NAME) AS SYB_NAME, COALESCE(A.ATT_VALUES01, B.ATT_VALUES01, C.ATT_VALUES01, D.ATT_VALUES01,'1') AS ATT_VALUES01, NVL(A.DANGTIAN,0) DANGTIAN, B.BENYUE, C.BASIC_TASK_SALE, C.YUELEIJI, C.TONGQI, D.ANNUAL_BASIC_TASK, D.ANNUAL_SPRINT_TASK FROM A FULL OUTER JOIN B ON A.SYB_NAME = B.SYB_NAME AND A.ATT_VALUES01 = B.ATT_VALUES01 FULL OUTER JOIN C ON COALESCE(A.SYB_NAME, B.SYB_NAME) = C.SYB_NAME AND COALESCE(A.ATT_VALUES01, B.ATT_VALUES01) = C.ATT_VALUES01 FULL OUTER JOIN D ON COALESCE(A.SYB_NAME, B.SYB_NAME, C.SYB_NAME) = D.SYB_NAME AND COALESCE(A.ATT_VALUES01, B.ATT_VALUES01, C.ATT_VALUES01) = D.ATT_VALUES01WHERE COALESCE(A.SYB_NAME, B.SYB_NAME, C.SYB_NAME, D.SYB_NAME) = '健康消费品事业部'想问一下第一个数据集和第二个数据集之前有什么区别吗？为什么第一个数据集ATT_VALUES01这个字段在PC端，数据库，数据集预览中都正常展示，但是在移动端展示不出来（'${YM_ID}'是日期参数，格式2025-10-10）
