PapasotDistinct swappers (pactfi) % tinyman
    Updated 2023-01-03
    with pact_swaps as
    (select
    swapper,
    swap_program
    from algorand.swaps
    where
    swap_program = 'pactfi'),

    tiny_swaps as
    (select
    swapper,
    swap_program
    from algorand.swaps
    where
    swap_program = 'tinyman')
    select
    count (distinct a.swapper),
    b.swap_program
    from pact_swaps a
    left join tiny_swaps b on b.swapper = a.swapper
    group by b.swap_program

    Run a query to Download Data