select case when fee/1e6 < 0.0001 then '< 0.0001'
when fee/1e6 >= 0.0001 and fee/1e6 < 0.001 then '0.0001 - 0.001'
when fee/1e6 >= 0.001 and fee/1e6 < 0.01 then '0.001 - 0.01'
when fee/1e6 >= 0.1 and fee/1e6 < 1 then '0.1 - 1'
else '> 1' end as type,
count (distinct tx_id) as Transactions
from lava.core.fact_transactions
where block_timestamp >= '2024-07-30 11:00:00.000' -- Public Mainnet Launch
group by 1
order by 2 desc