distinct TO_ADDRESS as claimers ,

sum(amount) as Claimed_amount,

rank() over(order by Claimed_amount desc) as rank

from ethereum.core.ez_token_transfers

where CONTRACT_ADDRESS = lower('0x24fcFC492C1393274B6bcd568ac9e225BEc93584')

and FROM_ADDRESS in ('0x7ad4c1647aa947d1c05425a8d4d155ef811a5f9e')

and ORIGIN_FUNCTION_SIGNATURE = '0x497de662'

group by 1

order by rank asc