|
|
|
|
|
|
Query
-----------------------------------------------------------------------
--- QUERY #2
--- Stocks with maximum traded quantity and value in a
--- given settlement period
-----------------------------------------------------------------------
SELECT Settlement_Description,
Stock_Name,
SUM(Total_Traded_Quantity) AS Total_Traded_Qty,
SUM(Total_Turnover) AS Total_Trade_value
FROM StockTransaction_Fact A,
Settlement_Dimension B,
Stock_Dimension C,
Date_Dimension D
WHERE A.Settlement_Key = B.Settlement_Key
AND A.Stock_Key = C.Stock_Key
AND A.Date_Key = D.Date_Key
AND B.Settlement_Description = '2000010'
AND D.Calendar_Month_Number_in_Year = 1
AND D.Calendar_Year = 2004
GROUP BY Settlement_Description,
Stock_Name
ORDER BY Settlement_Description,
Stock_Name;