with
s1 as (
select 
PROCESS_ID
, SESSION_ID
, rank() over (partition by SESSION_ID order by EX_TIMESTAMP) as RANK
from process_log
)
, s2 as (
select 
SESSION_ID
, MIN(RANK) as MIN
from s1 where CAST(SUBSTR(PROCESS_ID, 5) AS INT) != RANK
group by SESSION_ID
)
select 
s1.PROCESS_ID as PROCESS
, count(
CASE WHEN CAST(SUBSTR(s1.PROCESS_ID, 5) as INT) < s2.MIN OR s2.MIN IS NULL THEN 1 END
) as CNT
from s1 left join s2 on s1.SESSION_ID = s2.SESSION_ID
group by PROCESS_ID
order by PROCESS_ID
;