As the Database Administrator of AdventureWorks, some confusion has arisen because the company's 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. Each row includes two purchase orders that have identical vendors and shipping methods 1. After opening SSMS and accessing the AdventureWorks database, what query would you use against the AdventureWorks database to display the ProductSubcategorylD and the ProductCategorylD from the Production.ProductSub table that contain the word "moon. You also want to sort by category name 2. What query would you use to join the ProductCategory table to the ProductSubcategory table in order to retrieve the Name column from within the ProductCategory table? STEP 4 As the database administrator of the AdventureWorks Corporation, you recently created some databases, and you have just realized how large the databases will become in the future. Therefore, you need to create a new clustered index to help with overall performance. Using the SSMS interface, what steps will you use to create a new clustered index on the name column for the AdventureWorks database? 4 Be sure to take snapshots of your steps as you create the clustered index. This is what As the Database Administrator of AdventureWorks, some confusion has arisen because the company's 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. Each row includes two purchase orders that have identical vendors and shipping methods 1. After opening SSMS and accessing the AdventureWorks database, what query would you use against the AdventureWorks database to display the ProductSubcategorylD and the ProductCategorylD from the Production.ProductSub table that contain the word "moon. You also want to sort by category name 2. What query would you use to join the ProductCategory table to the ProductSubcategory table in order to retrieve the Name column from within the ProductCategory table? STEP 4 As the database administrator of the AdventureWorks Corporation, you recently created some databases, and you have just realized how large the databases will become in the future. Therefore, you need to create a new clustered index to help with overall performance. Using the SSMS interface, what steps will you use to create a new clustered index on the name column for the AdventureWorks database? 4 Be sure to take snapshots of your steps as you create the clustered index. This is what