select date_trunc ('week',block_timestamp) as date,

tx_from as Users,

count (distinct tx_id) as transactions_count

from osmosis.core.fact_transactions

where tx_status = 'SUCCEEDED'

group by 1,2

having transactions_count >= 20)

select

date,

count (distinct users) as active_Users

from tab

group by date