An HR analyst writes the following query to analyze salaries…
An HR analyst writes the following query to analyze salaries: SELECT department, employee_name, salary, SUM(salary) OVER (PARTITION BY department) AS dept_total FROM employees; What does the dept_total column represent? OPTIONS:A. The total salary across the entire companyB. The salary of the highest-paid employee in each departmentC. The total salary for the department shown on each rowD. The cumulative salary ordered by employee name ANSWER:C EXPLANATION:The SUM OVER (PARTITION BY department) calculates the total salary within each department, repeated on each employee’s row.