Examine the structures of the EMPLOYEES and TAX tables.EMPLOYEESEMPLOYEE_ID NUMBER NOT NULL, PrimaryKeyEMP_NAME VARCHAR2 (30)JOB_ID VARCHAR2 (20)SALARY NUMBERReferencesMGR_ID NUMBEREMPLOYEE_IDcolumnDEPARTMENT_ID NUMBER Foreign key toDEPARTMENT _IDcolumn of theDEPARTMENT tableTAXMIN_SALARY NUMBERMAX_SALARY NUMBERTAX_PERCENT NUMBERPercentage tax for givensalary rangeYou need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）A. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salaryB. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary t.min_salary, tax_percentC. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salaryD. You cannot find the information because there is no common column between the two tables.

Examine the structures of the EMPLOYEES and TAX tables.EMPLOYEESEMPLOYEE_ID NUMBER NOT NULL, PrimaryKeyEMP_NAME VARCHAR2 (30)JOB_ID VARCHAR2 (20)SALARY NUMBERReferencesMGR_ID NUMBEREMPLOYEE_IDcolumnDEPARTMENT_ID NUMBER Foreign key toDEPARTMENT _IDcolumn of theDEPARTMENT tableTAXMIN_SALARY NUMBERMAX_SALARY NUMBERTAX_PERCENT NUMBERPercentage tax for givensalary rangeYou need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）

A. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary

B. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent

C. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary

D. You cannot find the information because there is no common column between the two tables.

相关考题：

We will do our best to ( ) shipment to meet your requirements in time. A.expectB.expediteC.exerciseD.examine
查看答案
I think the door is locked. But I'll go and (). A、checkB、examine
查看答案
As used in this passage, "structures" means ______.A. enduranceB. organizationC. necessary partsD. energy
查看答案
After __________ (examine) the lady, the doctor suggested that his back was badly hurt in the accident.
查看答案
检查A.expectB.exceptC.excuseD.examine
查看答案
He rolled up his trouer leg to exhibit his wounded knee.A:spread B:openC:showD:examine
查看答案
EBSCO中，检索式 tax N5 reform意味着（）。A．tax 和 reform必须同时出现，且中间不得超过5个单词的距离。B．tax 和 reform必须同时出现，中间不得超过5个单词的距离，且必须tax在前，reform在后。C．tax 和 reform必须同时出现，中间不得超过5个单词的距离，且必须reform在前，tax在后。D．tax 和 reform必须同时出现。
查看答案
EBSCO中，检索式 tax W5 reform意味着（）。A．tax 和 reform必须同时出现，且中间不得超过5个单词的距离。B．tax 和 reform必须同时出现，中间不得超过5个单词的距离，且必须tax在前，reform在后。C．tax 和 reform必须同时出现，中间不得超过5个单词的距离，且必须reform在前，tax在后。D．tax 和 reform必须同时出现。
查看答案
2、EBSCO中，检索式 tax W5 reform意味着（）。A．tax 和 reform必须同时出现，且中间不得超过5个单词的距离。B．tax 和 reform必须同时出现，中间不得超过5个单词的距离，且必须tax在前，reform在后。C．tax 和 reform必须同时出现，中间不得超过5个单词的距离，且必须reform在前，tax在后。D．tax 和 reform必须同时出现。
查看答案
1、EBSCO中，检索式 tax N5 reform意味着（）。A．tax 和 reform必须同时出现，且中间不得超过5个单词的距离。B．tax 和 reform必须同时出现，中间不得超过5个单词的距离，且必须tax在前，reform在后。C．tax 和 reform必须同时出现，中间不得超过5个单词的距离，且必须reform在前，tax在后。D．tax 和 reform必须同时出现。
查看答案
热门标签