EMPLOYEES表如下:
LAST_NAMEDEPARTMENT_IDSALARY
Getz103000
Davis201500
King202200
Davis305000…
请根据表判断以下哪些SQL语句正确:( )
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 AVG(salary));