select POOL_NAME

,sum(AMOUNT_IN) as sell_volume

,count(distinct TX_HASH) as sell_count

from avalanche.defi.ez_dex_swaps

where TOKEN_IN ='0x62d0a8458ed7719fdaf978fe5929c6d342b0bfce'

and PLATFORM in ('trader-joe-v1','trader-joe-v2')

group by 1

order by 2 desc