SQL Assignment 3 . For each employee having a dependent, retrieve the . For each department, list its name along with the names For each department, lists its name, manager's name, employee's name along with his/her dependent name(s). of projects the department controls. and the names of projects it controls. For each employee, list his/her first name, last name and his/her department manager's name For the department that controls more projects than any other department, retrieve its department number. Find the name of employee who supervises more employees than any other supervisor. . 42 SQL Assignment 3 . For each employee having a dependent, retrieve the . For each department, list its name along with the names For each department, lists its name, manager's name, employee's name along with his/her dependent name(s). of projects the department controls. and the names of projects it controls. For each employee, list his/her first name, last name and his/her department manager's name For the department that controls more projects than any other department, retrieve its department number. Find the name of employee who supervises more employees than any other supervisor. . 42