with list_of_token_pools as (select POOL_NAME,POOL_ADDRESS from ethereum.dex_liquidity_pools
where TOKEN0 like '%0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198%')
select POOL_NAME,count(DISTINCT tx_id) as tx_count,sum(amount_usd ) as sum_usd from ethereum.dex_swaps
where POOL_ADDRESS in(select POOL_ADDRESS from list_of_token_pools) group by POOL_NAME order by POOL_NAME DESC