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