user_address,

Round(

Sum(eth_balance),

2

) AS total_eth_balance

FROM

(

SELECT

user_address,

balance AS eth_balance

FROM

flipside_prod_db.ethereum.erc20_balances

WHERE

balance_date = CURRENT_DATE

AND contract_address = 'ETH'

AND label IS NULL

AND balance > 10000

ORDER BY

2 DESC

)

GROUP BY

user_address

ORDER BY

total_eth_balance DESC