SELECT COUNT(DISTINCT unit_id) AS total_agents

FROM crosschain.olas.ez_unit_registrations

WHERE unit_type = 'agent'

),

mech_activity AS (

SELECT COUNT(*) AS total_mech_requests

FROM crosschain.olas.fact_mech_activity

WHERE event_name = 'Request'

),

service_count AS (

SELECT COUNT(DISTINCT service_id) AS total_services

FROM crosschain.olas.ez_service_registrations

SELECT

a.total_agents,

m.total_mech_requests,

s.total_services

FROM agent_count a, mech_activity m, service_count s