Scenario 3-3: Manipulating Data Using SELECT and JOIN Statements You are a database administrator for the AdventureWorks Corporation. Some confusionhas arisen because the companys purchase orders are stored in two tables. Therefore,you need to write a query to join the PurchaseOrderHeader table in the sample database,AdventureWorks, to itself in order to provide a list of purchase orders paired together. Eachrow includes two purchase orders that have identical vendors and shipping methods. After opening SSMS and accessing the AdventureWorks database, what query wouldyou use against the AdventureWorks database to display the ProductSubcategoryIDand ProductCategoryID from the Production.ProductSub table that contain the wordBike? You also want to sort by Subcategory Name. What query would you use to join the ProductCategory table to the ProductSubcategorytable in order to retrieve the Name column from within the ProductCategory table?

"" I need help with this question, The answer may be right, But the way the answer is written is confusing!!