Assuming that the tables and columns are correct and there i…
Assuming that the tables and columns are correct and there is valid data, what is the result of the following query? SELECT sales_person_id , SUM(sales_totals) FROM sales_records WHERE sales_person_id IN ( SELECT sales_person_id FROM employee INNER JOIN departments ON employee.departmentId = departments.departmentId AND departments.deparmentName = ‘Agriculture’ ) AND sales_records.quarter = 2 GROUP BY sales_person_id;