<prompt> Kutokana na meza ya maagizo ya wateja na nguzo OrderID, CustomerID, OrderDate, na OrderAmount, kuandika taarifa DELETE kuondoa maagizo yote yaliyowekwa na wateja ambao hawajaweka amri katika mwaka uliopita.  <response>: Assuming the customers last order date is available in a separate table called Customers with columns CustomerID and LastOrderDate, you can use the following DELETE statement to remove all orders placed by customers who have not placed an order in the past year:DELETE FROM CustomerOrdersWHERE CustomerID NOT IN SELECT CustomerID FROM Customers WHERE LastOrderDate DATEADDyear, -1, GETDATEThis query uses a subquery to select all customers who have placed an order in the past year, and then deletes all orders where the CustomerID is not in that list of customers. 