CASE WHEN name is null THEN a.symbol ELSE name END as token,

sum(SUPPLIED_USD) as volume_usd,

count(*) as events

FROM flipside_prod_db.aave.deposits a

left outer JOIN ethereum.core.dim_contracts b

ON b.address = a.symbol

WHERE depositor_address LIKE lower('{{User}}')

and token is not null

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10