CASE

WHEN gas_used < 100000 THEN 'Low (<100k)'

WHEN gas_used BETWEEN 100000 AND 500000 THEN 'Medium (100k - 500k)'

WHEN gas_used > 500000 THEN 'High (>500k)'

END AS gas_category,

COUNT(*) AS tx_count,

COUNT(*) * 100.0 / (SELECT COUNT(*) FROM MONAD.testnet.fact_transactions WHERE block_timestamp >= '2025-02-19 14:00:00') AS percentage

FROM MONAD.testnet.fact_transactions

WHERE block_timestamp >= '2025-02-19 14:00:00'

GROUP BY 1

ORDER BY tx_count DESC;