Creating Views
Part 1 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, a
...
Creating Views
Part 1 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 screenshot 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 screenshot of the SQL windows and results and
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 screenshot 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 screenshot of the SQL windows and
results and paste it here
This study source was downloaded by 100000822447745 from CourseHero.com on 07-17-2022 at 13:17:56 GMT -05:00
https://www.coursehero.com/file/84119689/LAb-27-29docx/LAB 28
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 InvoiceID value is passed into the function. If the result is a NULL return a zero. Take a screen
shot of the SQL windows and results and paste it here.
Part 2 Using the WideWorldDistributors database and the Sales schema write a query
that returns InvoiceID, InvoiceDate, and CustomerPurchaseOrderNumber from the table
Invoices and the result of the above-created function. Take a screenshot of the SQL
Part 3 Using the AdventureWorks database and the Production schema create a
function that takes ProductId as an input parameter and returns the results of a query
that retrieves ProductID, Name, Color, Weight, and DaysToManufacgture from the table
Product. Take a screenshot of the SQL windows and results and paste it here.
Part 4 Using the AdventureWorks database and the Production schema write a query
that returns the results of the function in Part 3 for ProductID 320. Take a screenshot of
the SQL windows and results and paste it here.
Part 5 Using the AdventureWorks database and the Production schema write a query
that returns the results of the function in Part 3 for ProductID 15. Take a screenshot of
the SQL windows and results and paste it here.
[Show More]
