<prompt> Kutokana na meza ya maagizo ya wateja na nguzo OrderID, CustomerID, OrderDate, na OrderAmount, kuandika taarifa UPDATE kuweka kiasi agizo kwa 0 kwa maagizo yote ambayo yaliwekwa zaidi ya miezi 6 iliyopita na alikuwa na kiasi agizo ya chini ya 100.  <response>: Here is the UPDATE statement you can use:UPDATE customer_ordersSET OrderAmount 0WHERE OrderDate DATEADDmonth, -6, GETDATE AND OrderAmount 100;This statement will update the OrderAmount column to 0 for all customer orders that were placed more than 6 months ago and had an OrderAmount of less than 100. The DATEADD function is used to subtract 6 months from the current date, and the WHERE clause filters the results to only include orders that match the conditions. 