tx_signer AS user,

COUNT(DISTINCT tx_hash) AS count_interactions

FROM

near.core.fact_transactions

WHERE

tx_receiver='aurora'

AND

tx_signer NOT IN ('relay.aurora')

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10