OCP CBT Question 648

Please solve the following question.

You need to retrieve the `first_name`, `last_name`, and `job_id` for employees who work as 'IT_PROG' OR 'SA_REP' AND earn a salary greater than 8000. Which SQL statement correctly achieves this result?

sqlSELECT first_name, last_name, job_id, salaryFROM employees;

EMPLOYEES Table Sample Data

FIRST_NAME	LAST_NAME	JOB_ID	SALARY
Alexander	Hunold	IT_PROG	9000
Bruce	Ernst	IT_PROG	6000
Valli	Pataballa	IT_PROG	4800
Gerald	Johnson	SA_REP	12000
Sarah	Miller	SA_REP	7000
David	Austin	FI_MGR	15000

SELECT first_name, last_name, job_id FROM employees WHERE job_id = 'IT_PROG' OR job_id = 'SA_REP' AND salary > 8000;

SELECT first_name, last_name, job_id FROM employees WHERE (job_id = 'IT_PROG' OR job_id = 'SA_REP') AND salary > 8000;

SELECT first_name, last_name, job_id FROM employees WHERE job_id IN ('IT_PROG', 'SA_REP') OR salary > 8000;

SELECT first_name, last_name, job_id FROM employees WHERE job_id = 'IT_PROG' AND job_id = 'SA_REP' AND salary > 8000;