Sbhn_NPaware-peach
Updated 2024-09-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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