Execute the following Microsoft SQL Server T-SQL script in Management Studio Query Editor to generate an inventory summary by JOINing 4 tables using Primary Keys and Foreign Keys. The CostOfInventory is currency formatted by applying the CONVERT function with parameter "1" to money data type argument. The INNER JOINs are on Foreign Keys and Primary Keys.

USE AdventureWorks;

GO

SELECT

      PSC.Name                AS Subcategory,

      P.Name                  AS ProductName,

      L.Name                  AS InventoryLocation,

    SUM(I.Quantity)           AS QuantityAvailable,

    '$'+convert(varchar,AVG(P.StandardCost)

     * SUM(I.Quantity),1)     AS CostOfInventory

FROM Production.ProductSubcategory PSC

     JOIN Production.Product AS P

      ON P.ProductSubcategoryID = PSC.ProductSubcategoryID

     JOIN Production.ProductInventory AS I

      ON P.ProductID = I.ProductID

     JOIN Production.Location AS L

      ON I.LocationID = L.LocationID

GROUP BY PSC.Name, P.Name, L.Name

ORDER BY Subcategory, ProductName ;

GO