alfredfx10gas fee in native token
    Updated 2024-08-08
    WITH Total_Transactions_Fees AS (
    SELECT STATUS,TX_FEE,'Arbitrum' AS Chain
    FROM arbitrum.core.fact_transactions
    WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
    UNION ALL
    SELECT STATUS,TX_FEE, 'Base' AS Chain
    FROM base.core.fact_transactions
    WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
    UNION ALL
    SELECT STATUS,TX_FEE, 'Blast' AS Chain
    FROM blast.core.fact_transactions
    WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
    UNION ALL
    SELECT STATUS,TX_FEE, 'Bsc' AS Chain
    FROM bsc.core.fact_transactions
    WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
    UNION ALL
    SELECT STATUS,TX_FEE, 'Polygon' AS Chain
    FROM polygon.core.fact_transactions
    WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
    UNION ALL
    SELECT STATUS,TX_FEE, 'Optimism' AS Chain
    FROM optimism.core.fact_transactions
    WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7'))

    SELECT STATUS,Chain,
    SUM (TX_FEE) AS "Total Transaction Fee"
    FROM Total_Transactions_Fees
    WHERE STATUS='SUCCESS'
    GROUP BY Chain, STATUS
    QueryRunArchived: QueryRun has been archived