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?

Question

User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria:

salary (SALARY) is less than $40,000.00 a year.

Which SQL statement will accomplish this?

Accepted Answer

A. SELECT * FROM employee

Answer

B. SELECT * FROM employee

Answer

C. SELECT * FROM employee

Answer

D. SELECT * FROM employee

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…