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
Get step-by-step solutions from verified subject matter experts
