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.