<prompt> Jenga swali ili uchague wateja ambao wametumia zaidi ya dola 1,000 kwa jumla katika mwaka uliopita.  <response>: Here is a SQL query that can be used to select customers who have spent more than 1,000 in total in the last year:SQLSELECT CustomerId, SUMTotalAmount AS TotalSpentFROM Orders WHERE OrderDate BETWEEN DATEADDyear,-1,GETDATE AND GETDATEGROUP BY CustomerIdHAVING SUMTotalAmount 1000This query selects the CustomerId and the sum of the TotalAmount for each customer from the Orders table. The WHERE clause filters the results to show only orders that were placed within the last year. The GROUP BY clause groups the results by CustomerId and the HAVING clause filters the groups to show only those where the total amount spent by the customer is greater than 1,000. The final result is a list of customers who have spent more than 1,000 in total in the last year. 