<prompt> Kutokana na meza ya shughuli mteja na safu CustomerID, TransactionID, na TransactionAmount, kuandika SQL query kupata idadi ya jumla ya wateja ambao wamefanya shughuli jumla ya zaidi ya 1000.  <response>: Here is a SQL query that will find the total number of customers who have made transactions totaling over 1000:SELECT COUNTDISTINCT CustomerID FROM transactionsWHERE CustomerID IN SELECT CustomerID FROM transactions GROUP BY CustomerID HAVING SUMTransactionAmount 1000;Explanation: The inner query finds all the customers whose transaction amounts total over 1000 by grouping the transactions by customer ID and using the SUM function to add up the total transaction amount for each customer. The outer query counts the number of unique customers whose IDs appear in the results of the inner query. 