select * from (
select
pool_name,
count(tx_id) as swaps,
sum(amount_usd) as swap_usd_vol
from ethereum.dex_swaps
where platform = 'sushiswap'
-- and tx_id = '0x248127092c1a6274e0749f043cb6adbc73290ef78e832231b1d5de4f18d72255'
and direction = 'IN'
group by 1
)
where swap_usd_vol is not null
order by swap_usd_vol desc
limit 20