with r as (
select *, rank() over(partition by session_id order by EX_TIMESTAMP) as ra
from process_log
)
, r2 as (
select * from r
where ra == cast(substr(process_id, 5) as integer)
)
, r3 as (select * 
, (select count(1) from r2 b where b.ra < a.ra and b.session_id = a.session_id) as cnt
from r2 as a
)
select 
process_id as PROCESS
, count(1) as CNT
from r3
where ra - 1 = cnt
group by process_id
order by PROCESS