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