Prev Question
Next Question

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;

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *