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;