Updated 2023-02-11
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 t1 as (SELECT
'Aurory' as game,
min(block_timestamp) as date1,
signers[0] as "players"
FROM solana.core.fact_events
where program_id='STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5'
group by 1, 3
UNION
select
'Star Atlas' as game,
min(block_timestamp) as date1,
signers[0] as "players"
FROM solana.core.fact_events
where program_id='ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc'
group by 1, 3
UNION
select
'Genopets' as game,
min(block_timestamp) as date1,
signers[0] as "players"
FROM solana.core.fact_events
where program_id='StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
group by 1,3
order by 2
)
,t2 as (
SELECT
"players",
count(*) as "number of games",
case when "number of games" = 1 then 'Played 1 of Games'
when "number of games" = 2 then 'Played 2 of Games'
when "number of games" = 3 then 'Played 3 of Games' end as type
from t1
group by 1
Run a query to Download Data