Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.<br /> You need to find the percentage tax applicable for each employee. Which SQL statement would you use?()<img src="https://nimg.ppkao.com/2018-08/zhangxu/2018080114273930960.jpg?sign=28c0d93da8877bf68448e069f3452b52&t=62d33b65" />
A、SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;
B、SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;
C、SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (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.