The Order table includes (among other fields) a customer ID and an amount for each item that
was ordered. An existing query returns the same number of rows as are in the table. For example,
if John ordered 10 items, you would see 10 rows with his ID in the customer ID column.
You want to determine how much each customer has ordered, so you need a query that displays
just one row for each customer ID and amount field. The value of the amount field in John row
would be the sum of the values from the 10 rows.field. The value of the amount field in John? row
would be the sum of the values from the 10 rows.
How would you calculate how much each customer has ordered?
A.
Apply the aggregate function Sum to the amount field.
B.
Add a prompt query to further refine the query when it is run.
C.
Define expressions to calculate how much each customer has ordered.
D.
Define a HAVING criterion to display how much each customer has ordered.