select

distinct LIQUIDITY_PROVIDER_ADDRESS as LPer

from osmosis.core.fact_liquidity_provider_actions

WHERE ACTION in ('lp_tokens_minted','pool_joined')

and BLOCK_TIMESTAMP>='2022-01-01'

),

tb2 as ( select

distinct DELEGATOR_ADDRESS as staker

from osmosis.core.fact_staking

WHERE ACTION='delegate'

and BLOCK_TIMESTAMP>='2022-01-01')

select

case

when VOTER in (select LPer from tb1) then 'LP'

when VOTER in (select staker from tb2) then 'staker'

else null

end as gp,

count (distinct VOTER) as users_count,

count(distinct tx_id ) as count_recieved

from osmosis.core.fact_governance_votes

where BLOCK_TIMESTAMP>='2022-01-01'

group by 1 having gp is not null