Write SQL statements that using All tables that you need to : 1. Select TotalAmo

Question

Write SQL statements that using All tables that you need to :

1. Select TotalAmount per Customer, ProductFamily per Year, per QtrYear

2. Select TotalAmount per Agent, ProductFamily per Year, per QtrYear

Product Family Key Field Type Key Field Type Key Field Type ManagerName varchar(30) CommisionsPct float ManagerPhone char(12) AgentName varchar(30) AgentPhone char(12) PK AgentID FK ManagerlD int int ProductDescr varchar(100) Unit Price PK ProductID int ManagerAgent FK FK Key ManagerlD int AgentID int DateAssign|date Sales Order OrderDate date Market Total Amt int PK MarketlD Type MarketDeahar50) FK CustID FK ProductID FK AgentlD PK OrderNo FK S date Customer Customer Market int PK Customer Name varchar(50) FK CustID int int FK MarketlD int Customer Phone char(12) achar(20) Customer Zip Customer ID Calendar PK IS date char S_year S qtr

Explanation / Answer

If you have any doubts, please give me comment...

-- 1)

SELECT C.CustID, CustomerName, TotalAmt, S_year, S_qtr

FROM (SalesOrder S INNER JOIN Calendar C ON S.S_date = C.S_date)INNER JOIN Customer C ON C.CustID = C.CustID;

-- 2)

SELECT A.AgentID, AgentName, TotalAmt, S_year, S_qtr

FROM (SalesOrder S INNER JOIN Calendar C ON S.S_date = C.S_date) INNER JOIN Agent A ON A.AgentID = S.AgentID;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.