strawbettyWallets that transacted in Wagmiswap and Tinyman
    Updated 2022-04-04
    with q1 as (
    select
    'wagmiswap' as dex,
    count(DISTINCT(swapper)) as users
    from algorand.swaps
    where swap_program = 'wagmiswap'
    and swapper not in (select DISTINCT(swapper) from algorand.swaps where swap_program = 'Wagmiswap')
    ), q2 as (
    select
    'wagmiswap + tinyman' as dex,
    count(DISTINCT(swapper)) as users
    from algorand.swaps
    where swap_program = 'wagmiswap'
    and swapper in (select DISTINCT(swapper) from algorand.swaps where swap_program = 'tinyman')
    )

    SELECT * FROM q1
    UNION
    SELECT * FROM q2
    Run a query to Download Data