1. Create a SQL Script called Module06AssignmentCode.sql
2. Write a Query that creates the summation results
3. Save the Query called SQL view called vSelOrdersByProducts
4. Create either a Report Builder or PowerBI report that shows the data using view. Call the report OrdersByProducts to create either a OrdersByProducts.rdl or OrdersByProduct.pbix file.
5. Place the resulting SQL script file and either the .rdl or pbix file into a folder, zip it, and submit it.
6. Submit the final SQL script file and (.rdl or .pbix) file.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

use AdventureWorks2012;
if exists(select 1 from sys.views where name='Production.vMyOrder' and type='v')
drop view Production.vMyOrder ;
create view Production.vMyOrder as
select soh.OrderDate, sod.ProductID,
sum(sod.OrderQty) as 'SumOrderQuantity', sum(sod.UnitPrice) as 'SumOfUnitPrice'
from Sales.SalesOrderDetail sod inner join Sales.SalesOrderHeader soh
on sod.SalesOrderID = soh.SalesOrderID
group by soh.OrderDate, sod.ProductID
) ;

if exists(select 1 from sys.views where name='Production.vMyProduct' and type='v')
drop view Production.vMyProduct;
create view Production.vMyProduct as
select p.ProductID, p.Name as 'Product', pc.Name as 'ProductCategory', ps.Name as 'ProductSubcategory'
from Production.Product p inner join Production.ProductSubcategory ps...

By purchasing this solution you'll be able to access the following files:
Solution.sql and Solution.pbix.

for this solution

or FREE if you
register a new account!

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Upload a file
Continue without uploading

We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats