(多选题)
Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?()
ASELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
CSELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
DSELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
ESELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
FSELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
正确答案
答案解析
略