week,

count(DISTINCT LIQUIDITY_PROVIDER_ADDRESS) as users_per_week

FROM (

SELECT

date_trunc('week', day) as week,

LIQUIDITY_PROVIDER_ADDRESS,

count(*) as actvie_days

FROM (

SELECT

date_trunc('day', block_timestamp) as day,

LIQUIDITY_PROVIDER_ADDRESS

FROM osmosis.core.fact_liquidity_provider_actions

GROUP BY 1,2

)

GROUP BY 1,2

WHERE actvie_days >= 4

GROUP BY 1

SELECT

avg(users_per_week),

max(users_per_week)

FROM tab1