Using the University Database:
1)
Rank order all students by total credit (DESC)

2)
Create a view tot_credits_dept
(columns: year, dept_name,
num_credits)
with the total
number of credits taken
by all students in each year for courses offered by each department

3)
Compute average
number of credits over three
preceding years
per department using the view you created

4)
Compute maximum
number of credits over for the window
of 2 years before and 2 years after the
current year per department
5)
Using the view you just created, get the average
total credits by each department over all prior years.