Problem Statement

Create a hierarchical view showing each employee with their manager's name, department, salary difference from their manager, and their rank within their department by salary. Include department average salary for comparison.

Relevant Tables