The following query totals sales in state= 'MA' for each salesperson.
SELECT salesperson_id, sum(sales)
FROM salesperson
GROUP BY salesperson_id
HAVING state = 'MA';

Name: The following query totals sales in state= 'MA' for each salesperson. SELECT salesperson_id, sum(sales) FROM salesperson GROUP BY salesperson_id HAVING state = 'MA';
Brand: Quizplus
Rating: 4.9 (30 reviews)

Question

Quizplus · Accepted Answer

The HAVING clause is used to filter groups based on aggregate functions, but "state = 'MA'" should be in a WHERE clause to filter rows before aggregation.

The Following Query Totals Sales in State= 'MA' for Each