SELECT  PROCESS_ID AS PROCESS,
        COUNT(SESSION_ID) AS CNT
FROM    (
            SELECT  SESSION_ID,
                    PROCESS_ID,
                    USER_ID,
                    STEPOUT,
                    COUNT1,
                    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 COUNT1
                        FROM    PROCESS_LOG
                    ) 
            WHERE   CAST(COUNT1 as string) = CAST(STEPOUT AS string)
        ) 
WHERE COUNT1 = COUNT2
GROUP BY PROCESS_ID
ORDER BY PROCESS_ID ASC