WITH to_address_amount AS (
SELECT FROM_ADDRESS, COUNT(TO_ADDRESS) as TO_COUNT
FROM ethereum.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = {{contract_address}}
GROUP BY FROM_ADDRESS
)
SELECT FROM_ADDRESS, SUM(AMOUNT) AS TOTAL_AMOUNT
FROM ethereum.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = {{contract_address}}
AND FROM_ADDRESS IN (SELECT FROM_ADDRESS FROM to_address_amount WHERE TO_COUNT = 1)
GROUP BY FROM_ADDRESS
ORDER BY TOTAL_AMOUNT DESC