Illustrated Microsoft® Office 365 & Excel 2016, Comprehensive, 1e Elizabeth Eisner Reding, Lynn Wermers (Test Bank)

$ 25

Information Technology > Quiz > Adventure Works database and the Production schema (All)

Adventure Works database and the Production schema

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 [Show More]

Last updated: 3 years ago

Preview 1 out of 2 pages

Buy Now

Instant download

We Accept: