WITH MAIN AS
(
    WITH MAIN AS
    (
        SELECT
            ROW_NUMBER() OVER (PARTITION BY PL.SESSION_ID ORDER BY EX_TIMESTAMP) AS SEQ,
            PL.SESSION_ID,
            PL.PROCESS_ID,
            CAST(REPLACE(PL.PROCESS_ID, 'STEP', '') AS INTEGER) AS PROCESS_NO,
            PL.USER_ID,
            PL.EX_TIMESTAMP
        FROM
            PROCESS_LOG AS PL
        ORDER BY
            PL.SESSION_ID,
            PL.EX_TIMESTAMP
    )
    SELECT
        ROW_NUMBER() OVER(PARTITION BY MAIN.SESSION_ID ORDER BY MAIN.PROCESS_ID) AS SEQ,
        MAIN.SESSION_ID,
        MAIN.PROCESS_ID,
        MAIN.PROCESS_NO,
        MAIN.USER_ID,
        MAIN.EX_TIMESTAMP
    FROM
        MAIN
    WHERE
        MAIN.SEQ = PROCESS_NO
)
SELECT
    MAIN.PROCESS_ID AS PROCESS,
    COUNT(*) AS CNT
FROM 
    MAIN
WHERE
    MAIN.SEQ = MAIN.PROCESS_NO
GROUP BY
    MAIN.PROCESS_ID
ORDER BY
    MAIN.PROCESS_ID