select

trunc(BLOCK_TIMESTAMP, 'week') as date,

case

when NAME ilike '%market_maker%' then 'Creator'

when NAME ilike '%Trader%' then 'Trader'

when NAME ilike '%Mech%' then 'Mech'

else 'Other' end as service_type,

count(distinct TX_HASH) as no_services,

sum(no_services) over (partition by service_type ORDER by date) as cum_service_type

from crosschain.olas.ez_service_registrations

WHERE NAME is not null

group by 1,2