|
|
|
|
|
|
Query
-----------------------------------------------------------------------
--- QUERY #3
--- Stocks with maximum traded quantity and value in a
--- given week of the year
-----------------------------------------------------------------------
SELECT Day_Number_in_Calendar_Month,
C.Stock_Name,
SUM(Total_Traded_Quantity) AS Total_Traded_Qty,
SUM(Total_Turnover) AS Total_Trade_value
FROM StockTransaction_Fact A,
Date_Dimension B,
Stock_Dimension C
WHERE A.Date_Key = B.Date_Key
AND A.Stock_Key = C.Stock_Key
AND B.Calendar_Week_Number_in_Year = 7
GROUP BY Day_Number_in_Calendar_Month,
Stock_Name;