Medium
Generate SQL Query
Write a SQL query to join tables and calculate totals.
📝 Prompt Content
Write a SQL query that joins a 'users' table and an 'orders' table on user_id. The query should return the user's name and their total order amount, limited to the top 10 users who have spent the most.