An SQL statement to display the project name and the first name and last name of the employees who work on the project can be

Question

Answer

select pname, fname, lname from employee join works_on on essn = ssn join project on pno = pnumber

Answer

None of these

Answer

select pname, fname, lname from employee, works_on on essn = ssn join project on pno = pnumber

Answer

select pname, fname, lname from employee join works_on join project on pno = pnumber and essn = ssn

Crowdly