select

count(distinct tx_to) as claimers ,

20 as airdrop_amt, -- 20,000,000

1 as total_supply, -- 1,000,000,000

sum(amount) as volume ,

avg(amount) as avg_volume,

max(amount) as max_volume,

min(amount) as min_volume,

median(amount) as median_volume,

20000000 - volume as unclaimed_amount,

(volume * 100)/20000000 as claimed_percentage,

(20000000*100)/1000000000 as airdrop_ratio

from solanaUpdate.core.fact_transfers

where

tx_from = '4cZgUw6T8yYQ2CordAfSzS4Q5VKJNyVU3JEX6xGg2Xwy'

and mint = 'NYANpAp9Cr7YarBNrby7Xx4xU6No6JKTBuohNA3yscP'

and tx_to != 'C8FXTcztFpdjMjPZYtu6mMTs3M5fLzNKR7Q6vymkQC8e'

and amount > 0