select

block_id,

sum(gas_used) as gas_per_block

from ethereum.TRANSACTIONs

where block_id >= 12965000

group by 1

select

case

when gas_per_block < 5e6 then '<05m'

when gas_per_block < 10e6 then '<10m'

when gas_per_block < 15e6 then '<15m'

when gas_per_block < 20e6 then '<20m'

when gas_per_block < 25e6 then '<25m'

when gas_per_block < 30e6 then '<30m'

when gas_per_block < 35e6 then '<35m'

end as bucket,

count(distinct gas_per_block)

from blocks

where bucket is not null

group by 1

order by 1