SELECT

pool_address,

platform

FROM flipside_prod_db.ethereum_core.dim_dex_liquidity_pools

WHERE pool_name LIKE '%SUSHI%'

SELECT

balance_date,

platform,

sum(BALANCE) as tokens,

sum(amount_usd) as token_value

FROM flipside_prod_db.ethereum.erc20_balances

LEFT outer JOIN tab1 on pool_address = user_address

WHERE user_address in (SELECT pool_address from tab1)

AND balance_date > CURRENT_DATE - 90

AND symbol like 'SUSHI'

GROUP BY 1,2