adriaparcerisassol games 3
Updated 2023-05-24
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
33
34
35
36
›
⌄
with
aurory as (
SELECT
distinct signers[0] as users,
'Aurory' as program
--min(block_timestamp) as debut
from solana.core.fact_events
where program_id in ('STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5')
--group by 1,2
),
staratlas as (
SELECT
distinct signers[0] as users,
'Star Atlas' as program
--min(block_timestamp) as debut
from solana.core.fact_events
where program_id in ('ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc')
--group by 1,2
),
genopets as (
SELECT
distinct signers[0] as users,
'Genopets' as program
--min(block_timestamp) as debut
from solana.core.fact_events
where program_id in ('StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v')
--group by 1,2
),
trio as (
select count(distinct users) as "Users" from aurory where users in (select users from genopets) and users in (select users from staratlas)
),
aurory_genopets as (
select count(distinct users) as "Aurory-Genopets users" from aurory where users in (select users from genopets) and users not in (select users from staratlas)
),
aurory_staratlas as (
Run a query to Download Data