count(distinct tx_hash) as transactions,

count(distinct tx_signer) as users,

count(distinct iff(tx_status = 'Success', tx_hash, null)) as success_transactions,

transactions - success_transactions as failed_transactions,

transactions / count(distinct block_timestamp::date) as daily_average_transactions,

users / count(distinct block_timestamp::date) as daily_average_users

from near.core.fact_transactions

where tx_receiver = 'aurora'