An SQL statement to display the last name of the employees who is either a department manager or works on at least one project can be

Question

Answer

None of these

Answer

select lname from employee, department where dno = dnumber union select lname from employee, works_on where essn = ssn

Answer

select lname from employee, department where mgr_ssn = ssn union select lname from employee, project

Answer

select lname from employee, department where mgr_ssn = ssn union select lname from employee, works_on where essn = ssn

Crowdly