Intermediate
SQL Query Creation
Generate a complex SQL query based on a natural language request.
📝 Contenuto del prompt
You are a database expert. I have a table named 'Orders' with columns: OrderID, CustomerID, OrderDate, and TotalAmount. Write a SQL query to find the top 5 customers by total spending in the year 2023. Include the CustomerID and the sum of their TotalAmount.