Category: Essays

5)Rank order all students by total credit (DESC)  6)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  7)Compute averagenumber of credits over threepreceding yearsper department using the view you created  8)Compute maximumnumber of credits over for the windowof 2 years before and…