Question : Create a table called CGPA(ID, cgpa) which stores current c.g.p.a for each student and write a trigger on the GradeHistory table which automatically updates the CGPA table while any changes happen.

For the following relation schema: Students(ID, name, status) Grade History(ID, courselD, course Credit, grade_point) Friend(ID1,ID2) Likes(ID1, ID2) Friend table represents unidirectional relationships i.e if id 1 = 1510 and id2 = 1381 means 1510 friends with 1381 but not vice versa. Likes table represents unidirectional relationships i.e if id1 = 1689 and id2 = 1709 means 1689 Likes 1709 but not vice versa. The four years of undergraduate education are called: freshman, sophomore, junior, Senior. Students Friend Likes Grade History ID name 1025 Rick 1101 1247 1304 1316 1381 1468 1501 ID1 1510 1510 1689 1381 1709 1689 1782 1782 1782 1468 1468 1101 1247 1247 1911 1501 1316 1934 1304 1661 ID coursell courseCredit grade_point year semester 1025 CSE311L 0 0.00 2020 FALL 1025 CSE311 3 3.00 2020 FALL 1304 CSE311L 0 0.00 2020 FALL 1304 CSE3112 3 3.002020FALL 1316 CSE3112 0 0.00 2020 FALL 1316 CSE311L 3 4.00 2020 FALL 1468 CSE311L 0 0.00 2020 FALL 1468 CSE311L 3 330 2020 FALL 1501 CSE311L 0.00 2020 FALL 1501 CSE311L 3 2702020 FALL 1641 CSE3111 0 0.00 2020 FALL 1641 CSE3112 3 370 2020 FALL Jerry Shaggy Rogers Winnie the Pooh Leonardo Charlie Brown and Snoopy Mickey Mouse Raphael Bugs Bunny Scooby-Doo Scrooge McDuck HomerJ. Simpson Tom Doremon HomerJ. Simpson Morty ID2 ID1 ID2 1381 1689 1709 1689 1709 1709 1689 1247 1782 1709 1247 1911 1247 1782 1247 1468 1468 1316 1641 1468 1304 1316 1304 1101 1501 1934 1641 1934 1501 1641 1911 1025 1101 1501 1501 1934 1934 1304 1661 1025 1510 1641 1661 1689 1709 1782 1911 1934 Write an expression in SQL for each of the following queries