Query editor
WITHpolygon_contract_deployments_counter AS (WITHcontract_deployments AS (SELECTtx_hash AS tx_hash,count(index) AS contracts_deployedFROMpolygon.logsWHEREblock_time >= TIMESTAMP '2023-01-01 00:00:00'AND block_time < TIMESTAMP '2024-01-01 00:00:00'AND contract_address = 0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55AND topic0 = 0xa802207d4c618b40db3b25b7b90e6f483e16b2c1f8d3610b15b345a718c6b41bGROUP BYtx_hash)SELECT'Polygon' AS network_name, SUM(contracts_deployed) AS contracts_deployedFROMcontract_deployments),avalanche_contract_deployments_counter AS (WITHcontract_deployments AS (SELECTtx_hash AS tx_hash,count(index) AS contracts_deployedFROMavalanche_c.logsWHEREblock_time >= TIMESTAMP '2023-01-01 00:00:00'AND block_time < TIMESTAMP '2024-01-01 00:00:00'AND contract_address = 0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55AND topic0 = 0xa802207d4c618b40db3b25b7b90e6f483e16b2c1f8d3610b15b345a718c6b41bGROUP BYtx_hash)SELECT'Avalanche' AS network_name, SUM(contracts_deployed) AS contracts_deployedFROMcontract_deployments),ethereum_contract_deployments_counter AS (WITHcontract_deployments AS (SELECTtx_hash AS tx_hash,count(index) AS contracts_deployedFROMethereum.logsWHEREblock_time >= TIMESTAMP '2023-01-01 00:00:00'AND block_time < TIMESTAMP '2024-01-01 00:00:00'AND contract_address = 0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55AND topic0 = 0xa802207d4c618b40db3b25b7b90e6f483e16b2c1f8d3610b15b345a718c6b41bGROUP BYtx_hash)SELECT