Which statement will display those employees who have a job title that contains the string 'JEF' and earn $10,000 or more?
A) SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >= 10000 AND job_id LIKE '%JEF%';
B) SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >= 10000 OR job_id LIKE '%JEF%';
C) Either statement displays the desired output.
D) Neither statement displays the desired output.
A (SELECT employee_id, last_name, job_id, salary FROM employees WHERE salary >= 10000 AND job_id LIKE '%JEF%';)
You might also like to view...
In Lync, a white presence indicator means that Lync cannot tell if the contact is online
Indicate whether the statement is true or false
Keyboard shortcuts should be assigned to a macro:
A) after the macro is created. B) before the macro is created. C) at any point in the macro creation process. D) only when it is going to be used in another document.