with TMP(PROCESS, CNT) as(
    select
        PROCESS
        , case
                when FLAG=1 and PROCESS_NO=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
            , cast(substr(PROCESS_ID,5,1) as int) as PROCESS_NO
            , 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
    PROCESS
    , IFNULL(SUM(T.CNT), 0)as CNT
from TMP as T
group by PROCESS
order by PROCESS asc;