写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