智慧职教: 在雇员管理数据库gygl下创建部门表department，包含deptid（部门编号）和deptname（部门名称）两个字段，并设置deptid为主键。USE gygl;CREATE TABLE department( deptid INT , deptname VARCHAR(20));

Giventhefollowingtabledefinitions: EMPLOYEE IDNAMEDEPTID 01Smith10 02Bossy20 0320 Peterson 04Goss30 05Pape40 06Avery50 07O'Neal60 08Carter50 DEPARTMENTIDDEPTNAME 05Hardware10Kitchen20Shoes30Toys40Electronics50Automotiveandthefollowingquery:SELECTe.id,d.deptnameFROMemployeee,departmentdWHEREe.deptid=d.idANDe.id>4 Whichofthefollowingquerieswillproducethesameresultsetasthequeryabove?（） A: SELECTe.id,d.deptnameFROMemployeee,departmentdWHEREe.id>4 B: SELECTe.id,d.deptnameFROMemployeeeINNERJOINdepartmentdONe.deptid=d.idWHEREe.id>4 C: SELECTe.id,d.deptnameFROMemployeeeFULLOUTERJOINdepartmentdONe.id=d.idWHEREe.id>4 D: SELECTe.id,d.deptnameFROMemployeeeLEFTOUTERJOINdepartmentdONe.deptid=d.idWHEREe.id>4UNIONALLSELECTe.id,d.deptnameFROMemployeeeRIGHTOUTERJOINdepartmentdONe.deptid=d.idWHEREe.id>4