An SQL statement to display the date of birth and the first name and the last name of the employee(s) with more than two dependents can be

Question

Answer

select bdate, fname, lname from employee join dependent on essn = ssn group by bdate, lname, fname having count(*) > 2

Answer

None of these

Answer

select bdate, fname, lname from employee join dependent on essn = ssn group by bdate, fname, lname having count(*) > 2

Answer

select e.bdate, fname, lname from employee e join dependent on essn = ssn group by e.bdate, fname, lname having count(*) > 2

Crowdly