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

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

    SELECT * FROM eth
    UNION ALL
    SELECT * FROM polygon