Introduction
PARTITION BY
Revision
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.

Console

Code editor

Result

TableConsole