SELECT
    PROCESS_ID AS PROCESS,
    COUNT(*) AS CNT
FROM
    PROCESS_LOG
WHERE
    PROCESS_ID = "STEP1"
GROUP BY
    PROCESS_ID
UNION ALL
    SELECT
        MAIN.PROCESS_ID AS PROCESS,
        COUNT(*) AS CNT
    FROM
        PROCESS_LOG MAIN
    WHERE
        MAIN.PROCESS_ID = "STEP2"
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP1"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
        )
    GROUP BY
        MAIN.PROCESS_ID

UNION ALL 
    SELECT
        MAIN.PROCESS_ID AS PROCESS,
        COUNT(*) AS CNT
    FROM
        PROCESS_LOG MAIN
    WHERE
        MAIN.PROCESS_ID = "STEP3"
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP1"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
        )
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP2"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
        )
    GROUP BY
        MAIN.PROCESS_ID

UNION ALL
    SELECT
        MAIN.PROCESS_ID AS PROCESS,
        COUNT(*) AS CNT
    FROM
        PROCESS_LOG MAIN
    WHERE
        MAIN.PROCESS_ID = "STEP4"
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP1"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
        )
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP2"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
        )
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP3"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
                AND EXISTS (
                    SELECT
                        1
                    FROM
                        PROCESS_LOG SUB_2
                    WHERE
                        SUB_2.SESSION_ID = SUB.SESSION_ID
                        AND PROCESS_ID = "STEP2"
                        AND SUB_2.EX_TIMESTAMP < SUB.EX_TIMESTAMP
                )
        )
    GROUP BY
        MAIN.PROCESS_ID

UNION ALL
    SELECT
        MAIN.PROCESS_ID AS PROCESS,
        COUNT(*) AS CNT
    FROM
        PROCESS_LOG MAIN
    WHERE
        MAIN.PROCESS_ID = "STEP5"
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP1"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
        )
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP2"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
        )
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP3"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
                AND EXISTS (
                    SELECT
                        1
                    FROM
                        PROCESS_LOG SUB_2
                    WHERE
                        SUB_2.SESSION_ID = SUB.SESSION_ID
                        AND PROCESS_ID = "STEP2"
                        AND SUB_2.EX_TIMESTAMP < SUB.EX_TIMESTAMP
                )
        )
        AND EXISTS (
            SELECT
                1
            FROM
                PROCESS_LOG SUB
            WHERE
                SUB.SESSION_ID = MAIN.SESSION_ID
                AND PROCESS_ID = "STEP4"
                AND SUB.EX_TIMESTAMP < MAIN.EX_TIMESTAMP
                AND EXISTS (
                    SELECT
                        1
                    FROM
                        PROCESS_LOG SUB_2
                    WHERE
                        SUB_2.SESSION_ID = SUB.SESSION_ID
                        AND PROCESS_ID = "STEP3"
                        AND SUB_2.EX_TIMESTAMP < SUB.EX_TIMESTAMP
                        AND EXISTS (
                            SELECT
                                1
                            FROM
                                PROCESS_LOG SUB_3
                            WHERE
                                SUB_3.SESSION_ID = SUB_2.SESSION_ID
                                AND PROCESS_ID = "STEP2"
                                AND SUB_3.EX_TIMESTAMP < SUB_2.EX_TIMESTAMP
                        )
                )
        )
    GROUP BY
        MAIN.PROCESS_ID

ORDER BY
    PROCESS;