blockchain,

count (distinct tx_hash) as Transactions,

count (distinct origin_from_address) as Active_Services,

count (Distinct service_id) as Services,

sum (transactions) over (partition by blockchain order by date asc) as Cumulative_Transactions

from crosschain.olas.fact_service_events

group by 1,2

order by 1 desc