date_trunc('minute',block_timestamp) as minute,

TX_SENDER as bt_address,

count (tx_id) as count_transacions

from terra.core.fact_transactions

group by 1, 2 having count_transacions > 20)

select

date_trunc('{{Time_basis}}',BLOCK_TIMESTAMP) as date,

when TX_SENDER in (select bt_address from tb1 ) then 'BOTS'

else 'Regular Users' end as wlts,

count (tx_id) as count_transactions,

sum(FEE) as paid_fee

from terra.core.fact_transactions

group by 1,2