Question

Which operation would you use to total purchases for each individual purchase agent?

1) GROUP BY
2) WHERE
3) EQUALS
4) BETWEEN

Answer 1

The operation that would be used to total purchases for each individual purchase agent is GROUP BY.

Step-by-step explanation:

The operation that would be used to total purchases for each individual purchase agent is GROUP BY.

GROUP BY is a clause in SQL that is used to group rows based on a specified column, in this case the purchase agent. It allows for aggregating values, such as summing the purchases, for each group.

For example, if a table contains columns for purchase agent name and purchase amount, you can use the GROUP BY clause to calculate the total purchases for each individual agent.