Unnamed
public text v1 · immutableCREATE VIEW SMA AS
SELECT SUM(SELECT CLOSE FROM STOCKS WHERE SYMBOL = STOCKS.SYMBOL AND DATE <= STOCKS.DATE LIMIT 0,2) AS SMA_2
FROM STOCKSCREATE 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