View the Exhibit and examine the description of the EMPLOYEES table. You want to know
the EMPLOYEE_ID and FIRST_NAME of all the records in the EMPLOYEES table wherein
the JOBJD column has ST_CLERK or ST_MAN values, the DEPARTMENT_ID column has
value 30, and the SALARY column has a value greater than 3,000. Which SOL statement
would get you the desired result?
A.
SELECT employee_id, first_name FROM employees WHERE job_id like ‘%MAN’ OR
job_id like ‘%CLERK’ AND (department_id = 30 OR salary > 3000);
B.
SELECT employee_id, first_name FROM employees WHERE (job_id like ‘%MAN’ AND
job_id like ^CLERK”) AND department_id = 30 OR salary > 3000;
C.
SELECT employee_id, first_name FROM employees WHERE (job_id like ‘%MAN’ OR
job_id like ‘%CLERK’) AND department_id = 30 AND salary > 3000;
D.
SELECT employee_id, first_name FROM employees WHERE job_id like ‘MAN%’ OR
job_id like ‘CLERK%’ AND department_id = 30 AND salary > 3000;
Explanation: