tab1 as (

SELECT

tx_signer as neth_wallet,

min(block_timestamp) as creation_time

FROM near.core.fact_transactions

WHERE tx_receiver = 'nethmap.near' and tx_signer != 'nethmap.near'

AND block_timestamp >= '2022-12-19'

GROUP BY 1

ORDER BY 2 DESC)

count(DISTINCT tx_hash) as "Transactions",

count(DISTINCT tx_signer) as "active wallets",

"Transactions"/"active wallets" as "Avg tx per wallet"

FROM near.core.fact_transactions

WHERE TX_SIGNER IN (SELECT neth_wallet FROM tab1)

order by 1 asc