You manage a retail database that includes Customers, Orders, and OrderDetails tables.
Question: Find the top 5 customers who have spent the most on orders in the last year.
Details
Columns:
Customers: CustomerID, CustomerName
Orders: OrderID, CustomerID, OrderDate
OrderDetails: OrderID, ProductID, Quantity, Price