PLEASE HELP WITH THIS QUERY IN NEEDS TO MATCH THE TABLE THAT BELOW. I will also the query I got but is incorrect.

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$)$

SELECT CONCAT$($SUBSTRING$($mgr$.$emp$\_$ssn$,1,3),\text{'}-\text{'},$ SUBSTRING$($mgr$.$emp$\_$ssn$,4,2),\text{'}-\text{'},$ SUBSTRING$($mgr$.$emp$\_$ssn$,6,4))$ AS "Manager SSN$",$

CONCAT$($mgr$.$emp$\_$first$\_$name, $\text{'}\text{'},$ mgr$.$emp$\_$last$\_$name$)$ AS "Manager Name",

CONCAT$($e$.$emp$\_$dpt$\_$num, $\text{'}\text{'},$ d$.$dpt$\_$name$)$ AS Department,

CONCAT$($SUBSTRING$($e$.$emp$\_$ssn$,1,3),\text{'}-\text{'},$ SUBSTRING$($e$.$emp$\_$ssn$,4,2),\text{'}-\text{'},$ SUBSTRING$($e$.$emp$\_$ssn$,6,4))$ AS "Employee SSN$",$

CONCAT$($e$.$emp$\_$first$\_$name, $\text{'}\text{'},$ e$.$emp$\_$last$\_$name$)$ AS "Employee Name",

dpt$.$ dep$\_$name AS "Dependent Name",

dpt$.$ dep$\_$relationship AS Relationship,

DATE$\_$FORMAT$($dpt$.$dep$\_$date$\_$of$\_$birth, $\text{'}\%$M $\%$d$,\%$Y$\text{'})$ AS "Dependent DOB"

FROM employee e

JOIN department d ON e$.$emp$\_$dpt$\_$num $=$ d$.$dpt$\_$no

JOIN employee mgr ON d$.$dpt$\_$mgrssn $=$ mgr$.$emp$\_$ssn

LEFT JOIN dependent dpt ON e$.$emp$\_$ssn $=$ dpt$.$dep$\_$emp$\_$ssn

ORDER BY e$.$emp$\_$dpt$\_$num ASC, e$.$emp$\_$ssn ASC;