from_ADDRESS AS "Airdrop Address",

to_ADDRESS AS "Claimant",

MIN(RTRIM(BLOCK_TIMESTAMP::date)) AS "Claim Date",

SUM(amount) AS "Claimed Amount"

FROM avalanche.core.ez_token_transfers

WHERE contract_address = LOWER('0x46B9144771Cb3195D66e4EDA643a7493fADCAF9D')

AND (from_ADDRESS = LOWER('0x70E4710EFF2B4E0629d0a579De22fDBcE510D5Ea')

OR from_ADDRESS=LOWER('0x83623490755142FD743c48a1347F32772269793a')

OR from_ADDRESS=LOWER('0x1d03a9F4C9ebDb4088881e963E0d4EeC7d482d6D') --p2a address

OR from_ADDRESS=LOWER('0xD58b9FFC4cDe0D3C29736Bb790aEc4b385075b94')

OR from_ADDRESS=LOWER('0x6C6958D0655d719dF6a7523250A90F99711Ab3Dd')

)

GROUP BY from_ADDRESS,to_ADDRESS

ORDER BY "Claimed Amount" DESC