WITH Chains as (
SELECT
source_chain,
destination_chain,
COUNT(DISTINCT Tx_hash) AS transactions
FROM
AXELAR.defi.ez_bridge_squid
GROUP BY
1, 2
UNION ALL
SELECT
Source_chain,
destination_chain,
COUNT(DISTINCT tx_hash) AS transactions
FROM
AXELAR.defi.ez_bridge_satellite
GROUP BY
1, 2
)
SELECT
CONCAT(source_chain, ' -> ', destination_chain) AS Chain_pairs,
transactions
FROM chains
ORDER BY 2 DESC
LIMIT 10