signers[0] as user,

min(block_timestamp) as first_tx

from solana.core.fact_events

where succeeded

and program_id = 'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc'

group by user),

aurory_users as (select

signers[0] as user,

min(block_timestamp) as first_tx

from solana.core.fact_events

where succeeded

and program_id = 'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5'

group by user

),

genopets_users as (select

signers[0] as user,

min(block_timestamp) as first_tx

from solana.core.fact_events

where succeeded

and program_id = 'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'

group by user

),

final as (select count(*) as n_users, 'star_atlas' as label from star_atlas_users

union

select count(*) as n_users, 'aurory' as label from aurory_users

union

select count(*) as n_users, 'genopets' as label from genopets_users),

final_distinct as (select user from star_atlas_users

union

select user from aurory_users

union