with Table1 as (
select
a.BLOCK_TIMESTAMP::date as date,
count(distinct (signers[0])) as users
FROM solana.core.fact_events a
join solana.core.fact_transactions b
on a.tx_id = b.tx_id
where a.PROGRAM_ID = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo'
and a.BLOCK_TIMESTAMP >='2022-01-01'
group by 1
)
select
sum(users) as Total_users
from Table1