Which of the Following SQL Statements Would Produce a List

Multiple Choice

Which of the following SQL statements would produce a list of all employees from the Employee table that live in the Zip Code of 80112?

A) Select * From Employee Where EmployeeId = 80112.
B) Select * From Employee Where ZipCode = 80112;
C) Select * From Employee Where ZipCode = 80112 And EmployeeId Is D) Select * From ZipCode Where EmployeeId = 80112;
E) Select ZipCode From Employee Where EmployeeId = 80112;