Which of the following has been achieved by the following SQL codes? SELECT * FROM employees WHERE hire_date < TO_DATE ('01-JAN-1999', 'DD-MON-YYYY') AND salary > 3500; | Oracle

A. only those hired before 1999 and earning less than $3500 a month are returned
B. compile time error
C. only those hired after 1999 and earning more than $3500 a month are returned
D. runtime error
E. only those hired before 1999 and earning more than $3500 a month are returned

Ans: E