with PROCESS_LIST(PROSESS) as(
    select
        PROCESS_ID
    from PROCESS_LOG
    GROUP BY PROCESS_ID
), TMP(PROCESS, CNT) as(
    select
        PROCESS
        , case
                when cast(substr(PROCESS,5,1) as int)=sum(FLAG) over(partition by SESSION_ID order by EX_TIMESTAMP rows between unbounded preceding and current row) then 1
                else 0
            end as CNT
    from (select
            PROCESS_ID as PROCESS
            , SESSION_ID
            , EX_TIMESTAMP
            , case
                when 
                    cast(substr(PROCESS_ID,5,1) as int)=rank() over(partition by SESSION_ID order by EX_TIMESTAMP) then 1
                else 0
            end as FLAG
        from PROCESS_LOG)
)

select
    L.PROSESS as PROCESS
    , IFNULL(SUM(T.CNT), 0)as CNT
from PROCESS_LIST as L
left outer join TMP as T
    on L.PROSESS=T.PROCESS
group by L.PROSESS
order by L.PROSESS asc;