ZAJq5ntg

1CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS 
2SELECT avg(Close_Price) over(ORDER BY Date ROWS 19 PRECEDING) as 20_DMA 
3from assignment.bajajauto_1;