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_ d, 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;



Leave a Reply 0

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