Execute the following Microsoft SQL Server T-SQL script in Query Editor to locate all finished mountain bike parts:

USE AdventureWorks2008;

SELECT   P.[Name],

         P.ProductID,

         P.ProductNumber

FROM     Production.Product AS P

         INNER JOIN Production.ProductInventory AS I

           ON P.ProductID = I.ProductID

         INNER JOIN Production.Location AS L

           ON I.LocationID = L.LocationID

WHERE    P.ListPrice > 0

         AND L.[Name] = 'Finished Goods Storage'

ORDER BY P.[Name];

GO

/* Partial results

Name                    ProductID   ProductNumber

All-Purpose Bike Stand  879         ST-1401

AWC Logo Cap            712         CA-1098

Bike Wash - Dissolver   877         CL-9009

Cable Lock              843         LO-C100

*/