Information Technology > Quiz > LAB 27 Creating Views (All)
LAB 27: 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 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 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 and paste it here Part 1Using 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 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. [Show More]
Last updated: 1 year ago
Preview 1 out of 8 pages
Connected school, study & course
About the document
Uploaded On
Oct 24, 2022
Number of pages
8
Written in
This document has been written for:
Uploaded
Oct 24, 2022
Downloads
0
Views
93
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·