Scenario Company Asked Create Queries Show Employees Department Information Result Also Co Q37110982

Scenario: The company has asked you to createqueries that can show employees and department information in thesame result. They also are concerned that there may eventually beorphan records in the database and want you to write queries thatcan detect those.

For this assignment you will be writing T-SQL statements inSSMS.

Using the knowledge you gained in the Learning TeamCollaborative Discussion this week, create andperform the following T-SQL statements:

1. Create a query using INNER JOIN that will show all rows and allcolumns from both tables. You will join the tables usingDepartmentID from the Employees table and ID from the Departmentstable.
2. Add another department to the
   OR

    

   

   OR