The following requirement is to update TST1_Q5 table in your DB account. Write single update statement to modify student GPA as following, both part a and part b should be met by a single update statement. student table contains stdno, stdgpa, stdclass

offering table contains offerno, offyear

enrollment table contains stdno, offerno, enrgrade

a) set student GPA to the average grade the student received for the classes taken in 2017(offyear).

b) if student did not take classes in 2017 (offyear), leave GPA unchanged.