select

date_trunc('week',BLOCK_TIMESTAMP) as week,

case

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

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

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

else null

end as service_type,

count(distinct TX_HASH) as no_services

from crosschain.olas.ez_service_registrations

group by 1,2 having service_type is not null