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

Question

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 <Blank,
D) Select * From ZipCode Where EmployeeId = 80112;
E) Select ZipCode From Employee Where EmployeeId = 80112;

Quizplus · Accepted Answer

The correct SQL statement is B, which selects all columns from the Employee table where the ZipCode is 80112.

Which of the Following SQL Statements Would Produce a List