Book Contents

Book Index

Next Topic

Home

stock_query_05

Query

--------------------------------------------------------------------

--- Query 05

--- Exchange that has a maximum turnover in a year

--------------------------------------------------------------------

SELECT Calendar_Year,

Exchange_Name,

SUM(Total_Traded_Quantity) AS Total_Traded_Quantity,

SUM(Total_Turnover) AS Total_Trade_value

FROM StockTransaction_Fact A,

Date_Dimension B,

Exchange_Dimension C

WHERE A.Date_Key = B.Date_Key

AND A.Exchange_Key = C.Exchange_Key

GROUP BY Calendar_Year,

Exchange_Name

ORDER BY Total_Trade_value DESC,

Total_Traded_Quantity;