Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
PARTITION BY
Summary
15. Exercise 2

Instruction

Question number two – the last one!

Exercise

For each employee, show their first_name, last_name, department, salary and the proportion of their salary to the sum of all salaries in that department. To avoid the integer division remember to cast the dividend to numeric.

Code editor
tableconsole