ValiMohammadiTotal common users of Genopets & StarAtlas
Updated 2023-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with Aurory as (select signers[0] as users , min(block_timestamp::date) as register_date from solana.core.fact_events
where program_id='STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5' and SUCCEEDED=1
group by 1
)
, StarAtlas as (select signers[0] as users , min(block_timestamp::date) as register_date from solana.core.fact_events
where program_id='ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc' and SUCCEEDED=1
group by 1
)
, Genopets as (select signers[0] as users , min(block_timestamp::date) as register_date from solana.core.fact_events
where program_id='StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v' and SUCCEEDED=1
group by 1
)
select count(*) from StarAtlas where users in (select users from Genopets)
Run a query to Download Data