Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00
from a table named EMPLOYEE?

A.
SELECT * FROM employee
WHERE salary < 100000

B.
SELECT salary FROM employee
WHERE salary > 100000

C.
SELECT salary FROM employee
WHERE salary > 100,000.00

D.
SELECT * FROM employee
WHERE salary GREATER THAN 100000

Explanation: