PLEASE HELP!! THE QUERY NEEDS TO MATCH THE TABLE THAT I ADDED.

Write a query to display the manager$$s SSN$,$ manager$$s first and last name with a space between them, department number, department name, employee$$s SSN$,$ employee$$s first and last name with a space between them, and the following information about the employee's dependents: name, relationship and date of birth. The department number and name are that of the employee, not the manager. Name the columns as follows: Manager SSN$,$ Manager Name, Department, Employee SSN$,$ Employee Name, Dependent Name, Relationship and Dependent DOB. Sort the results by department number, employee SSN in all ascending order. See sample output below. $(25$ pts$)$

IMPORTANT: You need to research how to use SUBSTRING and DATE$\_$FORMAT functions.

No partial credit, if the format of your results is different than provided in the sample output.