Sbhn_NPaware-peach
    Updated 2024-09-25
    with base as (select DISTINCT from_address,
    sum(tx_fee_precise) as fee
    from berachain.testnet.fact_transactions
    where block_timestamp::date >= '2024-06-01'
    and tx_succeeded
    group by 1)

    select case when fee<0.1 then 'Less han 0.1 $BERA'
    when fee>=0.1 and fee<1 then '0.1 - 1 $BERA'
    when fee>=1 and fee<10 then '1 - 10 $BERA'
    when fee>=10 and fee<100 then '10 - 100 $BERA'
    else 'More Than 100 $BERA' end as splitter,
    count(DISTINCT from_address) as users
    from base
    group by 1
    QueryRunArchived: QueryRun has been archived