1. Review SQL below. Replacing myTable and Column NameswithTables and ColumnsNames in YOUR Database write SQL statement and run it.
Select
s.SalesOrderDate, s.SaleOrderID, s.Quantity,
m.MarketName, r.RegionName ,c.CustomerName,
p.ProductName, f.ProductFamilyName,
a.AgentName, mm.ManagerName, mm.Commissions,
p.UnitPrice * s.Quantity as OrderAmount,
p.UnitPrice * s.Quantity * mm.PcntCommissions *0.01 as OrderCommissionsAmmount
FROM SalesOrder s, Customer c, Market m, Region r, Product p, ProductFamily f, Agent a, Manager mm
WHERE
c.MarketID = m.MarketID and
c.RegionID = r.RegionID and
c.CustomerID = s.CustomerID and
s.ProductID= p.ProductID and
p.ProductFamilyID = f.ProductFamilyID and
s.AgentID = a.AgentID and
a.ManagerID = mm.ManagerID ;
Make sure OrderAmount and CommissionsAmmount are calculated.
SQL must return 25 records
2. Using SQL statement from question 1
Run :
Create view Week6_sales_vi as put your SQL from above here ;
UPLOAD and Submit SQL statement in PDF if the view returned data(25 records ) only.