CREATE VIEW SMA AS
SELECT SUM(SELECT CLOSE FROM STOCKS WHERE SYMBOL = STOCKS.SYMBOL AND DATE <= STOCKS.DATE LIMIT 0,2) AS SMA_2
FROM STOCKS