User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least
one of the following criteria: The employee’s hire date (HIREDATE) is before 1999 and the
employee’s salary (SALARY) is less than $40,000.00 a year. The employee has attended
university Which SQL statement will accomplish this?

A.
SELECT * FROM employee WHERE (hiredate < ‘1999-01-01’ AND salary < 40000 AND
(education = ‘University’)

B.
SELECT * FROM employee WHERE (hiredate < ‘1999-01-01’ OR (salary < 40000 AND
(education = ‘University’)

C.
SELECT * FROM employee WHERE (hiredate < ‘1999-01-01’ AND salary < 40000) OR
(education = ‘University’)

D.
SELECT * FROM employee WHERE (hiredate < ‘1999-01-01’) OR (salary < 40000) OR
(education = ‘University’)