|
|
|
|
|
|
Query
-----------------------------------------------------------------------
--- QUERY #1
--- Stocks that gained between 70% and 75% on a given day
----------------------------------------------------------------------
SELECT B.Stock_Name,
MIN(A.Close_Price),
MAX(A.Close_Price)
FROM StockTransaction_Fact A,
Stock_Dimension B
WHERE A.Date_Key > 50
AND A.Date_Key < 53
AND A.Stock_Key = B.Stock_Key
AND (((A.close_Price - A.Previous_Close) * 100) / A.Previous_Close) > 70
AND (((A.close_Price - A.Previous_Close) * 100) / A.Previous_Close) < 75
GROUP BY B.Stock_Name
ORDER BY B.Stock_Name;