Which of following statements is true for retrieving the Fname, Lname and address for the employee working in the Research department? Select one: a. SELECT EMPLOYEE.Fname, EMPLOYEE.LName, EMPLOYEE.Address FROM EMPLOYEE, DEPARTMENT WHERE DEPARTMENT.Dnumber=EMPLOYEE.Dno;

b. SELECT Fname, EMPLOYEE.Name, Address FROM EMPLOYEE, DEPARTMENT WHERE DEPARTMENT.Name=Research AND DEPARTMENT.Dnumber=EMPLOYEE.Dnumber;

c. SELECT E.Fname, E.Lname, S.Fname, S.Lname FROM EMPLOYEE AS E, EMPLOYEE AS S WHERE E.Super_ssn=S.Ssn;

d. SELECT E.Fname, E.LName, E.Address FROM EMPLOYEE E, DEPARTMENT D WHERE D.DName=Research AND D.Dnumber=E.Dno;