with out as (
select a.*
from process_log as a
inner join process_log as b
on a.session_id = b.session_id
and a.ex_timestamp  < b.ex_timestamp
and cast(substr(a.process_id,5,1) as int) -1  = cast(substr(b.process_id,5,1) as int)
)
,seiki as (
select a.*
from process_log as a
inner join process_log as b
on a.session_id = b.session_id
and a.ex_timestamp  > b.ex_timestamp
and cast(substr(a.process_id,5,1) as int) -1  = cast(substr(b.process_id,5,1) as int)
)
,out_type2 as (
select a.*
from process_log as a
left outer join seiki
on a.session_id = seiki.session_id
and a.process_id = seiki.process_id
and a.user_id = seiki.user_id
and a.ex_timestamp = seiki.ex_timestamp
where cast(substr(a.process_id,5,1) as int) > 1
and seiki.process_id is null
)


,out2 as (
select *
from out 
union all
select a.*
from process_log as a
inner join out
on a.session_id = out.session_id
and cast(substr(a.process_id,5,1) as int) > cast(substr(out.process_id,5,1) as int)
union 
select a.*
from process_log as a
left outer join seiki
on a.session_id = seiki.session_id
and a.process_id = seiki.process_id
and a.user_id = seiki.user_id
and a.ex_timestamp = seiki.ex_timestamp
where cast(substr(a.process_id,5,1) as int) > 1
and seiki.process_id is null
union 
select a.*
from process_log as a
inner join out_type2
on  a.session_id = out_type2.session_id
and (cast(substr(a.process_id,5,1) as int) < cast(substr(out_type2.process_id,5,1) as int) and a.ex_timestamp > out_type2.ex_timestamp)
where cast(substr(a.process_id,5,1) as int) > 1
)
---------------------------
select a.process_id as PROCESS
        ,count(a.process_id) as CNT
from process_log as a
left outer join out2
on a.session_id = out2.session_id
and a.process_id = out2.process_id
and a.user_id = out2.user_id
and a.ex_timestamp = out2.ex_timestamp
where out2.session_id is null
group by a.process_id
order by a.PROCESS_ID