Question: Using the AdventureWorks database and the Production schema create a view that returns Name from the Products table, Name from the ProductCategory table, Name from

Using the AdventureWorks database and the Production schema create a view that returns Name from the Products table, Name from the ProductCategory table, Name from the ProductSubCategory table, and Quantity from the ProductInventory table. Use appropriate aliases for the columns. Inspect the tables to determine the join conditions. Take a screen shot of the SQL windows and results and paste it here. Part 2 Write a query to select rows from the above view returning only rows where the name in the ProductSubCategory table contains 'bikes'. Take a screen shot of the SQL windows and results and paste it here. Part 3 Alter the view created in Part 1 to include the ListPrice from the Products table and only returns rows with a ListPrice greater than 2000 dollars. Take a screen shot of the SQL windows and results and paste it here. Part 4 Write a query to select rows from the above view returning only rows where the ListPrice is greater than 2000 but less than 3000 dollars. Take a screen shot of the SQL windows and results

Step by Step Solution

★★★★★

3.36 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Lets start with Part 1 and continue step by step Part 1 Create a view with columns from different ta... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This data set represents the web server hit logs for a single website for a single day. You're going to do some analysis of the data, but first you need to normalize it properly -- which requires...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Coursework 1 The Global Motoring and Driving School was established in a makeshift kiosk at Lapaz in 2007. The School has since then grown steadily and now has several plush offices in most of the...

Part 1 Using the WideWorldDistributors database and the Sales schema create a function that takes InvoiceID as an input parameter and returns all the rows from the table InvoiceLines for the...

Using AdventureWorks database and the Production schema write a common table expression that returns all rows from the table Product in the Production schema and has a Name in the ProductSubcategory...

Part 1 This lab will test your knowledge of transactions and error handling. Using the WideWorldImporters database and the Warehouse schema, perform the following tasks: Truncate the data in table...

Using the WideWorldDistributors database and the Sales schema create a function that takes InvoiceID as an input parameter and returns all the rows from the table InvoiceLines for the InvoiceID...

Part 1 Using the WideWorldDistributors database and the Sales schema write a function that takes InvoiceID as an input parameter and returns all the rows from the table InvoiceLines for the InvoiceID...

This assignment will require you to perform some analysis of financial ratios and some research from other sources to further your understanding of financial ratios. You will select an industry and...

Finance Ratios- Need help understanding this ROE assignment. For this assignment we are going to focus on one ratio which can actually be calculated using three other ratios. That ratio is the Return...

6) If A is a 33 invertible matrix, then the nullity of A is 0? Explain 7) Which of the following is not a subspace of R^3 space, where a, b, c belongs to R? Explain a)All vectors of the form (a, 0,...

Frightproof Commuter Airlines is considering adding a new flight to its current schedule from Metro to Hicksville. This route has the following prices and costs: Selling price per passenger per...

Accepl My courses BU 4 7 7 4 HW 1 Why Study Financial q , Problem 1 Part 1 Attempt 1 / 5 for 1 0 pts . Which statements are true about financial markets? Check all that apply: Well - functioning...

The small collar A is sliding on the bent bar with speed u relative to the bar as shown. Simultaneously, the bar is rotating with angular velocity w about the fixed pivot B. Take the x-y axes to be...

At the beginning of April, Current Designs had 30 kayaks in process in the Fabrication Department. Rick Thrune, the production manager, estimated that about 80% of the materials costs had been added...

In Exercises 5 and 11, you described the relationship between height (in inches) and weight (in pounds) for Olympic track and field athletes. The scatterplot shows this relationship, along with two...

Conduct a one-sample t-test for a dataset where = 14.1, X = 13.7, s x = 0.8, n = 20. a. What are the groups for this one-sample t-test? b. What is the null hypothesis for this one-sample t-test? c....

Why are people so willing to buy bottled water when it is so expensive, both financially and environmentally?

A salesperson whose primary responsibility is to maintain relationships with existing customers is a(n) detailermissionaryorder getterorder takerpioneer

In the last chapter you modified some queries for the Wine Depot. Now Barbara would like you to help her create some new forms. Make the following changes for Barbara using the chl l-04_student_name...

SQL Part 1 Using the WideWorldImporters database and the Sales schema select CustomerName, CreditLimit, PhoneNumber from the table Customers and the corresponding CustomerCategoryName, ValidFrom, and...

For this activity, we will using the AdventureWorks database. (Here is the link to download the sample database if needed. https://archive.codeplex.com/?p=msftdbprodsamples Select the oltp file)...

https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks Using the AdventureWorks Database you will create the following Views. 1. Create a View named Employeelnfo that lists an...