<prompt> Kuandika SQL query kurudi amri ya karibuni kuwekwa na kila mteja.  <response>: Assuming you have an Orders table with the columns OrderID, CustomerID, OrderDate, and OrderTotal, the following query will return the most recent order placed by each customer:SELECT o1.CustomerID, o1.OrderID, o1.OrderDate, o1.OrderTotalFROM Orders o1WHERE o1.OrderDate SELECT MAXo2.OrderDate FROM Orders o2 WHERE o1.CustomerID o2.CustomerIDORDER BY o1.CustomerID;This query selects the CustomerID, OrderID, OrderDate, and OrderTotal columns from the Orders table where the OrderDate is equal to the maximum OrderDate for that specific customer, effectively returning the latest order placed by each customer. The results are ordered by CustomerID. 