WITH vTHOR_holdings AS (

SELECT

USER_ADDRESS AS address,

ROUND(CURRENT_BAL, 0) AS balance,

TOKEN_NAME

FROM

ethereum.core.ez_current_balances

WHERE

CONTRACT_ADDRESS = LOWER('0x815C23eCA83261b6Ec689b60Cc4a58b54BC24D8D')

),

formatted_vTHOR_holdings AS (

SELECT

address,

TO_CHAR(balance, '999999999999') AS formatted_balance,

balance,

TOKEN_NAME

FROM vTHOR_holdings

SELECT

address,

formatted_balance,

TOKEN_NAME,

(SELECT COUNT(*) FROM formatted_vTHOR_holdings) AS total_addresses,

(SELECT TO_CHAR(SUM(balance), '999999999999') FROM formatted_vTHOR_holdings) AS total_balance

FROM formatted_vTHOR_holdings

ORDER BY balance DESC;