Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries

10. For those departments which have average salary greater than $50,000, show the department number (dno), the number of employees working for those departments and the average salary for the respective department.

11. Show all information about those employees who have dependents. ( no duplicate rows duplicate rows will get 0 points !)

12. Show each employee's first name, last name and his/her manager's first name and last name.

APPENDIX

DEPENIDANT \begin{tabular}{ccccc} ESSN & DEPENDENT NAME & SEX & BDATE & RELATIONSHIP \\ \cline { 2 - 5 } 333445555 & Alice & F & 4/5/1986 & Daughter \\ 333445555 & Theodore & M & 10/25/1983 & Son \\ 333445555 & Joy & F & 5/3/1958 & Spouse \\ 987654321 & Abner & M & 2/28/1942 & Spouse \\ 123456789 & Michael & M & 1/4/1988 & Son \\ 123456789 & Alice & F & 2/12/1988 & Daughter \\ 123456789 & Elizabeth & F & 6/5/1967 & Spouse \end{tabular} EMPLOYEE DEPARTMENT