with new_users_transactions as
(
SELECT count(*) as COUNT,tx_from_address, MIN(block_timestamp :: date) As FIRST_PROGRAM_DATE
FROM solana.transactions
where program_id !='11111111111111111111111111111111' and block_timestamp :: date >= '2022-02-01'
and tx_from_address in (select tx_from_address from solana.transactions
where program_id ='11111111111111111111111111111111' and block_timestamp :: date >= '2022-02-01')
GROUP BY tx_from_address
)
select sum(COUNT)/count(*) as AVERAGE from new_users_transactions