pool_name,

CONTRACT_ADDRESS as pool_address,

sum(amount_in_usd) as swap_volume_usd,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM ethereum.core.ez_dex_swaps

WHERE amount_in_usd < amount_out_usd * 2

AND platform LIKE 'sushiswap'

GROUP BY 1,2

ORDER BY 3 DESC

LIMIT 50