|
|
|
|
|
|
Query
--------------------------------------------------------------------
--- Query 04
--- Types of traders who have a maximum turnover in a given week
--------------------------------------------------------------------
SELECT TraderType,
SUM(Total_Traded_Quantity) AS Total_Traded_Quantity,
SUM(Total_Deliverable_Qty) AS Total_Deliverable_Qty,
SUM(Total_Deliverable_Qty)
/ SUM(Total_Traded_Quantity) AS Delivery_Trade_Ratio
FROM StockTransaction_Fact A,
Date_Dimension B,
Trader_Dimension C
WHERE A.Date_Key = B.Date_Key
AND A.Trader_Key = C.Trader_Key
AND B.Calendar_Week_Number_in_Year = 9
GROUP BY TraderType
ORDER BY Delivery_Trade_Ratio;