nitsCopy of Copy of Users who have used Tinyman and also other DEXs but they have used other DEX's first
    Updated 2022-03-30
    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
    Run a query to Download Data