-- forked from #Transactions By Service IDs on Each Chain @ https://flipsidecrypto.xyz/studio/queries/fd27c1f7-7e92-4db3-92bf-1940b29e23f8
select blockchain,
service_id,
count (distinct tx_hash) as Transactions
from crosschain.olas.fact_service_events
group by 1,2
order by 3 desc