Crazy_KidBentobox 2
Updated 2022-03-22
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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