WITH FilteredParties AS ( SELECT Shipper, CASE WHEN Consignee = 'TO ORDER' OR Consignee = SUBSTR(业务分析III, 1, LENGTH(Consignee)) THEN NULL ELSE Consignee END AS Consignee, CASE WHEN "Notify Party" = 'SAME AS CONSIGNEE' THEN NULL ELSE "Notify Party" END AS "Notify Party" FROM CoralPerformanceData WHERE 业务分析III = 'JAPAN MAG/JM SHOJI' AND BSTYPE != 'MASTER' ${if(len(年度)==0,"","AND YEAR = '" + 年度 + "'")} ${if(len(季度)==0,"","AND 季度 = '" + 季度 + "'")} ${if(len(月度)==0,"","AND TO_CHAR(Month,'YYYY/MM') = '" + 月度 + "'")} ${if(len(运输方式)==0,"","AND TRANSPORTATION = '" + 运输方式 + "'")} ${if(len(POD)==0,"","AND \"POD/POL\" = '" + POD + "'")})下面的查询我想要根据某一参数来执行不同sql，如果${进出口}为空执行SELECT COUNT(DISTINCT party) AS total_unique_partiesFROM ( SELECT Shipper AS party FROM FilteredParties WHERE Shipper IS NOT NULL UNION SELECT Consignee AS party FROM FilteredParties WHERE Consignee IS NOT NULL UNION SELECT "Notify Party" AS party FROM FilteredParties WHERE "Notify Party" IS NOT NULL) subquery如果${进出口}为E执行SELECT COUNT(DISTINCT party) AS total_unique_partiesFROM ( SELECT Shipper AS party FROM FilteredParties WHERE Shipper IS NOT NULL) subquery如果${进出口}为I执行SELECT COUNT(DISTINCT party) AS total_unique_partiesFROM ( SELECT Consignee AS party FROM FilteredParties WHERE Consignee IS NOT NULL UNION SELECT "Notify Party" AS party FROM FilteredParties WHERE "Notify Party" IS NOT NULL) subquery
