as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
construct a sql query to identify the top 5 users with the most transactions
user
select users.name, count(transactions.id) as total_transaction
from users inner join transactions on users.id = transactions.user_id
group by users.name
order by total_transactions desc
limit 5;
assistant