CCA159 : Task Scenario-13

Problem Scenario 13:  Create a table as below.

Table Name :  HADOOPEXAM_STOCK

Columns : (exchange string, stock_symbol string,  closing_date timestamp, closing_price decimal(8,2));

Please insert below values.

- Write a Query to compute moving averages of the closing price, with 3-day span.

- Write a query to compute a cumulative moving average, from the earliest data up to the value for each day.