Pmisha-bmlMdxalgofi
Updated 2022-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with t1 as(
SELECT
count(distinct SWAPPER) as algofi_wallets
from algorand.swaps
where SWAP_PROGRAM = 'algofi'),
t2 as (
SELECT
count(distinct SWAPPER) as tinyman_algofi
from algorand.swaps
where SWAP_PROGRAM = 'algofi'
and SWAPPER in (
select SWAPPER from algorand.swaps
where SWAP_PROGRAM = 'tinyman'
)
)
select algofi_wallets,tinyman_algofi, tinyman_algofi/algofi_wallets*100 as wallets_percent from t1,t2
Run a query to Download Data