SELECT
TX_SIGNER AS Top_active_wallets,
COUNT(DISTINCT TXN_HASH) AS Number_of_txns
FROM flipside_prod_db.mdao_near.transactions
WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90 --IN THE LAST 90 DAYS
GROUP BY Top_active_wallets
ORDER BY Number_of_txns DESC
LIMIT 10