case when (SWAP_to_AMOUNT - SWAP_FROM_AMOUNT) > 0 then 'successful' when (SWAP_to_AMOUNT - SWAP_FROM_AMOUNT) <= 0 then 'fail' end as Arbitrage

from algorand.swaps

where (SWAP_FROM_ASSET_ID='31566704' or SWAP_FROM_ASSET_ID='312769')

and (SWAP_to_ASSET_ID='31566704' or SWAP_to_ASSET_ID='312769')

and BLOCK_TIMESTAMP > '2022-01-01'

group by Arbitrage