Building Complex Queries with In-Line Views Your ultimate goal in this exercise is to create a report showing each employees salary expressed as a percentage of the total salary for that employees department. The report should be sorted by department and, within each department, in descending order of salary percentage.

The orion.employee_payroll table contains Salary.

The orion.employee_addresses table contains Employee_Name.

The orion.employee_organization table contains Department. Sketch of desired report:

Create a report aggregating the sum of all salaries for each department. The report should include Department and the sum of all associated salary values as Dept_Salary_Total. Join orion.employee_payroll and orion.employee_organization by Employee_ID to obtain the information that you need.

The orion.employee_payroll table contains salary values.

The orion.employee_organization table contains department information.