with a as (
select
date_trunc(day, block_timestamp) as date,
from_address,
count(*) as num_transactions
from bsc.core.fact_transactions
where block_timestamp > '2022-10-02'
group by date, from_address
order by date desc
)
select
a.date,
count (distinct a.from_address) as num_high_add,
sum(a.num_transactions) as total_high_transactions
from a
where a.num_transactions > 100
group by date
order by date desc