Number of Dapps | Number of Users | |
|---|---|---|
1 | n=10 | 21081 |
2 | n=9 | 26780 |
3 | n=6 | 36911 |
4 | n=8 | 39925 |
5 | n=7 | 40225 |
6 | n=5 | 47063 |
7 | n=4 | 48090 |
8 | n>10 | 58865 |
9 | n=3 | 75745 |
10 | n=2 | 81820 |
11 | n=1 | 564657 |
Eman-RazInteraction with Dapps
Updated 7 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with tab1 as (select signers[0] as user, count(distinct program_id), CASE
when count(distinct program_id)=1 then 'n=1'
when count(distinct program_id)=2 then 'n=2'
when count(distinct program_id)=3 then 'n=3'
when count(distinct program_id)=4 then 'n=4'
when count(distinct program_id)=5 then 'n=5'
when count(distinct program_id)=6 then 'n=6'
when count(distinct program_id)=7 then 'n=7'
when count(distinct program_id)=8 then 'n=8'
when count(distinct program_id)=9 then 'n=9'
when count(distinct program_id)=10 then 'n=10'
when count(distinct program_id)>10 then 'n>10'
end as "Number of Dapps"
from eclipse.core.fact_events
where succeeded='TRUE' and program_id not in (
'11111111111111111111111111111111',
'ComputeBudget111111111111111111111111111111',
'BPFLoaderUpgradeab1e11111111111111111111111',
'Stake11111111111111111111111111111111111111',
'TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb',
'ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL',
'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA')
group by 1)
select "Number of Dapps", count(distinct user) as "Number of Users"
from tab1
group by 1
order by 2
Last run: 7 days ago
11
158B
560s