Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work? () https://assets.asklib.com/images/image2/2018080114403417445.jpg

A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id); B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id); C . SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id); D . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id); E . SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id); F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY))

时间:2022-08-29 20:39:30 所属题库:1Z0-007题库

相似题目