with all_swappers as
(SELECT swapper, min(block_timestamp) as first_use from algorand.swaps
where swap_program != 'tinyman'
GROUP by 1 ),
tinyman_swappers as
(SELECT swapper as swapper_t, min(block_timestamp) as first_use_t from algorand.swaps
where swap_program = 'tinyman'
GROUP by 1 )
SELECT count(DISTINCT swapper) as unique_first_swappers_of_other_dexs
-- SELECT *
from
(SELECT * from all_swappers
inner join tinyman_swappers
on first_use_t < first_use and swapper= swapper_t)
limit 10