Reference no: EM131280051

Extracting Data from a Database

You are a database administrator for the AdventureWorks Corporation, and a service managerneeds your help extracting data from the company's database. Therefore, after opening SSMSand accessing the AdventureWorks database, specify the basic SELECT statements you woulduse to retrieve the required information from the ProductsSubcategory table.

1. What commands would return all the rows and columns in the ProductCategory table?
2. What commands would you type and execute to return only the ProductSubcategoryID,ProductCategoryID, Name, and ModifiedDate columns?
3. What commands would you type and execute to return rows where the word bikeappears somewhere in the Name column?
4. In the existing query window, what commands would you use to add a column alias tothe Name column to clarify it as the subcategory name?
5. In the existing query window, what command would you use to sort the previousresult set?