hard
Write a SQL Query
Generate a SQL statement based on specific requirements.
📝 Contenuto del prompt
Act as a database administrator. Write a SQL query to select the top 10 customers with the highest total order amount from a table named orders. Assume the columns are customer_id and total_amount.