sum(trxs) as total_trxs,

sum(users) as total_users

FROM (SELECT date_trunc('day', block_timestamp) as day,

count(DISTINCT block_hash) as trxs,

count(distinct FROM_ADDRESS) as users

FROM avalanche.core.fact_transactions

GROUP BY 1

)

where day>= CURRENT_DATE - 90

GROUP BY 1