count(DISTINCT from_address) as users,

count(DISTINCT a.tx_hash) as txns,

count(DISTINCT contract_address) as "Active Contracts",

users/"Active Contracts" as "Avg User Per Contract"

from avalanche.core.fact_transactions a left outer join avalanche.core.fact_event_logs b on a.tx_hash = b.tx_hash

where a.STATUS = 'SUCCESS'

and a.block_timestamp::date >= '2024-01-01'

and b.block_timestamp::date >= '2024-01-01'