with tab1 as (
SELECT
receiver
FROM osmosis.core.fact_airdrop
WHERE currency LIKE 'uosmo'
)
select
count(distinct LIQUIDITY_PROVIDER_ADDRESS)
from osmosis.core.fact_liquidity_provider_actions
where LIQUIDITY_PROVIDER_ADDRESS in (select * from tab1)
and action in ('pool_joined', 'pool_excited')