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. 

DDL_CreateTables.sql

DML_LoadData.sql