COUNT(DISTINCT TX_HASH) AS intents,

COUNT(FACT_INTENTS_ID) AS total_intents_submitted,

COUNT(DISTINCT TOKEN_ID) AS tokens_supported,

(SELECT COUNT(DISTINCT owner_id)

FROM (

SELECT OLD_OWNER_ID AS owner_id FROM near.defi.fact_intents

UNION ALL

SELECT NEW_OWNER_ID AS owner_id FROM near.defi.fact_intents

) AS all_users

) AS total_acc

FROM near.defi.fact_intents;