2844percent of WagmiSwap's user's that previously used Tinyman to perform swaps
    Updated 2022-03-28
    with
    Tinyman_wagmiswap as
    (with wagmiswap as (select distinct swapper as W_users
    from algorand.swaps
    where swap_program = 'wagmiswap'
    and SWAP_FROM_AMOUNT > '0'
    ),
    tinyman as
    (select distinct swapper as T_users
    from algorand.swaps
    where swap_program = 'tinyman'
    and SWAP_FROM_AMOUNT > '0'
    )
    select count(tinyman.T_users) as N_wagmiswap_tinyman_users
    from wagmiswap , tinyman
    where wagmiswap.W_users=tinyman.T_users),
    WagmiSwap_users as
    (
    select count(distinct swapper) as N_wagmiswap_users
    from algorand.swaps
    where swap_program = 'wagmiswap'
    and SWAP_FROM_AMOUNT > '0')

    select ((Tinyman_WagmiSwap.N_WagmiSwap_tinyman_users) / (WagmiSwap_users.N_WagmiSwap_users) * 100) as "percent of WagmiSwap's uesrs that previously used Tinyman to perform swaps"
    from WagmiSwap_users, Tinyman_WagmiSwap
    Run a query to Download Data