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