Question

4. Write down the SQL to show the first name and last name for those employees satisfying one of the

following conditions (1) hire_date is after 01/01/2008 and before 12/31/2008, (2) salary is above

8000. (Hint: 43 records, and I am asking you to write one SQL for this question instead of two.)

Question image 1