with tmp as (
    select 
        SESSION_ID,
        process_id,
        rank() over(partition by SESSION_ID order by EX_TIMESTAMP ) as NO
    from process_log
),
tmp1 as (
    select
        SESSION_ID,
        process_id,
        no,
        case 
            when process_id='STEP1' and NO=1 then 1
            when process_id='STEP2' and NO=2 then 1
            when process_id='STEP3' and NO=3 then 1
            when process_id='STEP4' and NO=4 then 1
            when process_id='STEP5' and NO=5 then 1
            else 0
        end as flag
    from tmp
),
tmp2 as (
    select 
        session_id,
        process_id,
        min(no) as minno
    from tmp1
    where flag=0
    group by session_id
    order by session_id
)
select 
    tmp1.process_id as PROCESS,
    count(
        distinct 
            case 
                when tmp1.no<minno or tmp2.session_id is null 
                    then tmp1.session_id
            end ) as CNT
from tmp1
left outer join tmp2
on tmp1.session_id=tmp2.session_id
where flag=1
group by tmp1.process_id
order by process;