<prompt> Theha potso ho khetha bareki ba sebelisang chelete e fetang 1,000 ka kakaretso selemong se fetileng.nan  <response>: Instruction in English: Construct a query to select customers who spend more than 1,000 in total in the last year. . Response in English: 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. . Response in Sesotho: Mona ke potso ea SQL e ka sebelisoang ho khetha bareki ba sebelisitseng chelete e fetang 1,000 ka kakaretso selemong se fetileng: SQL SELECT CustomerId, SUMTotalAmount AS TotalSpent FROM Orders WHERE OrderDate PAKENG TSA DATEADDselemo,-1, GETDATE LE GETDATE GROUP KA CustomerId HAVING SUMTotalAmount 1000 Potso ena e khetha CustomerId le kakaretso ea TotalAmount bakeng sa moreki e mong le e mong ho tsoa tafoleng ea Orders. Temana ea WHERE e sefa liphetho ho bontša feela liodara tse behiloeng selemong se fetileng. Karoloana ea GROUP BY e arola diphetho ka CustomerId mme HAVING e sefa dihlopha ho bontsha feela moo kakaretso ya tjhelete e sebediswang ke moreki e fetang 1,000. Sephetho sa ho qetela ke lenane la bareki ba sebelisitseng chelete e fetang 1,000 ka kakaretso selemong se fetileng. 