1-Which of the following SQl statement would produce a list of all employees from the employee table that live in the zip code of 80127

A.Select employee.EmpName from employee where employee.employeeId= 80127

B.Select employee.EmpName from employee where employee.employeeId= 80127

And employee employeeId<>blank

C.Select employee.EmpName from zipcode where employee.employeeId="80112"

D.Select Zipcode from employee where employee.employeeId=80112