1z0-071 Exam - Question 63

To return all rows for employees whose salary is greater than the average salary in their department, we need to compare each employee's salary to the average salary of their respective department. The correct query options here would be using subqueries or analytic functions to achieve this. The correct answers are B and E. B uses a correlated subquery, which calculates the average salary for each department and compares it with the current employee's salary. E uses a window function to calculate the average salary for each department and then filters results based on the comparison. Both methods are valid and correctly solve the problem. Therefore, the correct answers are B and E.