event_attributes:"1_contract_address"::string as token_address, sum(event_attributes:"0_amount"/1e6) as amount_claimed, CASE

when event_attributes:"1_contract_address"::string = 'terra12897djskt9rge8dtmm86w654g7kzckkd698608' then '$PSI'

when event_attributes:"1_contract_address"::string = 'terra1nef5jf6c7js9x6gkntlehgywvjlpytm7pcgkn4' then '$LOOP'

when event_attributes:"1_contract_address"::string = 'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' then '$MINE'

when event_attributes:"1_contract_address"::string = 'terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76' then '$ANC'

when event_attributes:"1_contract_address"::string = 'terra15gwkyepfc6xgca5t5zefzwy42uts8l2m4g40k6' then '$MIR'

else '$STT' end as token

from terra.msg_events

where event_attributes:"0_action"::string = 'claim' and event_type = 'wasm' and tx_status = 'SUCCEEDED' and block_timestamp >= CURRENT_DATE - 90

group by 1

order by 2 desc)

select *, case

when token = '$PSI' then '10000000000'

when token = '$LOOP' then '100000000'

when token = '$MINE' then '10000000000'

when token = '$ANC' then '1000000000'

when token = '$MIR' then '370575000'

when token = '$STT' then '100000000'

else 'nil' end as total_supply,

(amount_claimed/total_supply) * 100 as percentage_airdrop_claimed

from airdrop

order by amount_claimed desc