WITH wallets AS (
SELECT sender,
COUNT(DISTINCT tx_id) as tx_count
FROM flipside_prod_db.algorand.transactions
WHERE block_timestamp > '2022-01-01' AND fee > 0
GROUP BY sender
)
SELECT
sender as "Wallet",
tx_count AS "Total Number of Transactions"
FROM wallets
ORDER BY tx_count DESC
LIMIT 100