with service_agents as (

select

service_id,

f.value::number as agent_id,

array_size(agent_ids) as agent_count

from crosschain.olas.ez_service_registrations,

table(flatten(agent_ids)) f

select

count(distinct agent_id) as total_agents,

avg(agent_count) as avg_agents_per_service,

-- Distribution of services by agent count

from service_agents;