airdrop_count,

count(1)

from (

select

receiver,

count(1) as airdrop_count

from osmosis.core.fact_airdrop

where tx_status = 'SUCCEEDED'

and currency = 'uosmo'

group by receiver

)

group by 1