feyikemiAxelar Top Chain Pairs By Transaction
    Updated 2024-07-21
    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
    QueryRunArchived: QueryRun has been archived