Problems

Some emample problems we can solve with window functions.

Rank the Employees by Wage

Add a column that shows the rank of each employee by wage

Rank the Employees by Wage Per Department

The same but separate them by department

Show the Difference to the Average Salary Per Department

Get an average salary for each department and then show a column for that difference above/below the average.