Introduction
PARTITION BY
Summary
15. Exercise 2

Instruction

This one is a bit harder...

Exercise

For each employee, show their FirstName, LastName, Department, Salary and the proportion of their salary to the sum of all salaries in that department. To avoid integer division, remember to CAST the dividend to NUMERIC. Name the last column Ratio.