Show how to define a view tot_credits (year num_credits)giving the total number

Show how to define a view tot_credits (year num_credits)giving the total number of credits taken by students in eachyear.