COUNT(DISTINCT tx_id) AS total_transactions,

COUNT(DISTINCT tx_from) AS total_users,

total_transactions/total_users AS avg_tx_per_user

FROM sei.core.fact_transactions

WHERE block_timestamp::DATE >= '2023-08-15'

AND tx_succeeded = 'TRUE'