(GAS_USED * 100.0 / GAS_LIMIT) AS gas_efficiency_percentage

FROM polygon.core.fact_blocks

WHERE BLOCK_TIMESTAMP >= '2023-09-01'

AND BLOCK_TIMESTAMP < '2023-10-01'

ORDER BY gas_efficiency_percentage DESC;