Database designs | Computer Science homework help

 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 totalnumber of credits takenby all students in each year for courses offered by each department
3)Compute averagenumber of credits over threepreceding yearsper department using the view you created
4)Compute maximumnumber of credits over for the windowof 2 years before and 2 years after thecurrent year per department5)Using the view you just created, get the averagetotal credits by each department over all prior years.