-- WHERE platform = 'sushiswap'

-- ORDER BY creation_time DESC

select to_address, SUM(amount_usd) FROM ethereum.udm_events WHERE

to_address IN (

select pool_address FROM ethereum.dex_liquidity_pools

WHERE platform = 'sushiswap'

ORDER BY creation_time DESC

LIMIT 100

) GROUP BY to_address