-- select
-- (sum(amount ) / pow(10,6))::string || ' 🌊' as total_claimed
-- -- 50000000 - total_claimed as total_unclaimed
-- from osmosis.core.fact_airdrop
-- where currency = 'uosmo'
select
sender,
sum(amount) / 1e6
-- count(1) as claim_count
from osmosis.core.fact_airdrop
where currency = 'uosmo'
group by sender
order by 2 desc