count(DISTINCT from_address) as n_users,

count(DISTINCT a.tx_hash) as n_txns,

sum(TX_FEE) as consumed_fee,

count(DISTINCT contract_address) as "# Active Contract",

consumed_fee/"# Active Contract" as "Avg Fee Per Contract",

consumed_fee/n_txns as "Avg Fee Per Tx",

n_users/"# Active Contract" as "Avg User Per Contract",

n_txns/"# Active Contract" as "Avg Tx Per Contract"

from kaia.core.fact_transactions a

left outer join kaia.core.fact_event_logs b on a.tx_hash = b.tx_hash

where a.TX_SUCCEEDED = 'TRUE'