COUNT(*) AS domains_registered,

COUNT(DISTINCT signers[0]) as users,

domains_registered/users as avg_domains_per_user

FROM solana.core.fact_transactions

WHERE instructions[0]:programId = 'TLDHkysf5pCnKsVA4gXpNvmy7psXLPEu4LAdDJthT9S'

AND (

(log_messages[1] LIKE '%Buy' AND (log_messages[2] LIKE '%.bonk' OR log_messages[2] LIKE '%.poor'))

OR

(log_messages[1] LIKE '%BuyOrExtendRenewable' AND (log_messages[2] LIKE '%.abc' OR log_messages[2] LIKE '%.moon'))

OR log_messages[2] like 'Program log: Claiming an expirable domain%'

)