(SELECT COUNT(DISTINCT TX_HASH) / NULLIF(COUNT(DISTINCT FROM_ADDRESS), 0)

FROM base.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= '2024-01-01') AS avg_transactions_per_user,

(SELECT COUNT(TX_HASH)

FROM base.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= '2024-01-01') AS total_transaction_count,

(SELECT COUNT(DISTINCT FROM_ADDRESS)

FROM base.core.fact_transactions AS ft

WHERE ft.BLOCK_TIMESTAMP >= '2024-01-01'

AND ft.BLOCK_TIMESTAMP = (

SELECT MIN(BLOCK_TIMESTAMP)

FROM base.core.fact_transactions

WHERE FROM_ADDRESS = ft.FROM_ADDRESS

)) AS new_user_count;