Hadisehflow vs 6
Updated 2022-07-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with t1 as ( select min(block_timestamp) as day , signers
from solana.core.fact_transactions
where block_timestamp::date >= '2022-05-18' and block_timestamp::date <= '2022-06-18'
group by signers)
,
t2 as ( select min(block_timestamp) as days , signers
from solana.core.fact_transactions
where signers in ( select signers from t1)
and block_timestamp::date > '2022-06-18'
group by signers)
select 'Not Retention ' as state , count(DISTINCT signers) as unique_user
from t1
where signers not in ( select signers from t2)
group by 1
UNION
select 'Retention' as state , count(DISTINCT signers) as unique_user
from t2
group by 1
Run a query to Download Data