Using the below tables in the stated database create a query that JOINS the aforementioned tables and produces the expected result set. Note: Your query must be well formatted and runnable for credit. i.e.. It can be pasted into SSMS and executed producing the expected results. Paste your well formatted query below for credit. • Database • Northwind Tables • [dbo].[Employees] • [dbo].[EmployeeTerritories] • [dbo].[Territories] • Result Set • FullName · Note: this will be a concatenation of LastName, FirstName • Address • PostalCode TerritoryDescription

A pre-compiled stored procedure is a logical unit made up of one/more SQL statements (SQL stands for Structured Query Language). The database server saves it as an object. An SQL procedure is a collection of SQL statements and logic that is written and s…