undefined

Examine the data in the EMPLOYEE relation below: 100 EMPLOYEE Name Deptid Salary John Doe 42000 Jane Doe 200 35000 Ryan Doe 300 65000 Mary Doe 200 67000 Which of the following subqueries will execute properly without errors? (choose two) SELECT distinct (DeptID) FROM Employee WHERE Salary > ANY (SELECT AVG(Salary) FROM Employee GROUP BY DeptID); SELECT DeptID FROM Employee WHERE Salary > ALL (SELECT AVG(Salary) FROM employees GROUP BY AVG(SALARY) ); SELECT * FROM Employee WHERE Salary - (SELECT AVG(Salary) FROM Employee GROUP BY Deptid); SELECT FROM EMPLOYEE WHERE Salary > (SELECT MIN(Salary) FROM Employee GROUP BY DeptID); SELECT DeptID FROM Employee WHERE Salary > ALL (SELECT AVG(Salary) FROM Employee GROUP BY Deptid)