Please Solve this.

Not on a paper

6. Building Complex Queries with In-Line Views s salary expressed Your ultimate goal in this exercise is to create a report showing each as a percentage of the total salary for his department. The report should be sorted by department and, within each department, in descending order of salary The orion. Employee Payroll table contains Sala The orion. Employee_Addresses table c . The orion. Employee Organization Sketch of desired report: loyee Name. Department. Employee Salaries as a percent of Department Total 58.200.00 8.6% 53,475.00 7.9% 52,295.00 7.7% Accounts Mea, Azav Miller Accounts a. Create a report e sum of all salaries for each department. The report should include l. Join of all associated salary values as Dept_Salary Tota roll and orion.Employee_Organiza orion.Emp Emplo . The ofi obtain the information you need. loyee_Payroll table contains salary values. n.Employee Organization table contains department information. ROC SQL Output Dept Salary Total Accounts 397175 Acministration Concession Managenent 100985 372225 6. Building Complex Queries with In-Line Views s salary expressed Your ultimate goal in this exercise is to create a report showing each as a percentage of the total salary for his department. The report should be sorted by department and, within each department, in descending order of salary The orion. Employee Payroll table contains Sala The orion. Employee_Addresses table c . The orion. Employee Organization Sketch of desired report: loyee Name. Department. Employee Salaries as a percent of Department Total 58.200.00 8.6% 53,475.00 7.9% 52,295.00 7.7% Accounts Mea, Azav Miller Accounts a. Create a report e sum of all salaries for each department. The report should include l. Join of all associated salary values as Dept_Salary Tota roll and orion.Employee_Organiza orion.Emp Emplo . The ofi obtain the information you need. loyee_Payroll table contains salary values. n.Employee Organization table contains department information. ROC SQL Output Dept Salary Total Accounts 397175 Acministration Concession Managenent 100985 372225