试题详情
- 单项选择题 Examine the structures of the EMPLOYEES and TAX tables.
You 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.
关注下方微信公众号，在线模考后查看
热门试题
- Which two statements
- The ORDERS table ha
- What is necessary fo
- Which two statements
- Evaluate the SQL sta
- ClicktheExhibitbutto
- Which statement expl
- Examine the structu
- The EMP table conta
- Which four statement
- Examine the structu
- Which two statements
- What is true of usin
- What does the FORCE
- Which statement crea
- Evaluate this SQL s
- Examine the data fr
- What is true about j
- Which two statements
- TheORDERStablehasthe