The following query totals sales for each salesperson.
Select salesperson_id, sum(sales)
from salesperson
group by salesperson_id;

Name: The following query totals sales for each salesperson. Select salesperson_id, sum(sales) from salesperson group by salesperson_id;
Brand: Quizplus
Rating: 4.7 (40 reviews)

Question

Quizplus · Accepted Answer

The query uses the aggregate function SUM to calculate the total sales for each salesperson, and then groups the results by salesperson_id using the GROUP BY clause. Therefore, the query returns the total sales for each salesperson.

The Following Query Totals Sales for Each Salesperson