Which SOL statement would get you the desired result?

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 SOL statement would get you the desired result?

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 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 AND salary > 3000;

B.
SELECT employee_ d, 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;



Leave a Reply 1

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