2844 percent of pactfi's user's that previously used Tinyman to perform swaps
    Updated 2022-03-28
    with
    Tinyman_Pactfi as
    (with Pactfi as (select distinct swapper as P_users
    from algorand.swaps
    where swap_program like '%pactfi%'
    and SWAP_FROM_AMOUNT > '0'
    ),
    tinyman as
    (select distinct swapper as T_users
    from algorand.swaps
    where swap_program like '%tinyman%'
    and SWAP_FROM_AMOUNT > '0'
    )
    select count(tinyman.T_users) as N_Pactfi_tinyman_users
    from Pactfi, tinyman
    where pactfi.P_users=tinyman.T_users),
    Pactfi_users as
    (
    select count(distinct swapper) as N_Pactfi_users
    from algorand.swaps
    where swap_program like '%pactfi%'
    and SWAP_FROM_AMOUNT > '0')

    select ((Tinyman_pactfi.N_Pactfi_tinyman_users)/ (Pactfi_users.N_pactfi_users) * 100) as "percent of Pactfi's uesrs that previously used Tinyman to perform swaps"
    from Pactfi_users, Tinyman_Pactfi
    Run a query to Download Data