Oracle 求剩余时间

WITH GROUPED_DATA AS (
    SELECT
        mainflownanme,
        OP_CODE,
        SEQ,
        SUM(opuserTime) OVER (PARTITION BY MAINFLOWNANME ORDER BY SEQ) AS TOTAL_SUM,
        SUM(opuserTime) OVER (PARTITION BY MAINFLOWNANME) AS MAX_TIME_IN_GROUP
    FROM TOOL_FLOW_TC_ONE
)
SELECT
        MAINFLOWNANME  MAIN_ROUTE_ID,
        OP_CODE AS OP_NO,
        SEQ,
     MAX_TIME_IN_GROUP - TOTAL_SUM AS  IDEAL
FROM GROUPED_DATA
ORDER BY MAINFLOWNANME, SEQ;