WITH active_users as (

SELECT count(distinct block_timestamp::date) as n_days,

tx_from as users

FROM osmosis.core.fact_transactions

WHERE tx_from is not null

GROUP BY users

having n_days >= {{days}} / 1.75),

type_users as (

SELECT 'staker', count(DISTINCT DELEGATOR_ADDRESS) as n_users

FROM osmosis.core.fact_staking

WHERE DELEGATOR_ADDRESS in (select users from active_users)

AND action = 'delegate'

UNION

SELECT 'airdrop', count(DISTINCT RECEIVER) as n_users

FROM osmosis.core.fact_airdrop

WHERE RECEIVER in (select users from active_users)

AND currency = 'uosmo')

SELECT * FROM type_users