Using AdventureWorks2012

P-5C3MBPH\...2012 - Diagram_0% Wardrop RyanAssig...MBPH\RWard (65))* Assignment06.sql - not connected + X -3. a. List Products, their subcategories and their categories. Show the category name, subcategory name, product ID, and product name, in this order. Sort in alphabetical order on category name, then subcategory name, and then by product name. (1 points) 295 Rows Hint: To understand the relationshships, refer to your database diagram and the following tables: Production.Product Production.ProductSubCategory Production. ProductCategory Connect L. Production Product Columns ProductID (PK, int, not null) Name (Name(nvarchar(50)), r E ProductNumber (nvarchar(25 E MakeFlag (Flag(bit), not null) FinishedGoodsFlag (Flag(bit), E Color (nvarchar(15), null) SafetyStockLevel (smallint, no ReorderPoint (smallint, not nu StandardCost (money, not nu ListPrice (money, not null) Size (nvarchar(5), null) - SizeUnitMeasureCode (FK, nel - WeightUnitMeasureCode (FK, Weight (decimal(8,2), null) DaysToManufacture (int, not i ProductLine (nchar(2), null) Class (nchar(2), null) Style (nchar(2), null) 6- ProductSubcategory|D (FK, in e ProductModellD (FK, int, null E SellStartDate (datetime, not nu SellEndDate (datetime, null) E DiscontinuedDate (datetime, 1 rowguid (uniqueidentifier, no E ModifiedDate (datetime, not i Keys Constraints Columns e ProductCategory|D (PK, int, n Name (Name(nvarchar(50)), r rowguid (uniqueidentifier, no ModifiedDate (datetime, not 1 Keys Constraints + + Triggers Indexes Statistics Production.ProductCost History Production.ProductDescription Production.ProductDocument Production.ProductInventory Production ProductListPrice History Production.Product Model Production.ProductModellllustration Production.Product ModelProductDe Production.ProductPhoto Production.Product ProductPhoto Production.ProductReview Production.ProductSubcategory Production.ScrapReason Production. Transaction History 1 Production Transaction History Archiv Production.UnitMeasure Production.ProductDescription EB Production.ProductDocument 0 Production.ProductInventory n Production.ProductListPrice History Production.ProductModel Columns o Product ModellD (PK, int, not Name (Name(nvarchar(50)), r CatalogDescription (XML(Pro Instructions (XML(Production rowguid (uniqueidentifier, no B ModifiedDate (datetime, not 1 Keys Constraints Triggers Indexes Statistics Production.ProductModellllustration Production.ProductModelProductDe A Production.ProductPhoto 88 Production.ProductProductPhoto Production Product Review Production ProductSubcategory B Production scrapReason Production Transaction History Production Transaction History Archiv Production.Product Modellllustration Production.ProductModelProductDe E Production.ProductPhoto Production.ProductProductPhoto E Production.ProductReview 3 Production. ProductSubcategory Columns me ProductSubcategoryD (PK, in 6- Product Category|D (FK, int, n Name (Name(nvarchar(50)), r Browguid (uniqueidentifier, no ModifiedDate (datetime, not i Keys Constraints Triggers Indexes Statistics + 2 Production.ScrapReason E Production Transaction History EEE Production. Transaction History Archiv Production UnitMeasure 5 Production.ProductListPrice History Production.Product Model Production.ProductModellllustration Production.Product ModelProductDe Production.ProductPhoto E Production.ProductProductPhoto Production.ProductReview Columns 0 ProductReviewID (PK, int, not - ProductID (FK, int, not null) ReviewerName (Name(nvarch ReviewDate (datetime, not nu Email Address (nvarchar(50), n Rating (int, not null) Comments (nvarchar(3850), n ModifiedDate (datetime, not : Keys Constraints Triggers Indexes Statistics E Production Productsubcategory Columns Production.Location Production. Product Columns ProductID (PK, int, not null) E Name (Name(nvarchar(50)), r ProductNumber (nvarchar(25) MakeFlag (Flag(bit), not null) FinishedGoodsFlag (Flag(bit), E Color (nvarchar(15), null) SafetyStockLevel (smallint, no ReorderPoint (smallint, not nu StandardCost (money, not nu ListPrice (money, not null) Size (nvarchar(5), null) - SizeUnitMeasureCode (FK, nel - WeightUnitMeasureCode (FK, & Weight (decimal(8,2), null) E DaysToManufacture (int, not i E ProductLine (nchar(2), null) E Class (nchar(2), null) E Style (nchar(2), null) C- ProductSubcategory|D (FK, in 6- ProductModellD (FK, int, null) E SellStartDate (datetime, not ni SellEndDate (datetime, null) DiscontinuedDate (datetime, 1 Browguid (uniqueidentifier, no ModifiedDate (datetime, not i Keys 100 10 1 NEM Di are to search ILIH + Production.ProductPhoto Production.ProductProductPhoto Production.ProductReview Production.ProductSubcategory IT Columns ro ProductSubcategory|D (PK, in - ProductCategoryD (FK, int, ni Name (Name(nvarchar(50)), r rowguid (uniqueidentifier, no ModifiedDate (datetime, not: Keys Constraints Triggers Indexes Statistics Production.ScrapReason 7 Production. Transaction History 2 Be Production. Transaction HistoryArchiv v e Production Product Production.ProductCategory Columns ProductCategoryID (PK, int, n E Name (Name(nvarchar(50)), r Browguid (uniqueidentifier, no ModifiedDate (datetime, notr Keys Constraints Triggers Indees Statistics Production.ProductCost History E Production Product Description Production ProductDocument Production.ProductInventory Production.ProductListPrice History E Production.Product Model Production Product Modellllustration Production Product ModelProductDe BE Production ProductPhoto EE Production ProductProductPhoto m Production ProductReview Production ProductSubcategory HO Production.ScrapReason O Production. Transaction History