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.9 (38 reviews)

Question

Quizplus · Accepted Answer

The query uses the GROUP BY clause to aggregate sales data for each salesperson_id, calculating the total sales per salesperson using the SUM function.

The Following Query Totals Sales for Each Salesperson