EMPLOYEEWrite SQL queries to answer the following questions:

Retrieve the name and manager's SSN of each department.

Retrieve the names of employees whose supervisor's SSN is $333445555$;

Retrieve the last name and address of female employees who work for department $5.$

Retrieve the average salary, minimum salary of employees in department $5.$

For each employee who have dependents, list his$/$her SSN and the number of

dependents he$/$she has.

Retrieve the first names and last names of employees whose last names start with $\text{'}J\text{'}.$

Retrieve the project number of each project along with the number of employees

working on it$.$

For each employee with more than one dependent, list his$/$her name and the total

number of dependents he$/$she has.

Retrieve the number of distinct employees that have dependents.

Retrieve the names of employees who work on the project with pno$=30.$

$($extra credit$)$ For each department with at least two locations, retrieve the department

number along with its locations.

DEPARTMENT

DEPT$\_$LOCATIONSWORKS$\_$ON

$\backslash$table$[[$Essn$,$Pno,Hours$],[123456789,1,32\mathrm{.}5],[123456789,2,7\mathrm{.}5],[666884444,3,40\mathrm{.}0],[453453453,1,20\mathrm{.}0],[453453453,2,20\mathrm{.}0],[333445555,2,10\mathrm{.}0],[333445555,3,10\mathrm{.}0],[333445555,10,10\mathrm{.}0],[333445555,20,10\mathrm{.}0],[999887777,30,30\mathrm{.}0],[999887777,10,10\mathrm{.}0],[987987987,10,35\mathrm{.}0],[987987987,30,5\mathrm{.}0],[987654321,30,20\mathrm{.}0],[987654321,20,15\mathrm{.}0],[888665555,20,$NULL$]]$

PROJECT

$\backslash$table$[[$Pname$,$Pnumber,Plocation,Dnum$],[$ProductX$,1,$Bellaire,$5],[$ProductY$,2,$Sugarland,$5],[$ProductZ$,3,$Houston,$5],[$Computerization$,10,$Stafford,$4],[$Reorganization$,20,$Houston,$1],[$Newbenefits$,30,$Stafford,$4]]$

DEPENDENT

$\backslash$table$[[$Essn$,$Dependent$\_$name,Sex,Bdate,Relationship$],[333445555,$Alice,F$,1986-04-05,$Daughter$],[333445555,$Theodore,M$,1983-10-25,$Son$],[333445555,$Joy,F$,1958-05-03,$Spouse$],[987654321,$Abner,M$,1942-02-28,$Spouse$],[123456789,$Michael,M$,1988-01-04,$Son$],[123456789,$Alice,F$,1988-12-30,$Daughter$],[123456789,$Elizabeth,F$,1967-05-05,$Spouse$]]$