<prompt> Kutokana na meza ya maagizo ya wateja na nguzo OrderID, CustomerID, OrderDate, na OrderAmount, kuandika SQL query kupata jumla ya jumla ya amri ya kila mteja, ilipangwa na mteja na tarehe ya amri.  <response>: Heres an example SQL query that should accomplish this task:SELECT CustomerID, OrderDate, OrderAmount, SUMOrderAmount OVER PARTITION BY CustomerID ORDER BY OrderDate AS RunningTotalFROM OrdersORDER BY CustomerID, OrderDate ASCThis query uses the window function SUM with OVER to calculate the running total for each customer, partitioning by the CustomerID column and ordering by the OrderDate column. The resulting table will include columns for CustomerID, OrderDate, OrderAmount, and RunningTotal, sorted by customer and order date. 