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?

The correct answer is A. SELECT employee_id, salary, tax_percent. You can find the percentage tax applicable for each employee by using SQL statement in answer Incorrect Answers B: Syntax "WHERE E.salary > t.min_salary, tax_percent" is incorrect. C: Functions, like MIN() and MAX(), cannot be used in the WHERE clause. D: The SQL statement from…

Displaying Data from Multiple Tables and Subqueries

Question

Exhibit

Options

ASELECT employee_id, salary, tax_percent
BSELECT employee_id, salary, tax_percent
CSELECT employee_id, salary, tax_percent
DYou cannot find the information because there is no common column between the two tables.

How the community answered

(30 responses)

A
80% (24)
B
7% (2)
C
10% (3)
D
3% (1)

Explanation

You can find the percentage tax applicable for each employee by using SQL statement in answer Incorrect Answers B: Syntax "WHERE E.salary > t.min_salary, tax_percent" is incorrect. C: Functions, like MIN() and MAX(), cannot be used in the WHERE clause. D: The SQL statement from the answer A will provide requested information.

Topics

#equijoin#multiple tables#JOIN syntax#non-key join

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice