-- forked from Eman-Raz / Total Number of Interchain Transfers By Route @ https://flipsidecrypto.xyz/Eman-Raz/q/j9vbftWcu8fM/total-number-of-interchain-transfers-by-route
select call:chain || '➡' || call:returnValues:destinationChain as "Route", count(distinct id) as "Transfers Count"
from axelar.axelscan.fact_gmp
where call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
and (data:executed:receipt:logs[1]:address=lower('0x129ed667bf8c065fe5f66c9b44b7cb0126d85cc3')
)
and (created_at::date between '{{Start_Date}}' and '{{End_Date}}')
group by 1