Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill

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 ANG (SALARY));

参考C, D, E