count (distinct date (block_timestamp)) as active_days

from osmosis.core.fact_transactions where TX_STATUS ilike 'SUCCEEDED' and block_timestamp >= '2022-01-01'

group by 1,2

having active_days >= 4),

tab2 as (select week1, tx_from as daily_active_user, active_days from tab1)

select date_trunc( 'week',block_timestamp) as week, count (distinct daily_active_user) as total_active_user

from osmosis.core.fact_transactions join tab2

on daily_active_user = tx_from WHERE block_timestamp >= '2022-01-01'

group by 1