AVG(EFFECTIVE_GAS_PRICE) / AVG(MAX_FEE_PER_GAS) AS gas_efficiency_ratio

FROM ethereum.core.fact_transactions

WHERE MAX_FEE_PER_GAS IS NOT NULL

AND EFFECTIVE_GAS_PRICE IS NOT NULL

AND YEAR(BLOCK_TIMESTAMP) = YEAR(CURRENT_DATE()); -- Filter for this year