Learn from the best Tutor in the world

CIS376 Strayer University (CIS)

CIS376 Week 1 Lab

Using the AdventureWorks database, select all of the data from the table Products in the Production schema. Take a screen shot of the SQL windows and results and paste it here.

Using the AdventureWorks database, select the ProductNumber, Name, ListPrice, ReorderPoint and DaysToManufacture from the table Production.Product. Take a screen shot of the SQL windows and results and paste it here.

Using the AdventureWorks database, select the ProductNumber, Name, ListPrice, ReorderPoint and DaysToManufacture from the table Production.Product and sort by ListPrice and DaysToManufacture, both in descending order. Take a screen shot of the SQL windows and results and paste it here.

Using the AdventureWorks database, select the unique lastname from the table Person in Person schema. Take a screen shot of the SQL windows and results and paste it here.

Using the AdventureWorks database, select all the rows from the table Product in Production schema and sort it by product name within standard cost with standard cost going from highest to lowest Take a screen shot of the SQL windows and results and paste it in here.

Using the WideWorldImporters database, select fifteen percent of the rows from the table Invoices in the Sales schema. Take a screen shot of the SQL windows and paste it here.

Using the WideWorldImporters database, return all the rows from the table StockItems in the Warehouse schema that have SupplierID of 10 and a ColorID of 4. Take a screen shot of the SQL windows and paste it here.

Using WideWorldImporters return all the rows from the table Orders in the Sales schema that have an OrderDate that is in the month of April, 2016. You must use the Between clause for this query. Take a screen shot of the SQL windows and paste it here.

Using the AdventureWorks database, return the LastName, FirstName, MiddleName, and PersonType from the table Person in the Person schema whose last time starts with the letter ‘S’ and whose PersonType is either an ‘SC’ or an ‘IN’. Sort by the last name. Take a screen shot of the SQL windows and paste it here

Using the AdventureWorks database, return the LastName, FirstName, MiddleName, and PersonType from the table Person in the Person schema whose last time starts with the letter ‘S’ and has an ‘m’ anywhere else in the LastName, whose first name has an R anywhere in the FirstName, and whose PersonType is either an ‘SC’ or an ‘IN’. Sort by the last name and first name. Take a screen shot of the SQL windows and paste it here.