trunc(block_timestamp,'week') as week,

count (distinct tx_from_address) as users,

LAG(users) IGNORE NULLS OVER (ORDER BY week) as last_users,

((users-last_users)/last_users)*100 as change_rate_users,

sum(1) as transactions,

LAG(transactions) IGNORE NULLS OVER (ORDER BY week) as last_transactions,

((transactions-last_transactions)/last_transactions)*100 as change_rate_transactions,

transactions/users as txs_per_user

from solana.transactions where block_timestamp>='2022-01-01' and succeeded='TRUE'

group by 1

order by 1 asc