with b as (select date_trunc('day',t) as dt, tx_sender, count(distinct tx_id) as n_txn

from (select tx_sender, block_timestamp as t, tx_id

from terra.core.fact_transactions

where FEE_DENOM='uluna'

)

group by 1, 2),

c as (select date_trunc('week',dt) as w, avg(n_txn) as avg_txn

from b

group by 1)

, d as (select date_trunc('week',dt) as week,tx_sender, sum(n_txn) as tot_txn from b group by 1,2)

select count(distinct tx_sender)

from (select d.week,tx_sender, tot_txn

from d inner join c on c.w=d.week

where c.avg_txn<d.tot_txn)