sarathbentobox_activity
    Updated 2022-03-22
    WITH eth AS (SELECT COUNT(DISTINCT tx_id) as no_of_txs, 'Bentobox Transactions on Ethereum' as type
    FROM ethereum.udm_events
    WHERE contract_address = '0xf5bce5077908a1b7370b9ae04adc565ebd643966'),

    polygon AS (SELECT COUNT(DISTINCT tx_id) as no_of_txs, 'Bentobox Transactions on Polygon' as type
    FROM polygon.udm_events
    WHERE contract_address = '0x0319000133d3ada02600f0875d2cf03d442c3367')

    SELECT * FROM eth
    UNION ALL
    SELECT * FROM polygon
    Run a query to Download Data