"sourceChain",

"TXs Count"

FROM (

SELECT

CAST(CALL:returnValues:destinationChain AS VARCHAR) AS "sourceChain",

COUNT(DISTINCT call:transactionHash) AS "TXs Count"

FROM

axelar.axelscan.fact_gmp

GROUP BY

CALL:returnValues:destinationChain

UNION ALL

SELECT

CAST(DESTINATION_CHAIN AS VARCHAR) AS "DESTINATION CHAIN",

COUNT(DISTINCT SEND:txhash) AS "TXs Count"

FROM

axelar.axelscan.fact_transfers

GROUP BY

DESTINATION_CHAIN

) AS combined

ORDER BY

"TXs Count" DESC

5;