有下表: Department( Name , Building, Budget) Instructor ( ID , Name, Department, Salary) 现查找生物系教师名单,要求在结果中展示教师表的所有属性和系表的所有属性 A. select Instructor.*, Department.* from Instructor Natural Join Department; B. select Instructor.*, Department.* from Instructor AS I, Department AS D where I.Department = D.Name AND D.Name = 'Biology'; C. select I.*, D.* from Instructor AS I, Department AS D where (I.Department, D.Name) =(D.Name = 'Biology'); D. select Instructor.*, Department.* from Instructor AS I natural join Department AS D;