itgle.com
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 GROU
题目
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));
相似考题
参考答案和解析
更多“Examine the data in the EMPLOYEES table:Which three subqueries work? () ”相关问题
-
第1题：
检查
A.expect
B.except
C.excuse
D.examine
正确答案：D
-
第2题：
Nothing in these Rules shall ______ any vessel，or the owner，master or crew thereof，from the consequences of any precaution which may be required by the ordinary practice of seaman，or by the special circumstances of the case．
A.exonerate
B.exhaust
C.exercise
D.examine
正确答案：A
-
第3题：
He rolled up his trouer leg to exhibit his wounded knee.A:spread
B:open
C:show
D:examine答案：C解析：本句意思：他卷起他的裤腿来显露受伤的膝盖。exhibit展示，显示。spread伸开，展开；open打开；show展示，出示；examine检查。 -
第4题：
Despite the wonderful acting and well-developed plot the _________ movie could not hold our attention.
A) three-hours B) three-hour
C) three-hours’ D) three-hour’s
选B
用破折号连接的作形容词不用复数. -
第5题：
Most operating systems have a standard set of ( ) to handle the processing of all input and output instructions.A.spreadsheet
B.control instructions
C. I/O operation
D.datA.table答案：B解析：翻译：
大多数操作系统都有一套标准的（71）处理所有的输入和输出指令。
A. 电子表格 B. 控制指令
C. I/O操作 D. 数据表 -
第6题：
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行数据。
t;>>data=[[4,5,6], [4,5,6], [4,5,6]];t;>>df=pd.DataFrame(data,columns=list(‘ABC’));以将df中值为5的数据修改为10的语句是：};df[df.values==5]=10