SELECT user_address, COUNT(*) AS transaction_count
FROM transactions
GROUP BY user_address
ORDER BY transaction_count DESC;