from_ADDRESS AS "Airdrop Address",

to_ADDRESS AS "Claimant",

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

SUM(amount) AS "Claimed Amount"

FROM ethereum.core.ez_token_transfers

WHERE contract_address = LOWER('0x90685e300A4c4532EFCeFE91202DfE1Dfd572F47')

AND to_ADDRESS != LOWER('0x06a3d02931b6c8bb65e01a20473a8c9910c7d70c')

AND (from_ADDRESS = LOWER('0x5FDCCA53617f4d2b9134B29090C87D01058e27e9')

OR from_ADDRESS=LOWER('0x5FDCCA53617f4d2b9134B29090C87D01058e27e9'))

GROUP BY from_ADDRESS,to_ADDRESS

ORDER BY "Claimed Amount" DESC