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 JOB_ID 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 SQL 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 AND salary > 3000;
B.
SELECT employee_id, first_name
FROM employees
WHERE job_id like ‘%MAN’ OR job_id like ‘%CLERK’
AND (department_id = 30 OR salary > 3000);
C.
SELECT employee_id, first_name
FROM employees
WHERE (job_id like ‘%MAN’ AND job_id like ‘%CLERK’) AND department_id = 30 OR 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;