SELECT

token_address,

symbol,

decimals,

avg_price_usd

FROM

$query('eb8c7a0a-f771-4e55-9140-8aeb5f2e7c45')

),

UserTransfers AS (

SELECT

ACCOUNT_ADDRESS,

INFLOW_AMOUNT,

TOKEN_ADDRESS

FROM

$query('bcb0a7d3-612f-4e13-9cdc-835fb48b153a')

SELECT

tp.symbol,

ROUND(SUM((ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd), 2) AS total_inflow_usd

FROM

UserTransfers ut

JOIN

token_price_and_decimal tp

ON

ut.TOKEN_ADDRESS = tp.token_address

GROUP BY

tp.symbol

HAVING

SUM((ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd) IS NOT NULL

ORDER BY

total_inflow_usd DESC

LIMIT 10;