Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? () 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));
Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? ()
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));
相关考题：
在窗体1中有按钮Button1,以下那个Click事件处理程序可以关闭该窗体?() A. 1.Close();B.this.Close();C.Button 1.Close();D.me.Close();
After __________ (examine) the lady, the doctor suggested that his back was badly hurt in the accident.
1. 创建并访问DataFrame对象。 1) 创建3×3DataFrame数据对象：数据内容为1-9；行索引为字符a，b，c；列索引为字符串‘one’，‘two’，‘three’； 2) 查询列索引为‘two’和‘three’两列数据； 3) 查询第0行、第2行、第0列、第2列数据； 4) 筛选第1列中值大于2的所有行数据，另存为data1对象； 5) 为data1添加一列数据，列索引为‘four’，值都为10； 6) 将data1所有值大于9的数据修改为8； 7) 删除data1中第0行和第1行数据。
DataBind方法通常在哪个事件中调用？A．Page_Load事件B．Appalachian_Start事件C．Button_Click事件D．Label_Click事件