hard
SQL Query Generator
Write a SQL query based on requirements.
📝 Contenuto del prompt
Write a SQL query to select the top 10 customers with the highest total order amount from a table named 'orders'. Assume the table has columns 'customer_id', 'order_amount', and 'order_date'.