with 
PROCESS_LOG_ORD as(
select * from PROCESS_LOG order by 1,4
),
ORD as (
select SESSION_ID, 
--PROCESS_ID
group_concat(replace(PROCESS_ID,"STEP",""),"") as ord
from PROCESS_LOG_ORD
group by 1),
tmp as(
select 
count(1) as CNT,
case
--when ord = "123456" then "6"
when ord = "12345" then "5"
when ord like "1234%" then "4"
when ord like "123%" then "3"
when ord like "12%" then "2"
when ord like "1%" then "1"
else "0"
end as steps
from ORD
group by steps
order by steps
),
ans as(
select steps, "STEP"||steps as PROCESS, 
CNT from tmp where steps !="0"
),
stepindex as (
SELECT "1" AS value
    UNION ALL
    SELECT "2"
    UNION ALL
    SELECT "3"
    UNION ALL
    SELECT "4"
    UNION ALL
    SELECT "5"
    --UNION ALL 
    --SELECT "6"
)
select "STEP"||stepindex.value as PROCESS,
case
when ans.CNT is NULL then 0
else ans.CNT
end as CNT
from stepindex left join ans on stepindex.value = ans.steps