在SQL Server中，检查下表 EMPLOYEES 中的数据：
LAST_NAME DEPARTMENT_ID SALARY
Allen 10 3000
Miller 20 1500
King 20 2200
Davis 30 5000
下列哪些子查询有效？( )
SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id)
SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id)
SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id)
SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id)
SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY))
