你走在正确的道路上，但还有一些问题。
1.子查询缺少别名

1. Case语句未用于生成新列。
   1.根据您的月份列“2023年1月1日”，这将不起作用。
   我已经重写了你的查询，它看起来应该像这样。你可能需要修改过滤。

WITH cte
AS (
    SELECT "ORG"
        ,"MONTH"
        ,SUM(CASE WHEN "SALE_ID" != 1 THEN "CHARGE"
                ELSE 0 END) AS OtherCharges
        ,MAX(CASE WHEN "SALE_ID" = 1 THEN "CHARGE"
                ELSE 0 END) AS Sale1Charge
    FROM "TABLE"
    WHERE "MONTH" IN ('NOV','DEC', '...')
    GROUP BY "ORG","MONTH"
    )
SELECT "ORG","MONTH"
FROM cte
WHERE OtherCharges = 0 AND Sale1Charge > 0

字符串

使用HAVING子句和条件聚合：

SELECT org,
       month
FROM   table_name
GROUP BY
       org, month
HAVING SUM(CASE WHEN sale_id != 1 THEN charge END) = 0

字符串
其中，对于样本数据：

CREATE TABLE table_name (ORG, SALE_ID, CHARGE, MONTH) AS
SELECT 'AA', 1, 20, 'NOV' FROM DUAL UNION ALL
SELECT 'AA', 2, 30, 'DEC' FROM DUAL UNION ALL
SELECT 'BB', 1, 20, 'DEC' FROM DUAL UNION ALL
SELECT 'BB', 2, 00, 'DEC' FROM DUAL UNION ALL
SELECT 'BB', 3, 00, 'DEC' FROM DUAL UNION ALL
SELECT 'BB', 1, 20, 'NOV' FROM DUAL UNION ALL
SELECT 'BB', 2, 00, 'NOV' FROM DUAL UNION ALL
SELECT 'CC', 3, 00, 'DEC' FROM DUAL;

型
产出：
| ORG|月|
| --|--|
| CC| Dec|
| BB| Nov|
| BB| Dec|
fiddle

比如说：

SELECT "MONTH" , "ORG" 
FROM "TABLE" 
WHERE "SALE_ID" != 1
GROUP BY "MONTH" , "ORG"
HAVING sum("CHARGE") = 0

字符串