An SQL statement to display the first name and the last name of the employees who work on projects for a total of more than 30 hours can be

Question

Answer

None of these

Answer

select fname, lname from employee, works_on group by fname, lname where sum(hours) > 30

Answer

select fname, lname from employee join works_on on essn = ssn group by lname having sum(hours) > 30

Answer

select fname, lname from employee, works_on where essn = ssn group by fname, lname having sum(hours) > 30

Crowdly