Create a view that shows the average GPA for each student grouped by semester and year. This

view will provide a semester$-$wise GPA trend for students. Student$\_$semester$\_$gpa$($sudent$\_$id$,$

semester, year, gpa$).$

Now, using the student$\_$semester$\_$gpa view using a window, write a query that calculates the

cumulative GPA for each student at the end of each semester. The cumulative GPA should be the

average of all semester GPAs up to and including the current semester$/$year for each student.

Make sure you display spring and then fall for each year.

Deliverables

$$ SQL code for creating view Student$\_$semester$\_$gpa$($sudent$\_$id$,$semester,year,gpa$).(1$

Point$)$

$$ SQL code for query to display student id$,$ semester, year, gpa and cumulative gpa.

$(1$point$)$