An SQL statement to display the first name and the last name of department managers who belongs to Administration department can be

Question

Answer

None of these

Answer

select fname, lname from department, employee where mgr_ssn = ssn and dname = 'Administration'

Answer

select fname, lname from department, employee where mgr_ssn = ssn and dno = (select dnumber from department where dname = 'Administration')

Answer

select fname, lname from department, employee where dno = dnumber and dno = (select dnumber from department where dname = 'Administration')

Crowdly