An SQL statement to display the first name and the last name of the employees who work on more than three projects can be

Question

Answer

select fname, lname from employee, works_on group by fname, lname having count(*) > 3

Answer

None of these

Answer

select fname, lname from employee, works_on where essn = ssn group by fname, lname where count(*) >= 3

Answer

select fname, lname from employee, works_on where essn = ssn group by fname, lname having count(*) > 3

Crowdly