In 2001, Importadores Neptuno, became the sole manufacturer and distributor of the touring bicycle product group.Ĭoming off a successful fiscal year, Adventure Works Cycles is looking to broaden its market share by targeting their sales to their best customers, extending their product availability through an external Web site, and reducing their cost of sales through lower production costs. These subcomponents are shipped to the Bothell location for final product assembly. Importadores Neptuno manufactures several critical subcomponents for the Adventure Works Cycles product line. In 2000, Adventure Works Cycles bought a small manufacturing plant, Importadores Neptuno, located in Mexico. While its base operation is located in Bothell, Washington with 290 employees, several regional sales teams are located throughout their market base. The company manufactures and sells metal and composite bicycles to North American, European and Asian commercial markets. Microsoft provides the following bio for the Adventure Works company over at Technet:Īdventure Works Cycles, the fictitious company on which the AdventureWorks sample databases are based, is a large, multinational manufacturing company. Fortunately, Microsoft comes to the rescue with their fictional company, Adventure Works, and the Adventure Works Databases. It’s easy to generate a small amount of good data yourself, or a large amount of really random data, but neither of these are very robust. Now, actually coming up with a robust set of sample data that has no tie back to any proprietary business data can actually be a tricky prospect. Describe the difference between division and modulo.Sample Data - An Intro to Adventure Worksįrom time to time, it’s handy to have access to some good, solid sample data.Include the SpecialOfferID and Description columns in the results. If the MaxQty value is NULL, replace it with the value 10. Write a query using the Sales.SpecialOffer table that multiplies the MaxQty column by the DiscountPct column.Multiply the MinQty column by the DiscountPct column. Write a query using the Sales.SpecialOffer table. Display the difference between the MinQty and MaxQty columns along with the SpecialOfferID and Description columns. Use the AdventureWorks2012 database to complete this exercise. Explain the difference between the ISNULL and COALESCE functions.Hint: You will need to use a function to write this query. Write a query using the Production.Product table displaying a description with the “ProductID: Name” format.Make sure that all rows display a value even if the Color value is missing. Modify the query written in question 2 so that the description of the product is displayed in the “Name: Color” format.If the color column contains a NULL value, replace the color with No Color. Write a query using the Production.Product table displaying the product ID, color, and name columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |