chain,

AVG(gas_used) AS avg_gas,

SUM(gas_used) AS total_gas

FROM (

SELECT

'Aptos' AS chain,

gas_used

FROM

aptos.core.fact_transactions

UNION ALL

SELECT

'Ethereum' AS chain,

gas_used

FROM

ethereum.core.fact_transactions

) sub

GROUP BY

chain;