SELECT PROCESS_ID AS PROCESS,
       COUNT(SESSION_ID) AS CNT
FROM
    (
        SELECT
            SESSION_ID,
            PROCESS_ID,
            USER_ID,
            STEPOUT,
            COUNT,
            COUNT(PROCESS_ID) OVER(partition by SESSION_ID order by EX_TIMESTAMP) AS COUNT2
        FROM
            (
                SELECT
                    SESSION_ID,
                    PROCESS_ID,
                    USER_ID,
                    EX_TIMESTAMP,
                    SUBSTR(PROCESS_ID, 5, 1) AS STEPOUT,
                    COUNT(PROCESS_ID) OVER(partition by SESSION_ID order by EX_TIMESTAMP) AS COUNT
                FROM
                    PROCESS_LOG
            )
        WHERE
            CAST(COUNT as string) = CAST(STEPOUT AS string)
    )
WHERE
    CAST(COUNT as string) = CAST(COUNT2 AS string)
GROUP BY
    PROCESS_ID
ORDER BY
    PROCESS_ID ASC