Question: 11. Write an SQL to list each department number, department name, and department managers name. Sort the list by department number. 12. Write an SQL

11. Write an SQL to list each department number, department name, and department managers name. Sort the list by department number.

12. Write an SQL query that will list the employees first name, department managers SSN, department managers start date for any employees whose children were born after the employees department managers start date. The query result set should also show the dependents name, and the dependents date of birth.

13. Write an SQL statement that will display the first name of all employees who have a dependent. If an employee has more than one dependent, they should only be displayed once.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!