Query editor
WITH avalanche_transactions AS (SELECT COUNT(tx_hash) AS total_transactionsFROM avalanche_c.logsWHERE contract_address = 0x06e9b71283700d1a319070f14976d3aba6c27745),polygon_transactions AS (SELECT COUNT(tx_hash) AS total_transactionsFROM polygon.logsWHERE contract_address = 0x30632A3c801031A5D6A1B3589966B60Ee2FBc301)SELECT (SELECT total_transactions FROM avalanche_transactions) +(SELECT total_transactions FROM polygon_transactions) AS total_combined_transactions;