CPA · Question 26 · Area I: Information Systems
Review the following SQL query:<br/>SELECT CustomerID, SUM(OrderAmount)<br/>FROM Orders<br/>GROUP BY CustomerID<br/>HAVING SUM(OrderAmount) > 10000;<br/><br/>What is the purpose of this query?
Answer options:
To list all individual orders greater than 10,000.
To identify customers whose total order value exceeds 10,000.
To count the number of orders per customer.
To delete orders greater than 10,000.
82 questions · hints · full answers · grading
Expert