报错ORA-00905: 缺失关键字 如何解决

Question

写sql时遇到下面的问题请求援助
报错 ORA-00905: 缺失关键字

ORA-00905: 缺失关键字
SELECT
    NODE_NAME,
    SUM( NODE_CONFIRM_VALUE ) TOTAL 
FROM
    MATB_EQ_NODE_CONFORM 
WHERE
    SHIFT_DETAIL_ID IS NULL 
AND
CASE
        LENGTH( '2022' ) 
        WHEN 4 THEN
        TRUNC( BALANCE_DATE ) BETWEEN TRUNC( TO_DATE( '2022-01-01', 'yyyy-MM-dd' ) ) 
        AND TRUNC( TO_DATE( '2024-01-01', 'yyyy-MM-dd' ) ) 
        WHEN 7 THEN
        TRUNC( BALANCE_DATE ) BETWEEN TRUNC( TO_DATE( '2022-01', 'yyyy-MM' ) ) 
        AND TRUNC( TO_DATE( '2024-01', 'yyyy-MM' ) ) 
        ELSE  TRUNC( BALANCE_DATE ) BETWEEN TRUNC( TO_DATE( '2022-01-01', 'yyyy-MM-dd' ) ) 
        AND TRUNC( TO_DATE( '2024-01-01', 'yyyy-MM-dd' ) ) 
    END 
    GROUP BY
        NODE_NAME

Answer 1

SELECT
    NODE_NAME,
    SUM( NODE_CONFIRM_VALUE ) TOTAL 
FROM
    MATB_EQ_NODE_CONFORM 
WHERE
    SHIFT_DETAIL_ID IS NULL 
AND TRUNC( BALANCE_DATE ) >= 
(CASE
        LENGTH( '2022' ) 
        WHEN 4 THEN
        TRUNC( TO_DATE( '2022-01-01', 'yyyy-MM-dd' ) ) 
        WHEN 7 THEN
        TRUNC( TO_DATE( '2022-01', 'yyyy-MM' ) ) 
        ELSE 
        TRUNC( TO_DATE( '2022-01-01', 'yyyy-MM-dd' ) ) 
    END )
AND TRUNC( BALANCE_DATE ) <= 
(CASE
        LENGTH( '2022' ) 
        WHEN 4 THEN
        TRUNC( TO_DATE( '2024-01-01', 'yyyy-MM-dd' ) ) 
        WHEN 7 THEN
        TRUNC( TO_DATE( '2024-01', 'yyyy-MM' ) ) 
        ELSE 
        TRUNC( TO_DATE( '2024-01-01', 'yyyy-MM-dd' ) ) 
    END )
    GROUP BY
        NODE_NAME