SELECT swapper, SUM(swap_from_amount) AS total_swap_from_amount

FROM solana.defi.fact_swaps

WHERE swapper NOT IN (

SELECT swapper

FROM (

SELECT swapper

FROM solana.defi.fact_swaps

WHERE (swap_to_mint = 'H8yTNoEFiPa9WBKWHxBUC9gRCYufdmcwafjccKLupump'

OR swap_from_mint = 'H8yTNoEFiPa9WBKWHxBUC9gRCYufdmcwafjccKLupump')

AND block_timestamp BETWEEN '2024-10-17 05:25:00' AND '2024-10-17 05:27:00'

GROUP BY block_id, swapper

HAVING SUM(CASE WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' THEN 1 ELSE 0 END) > 0

AND SUM(CASE WHEN swap_to_mint = 'So11111111111111111111111111111111111111112' THEN 1 ELSE 0 END) > 0

)

)

AND swap_from_mint = 'So11111111111111111111111111111111111111112'

AND swap_from_amount > 0.1

GROUP BY swapper

HAVING SUM(swap_from_amount) > 0.6

ORDER BY total_swap_from_amount DESC;