medium
SQL Query for Top Customers
Write a SQL query to find top-spending customers.
📝 プロンプトの内容
Write a SQL query to select the top 5 customers based on total purchase amount in the last month. Assume the table name is 'orders' with columns 'customer_id', 'order_date', and 'total_amount'.