Consider the nyse relation of Exercise 5.9. For each month of each year, show the total monthly dollar volume and the average monthly dollar volume for that month and the two prior months. (Hint:...

Consider the nyse relation of Exercise 5.9. For each month of each year, show

the total monthly dollar volume and the average monthly dollar volume for that

month and the two prior months. (Hint: First write a query to find the total

dollar volume for each month of each year. Once that is right, put that in the

from clause of the outer query that solves the full problem. That outer query

will need windowing. The subquery does not.)