A$.$ For each department whose average employee salary is more than $$40,000,$ retrieve the department name, department manager name and the number of employees working for that department. $(4$ points$)$ B$.$ Determine the number of male employees in each department making more than $$40,000,$ rather than all employees $($as in A$).(4$ points$)$

In SQL$,$ specify the following queries on the Company database using the concept of nested queries.

C$.$ Retrieve the names of all employees who work in the department that has the employee with the highest salary among all employees. $(4$ points$)$

D$.$ Retrieve the names of all employees whose supervisor$$s supervisor has $888665555$ for Ssn$.(4$ points$)$ E$.$ Retrieve the names of employees who make at least $$10,000$ more than the average employee salary. $(4$ points$)$