Create a report that includes the employee ID, name, and department. Join orion.employee_addresses and orion.employee_organization by Employee_ID to obtain the information that you need.

The orion.employee_addresses table contains Employee_Name and Employee_ID. Module 2 - Lesson 2 SQL Subqueries 6

The orion.employee_organization table contains Employee_ID and Department.

Use the two queries that you created in a and b as in-line views. Join the views with orion.employee_payroll by either Employee_ID or Department to create the final report.

The query from step a contains Department and Dept_Salary_Total.

The query from step b contains Employee_ID, Employee_Name, and Department.

The orion.employee_payroll table contains Employee_ID and individual Salary values.