I need help writing a SAS proc sql query to achieve the problem below please. The desired output is show below for reference to what is needed for the query.

Building Complex Queries with In-Line Views Your ultimate goal in this exercise is to create a report showing each employee's salary expressed as a percentage of the total salary for that employee's 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: a. 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. Partial PROC SQL Output