address,

ROUND((SUM(amount) / 1000000000000000000)) AS formatted_greed

FROM (

SELECT

from_address AS address,

-raw_amount AS amount

FROM

blast.core.fact_token_transfers

WHERE

contract_address = LOWER('0xe6a062fba3918376500a602c800b1e0307420457')

UNION ALL

SELECT

to_address AS address,

raw_amount AS amount

FROM

blast.core.fact_token_transfers

WHERE

contract_address = LOWER('0xe6a062fba3918376500a602c800b1e0307420457')

) AS combined

GROUP BY

address

ORDER BY

formatted_greed DESC;