Unit 2: Introduction to Structured Query Language This document describes 10 commands you need to create and execute on your local SQL Server in the AdventureWorks database.

1.Displayall columns all rows from the Person table in the Person schema

2.Display only the columns LastName , FirstName, BusinessEntityID (show the output in that order) all rows from the Person table in the Person schema.

3.Modify the statement above to only show rows that have a BusinessEntityID of 285.

4.Modify the statement above to show rows that have a BusinessEntityID of 285, 293 or 11 (use an IN operator).

5.Display only the columns LastName, FirstName for individuals with the last name of Abel (since this a Character field remember to use single quotes around the name).

6.Display only the columns LastName, FirstName for individuals with the last name of Abel , Baker, or Barber (since these are Character fields remember to use single quotes around the names).

7.Display only the columns StateProvinceCode, CountryRegionCode, Name from the schema Person table StateProvince. Sort the data by CountryRegionCode.

8.Modify the above select statement to only show rows that are in the CountryRegionCode of CA.

9.Display only the columns ProductID, ListPrice and ModifiedDate from the schema Production table ProductListPriceHistory.

10.Modify the above select statement to only show rows that have a ModifiedDate in 2012 s word.