WITH swap_to_bank AS (SELECT * FROM ethereum.dex_swaps
WHERE token_address='0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198'
AND direction ='OUT')
SELECT pool_name, platform
FROM ethereum.dex_swaps
WHERE direction='IN' AND tx_id IN (SELECT tx_id from swap_to_bank)
GROUP BY platform, pool_name
ORDER BY platform