count(distinct(claimer)) as claimers,

sum(amount) as total_loop_claimed

from terra.airdrop_claims

where contract_address = 'terra1atch4d5t25csx7ranccl48udq94k57js6yh0vk' -- loop airdrop contract

and airdrop_id = '3' -- the latest loop airdrop has an ID of 3