week 6 Lab Report
Document Content and Description Below
Part 1- 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 ProductSub... category table which contains ‘frame’. Review the tables to determine the join condition for the tables. Run the SQL to return rows from the CTE. Take a screen shot of the SQL windows and results and paste it here. Part 2- Using WideWorldImporters database create a common table expression that returns two columns, ItemName and TotalSales. The query inside the CTE will return the StockItemName from the table StockItems in the Warehouse schema and the total sales (Quantity times UnitPrice) for each item from the table InvoiceLines in the Sales schema. Review the tables to determine the joins for the tables. Write a query that returns all rows from the CTE where the total sales is at least 1000 dollars. Take a screen shot of the SQL windows and results and paste it in here This study source was downloaded by [Show More]
Last updated: 2 years ago
Preview 1 out of 2 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$7.50
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Oct 06, 2022
Number of pages
2
Written in
Additional information
This document has been written for:
Uploaded
Oct 06, 2022
Downloads
0
Views
110
