SELECT

s.value::string as wallet,

COUNT(distinct tx_id) as tx_count

FROM eclipse.core.fact_transactions,

LATERAL FLATTEN(input => signers) s

WHERE succeeded = TRUE

GROUP BY 1

SELECT

wallet,

tx_count,

RANK() OVER (ORDER BY tx_count DESC) as rank

FROM wallet_tx_counts

ORDER BY tx_count DESC

LIMIT 1000;