SELECT STATUS,TX_HASH,'Arbitrum' AS Chain

FROM arbitrum.core.fact_transactions

WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')

AND STATUS='SUCCESS'

UNION ALL

SELECT STATUS,TX_HASH, 'Base' AS Chain

FROM base.core.fact_transactions

WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')

AND STATUS='SUCCESS'

UNION ALL

SELECT STATUS,TX_HASH, 'Blast' AS Chain

FROM blast.core.fact_transactions

WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')

AND STATUS='SUCCESS'

UNION ALL

SELECT STATUS,TX_HASH, 'Bsc' AS Chain

FROM bsc.core.fact_transactions

WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')

AND STATUS='SUCCESS'

UNION ALL

SELECT STATUS,TX_HASH, 'Polygon' AS Chain

FROM polygon.core.fact_transactions

WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')

AND STATUS='SUCCESS'

UNION ALL

SELECT STATUS,TX_HASH, 'Optimism' AS Chain

FROM optimism.core.fact_transactions

WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')

AND STATUS='SUCCESS')

SELECT Chain,

COUNT (DISTINCT TX_HASH) AS "Total Cubes Minted",

FROM Total_Cubes_Transactions

GROUP BY Chain

ORDER BY CHAIN ASC