Top Customer by Orders

You are given the following tables:

transactions table:

products table:

users table:

Write a query to find the name of the customer who has placed the largest number of orders in total. Your output should have the following column: user_id, name, orders (Total number of orders made by the user)