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

A Lab Final + X G Meet - kro-ebhw-bot SOL - Socia Network My answers to SOL exercises for Google Chrome classroom.google.com/u/2/c/MTU3MjE_MjY1ODM5/a/MjU2MTQ1 2 is using the webxam X 1337x.to 1337x.15 A Classes & 111 Sec 2 Lectures... C Get Homework Hel. www.netflix.com Fanha Binte Habib !!! Apps M Gmail CSE 311L - Fall 2020 Students(ID, name, status) Grade History(ID courselb, courseCredit, grade_point) , ) Friend(ID 1,102) Likes/ID1, D2) E Lab Fina Friend table represents unidirectional relationships ie if idi = 1510 and id2 = 1381 means 1510 friends with 1381 but not vice versa. Assigned Naul Alam D 100 points Id or create Likes table represents unidirectional relationships ie 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. kas done Students Friend Likes Grade History Class comments 1381 1689 1709 ID name 1025 Rick 1101 Jerry 1247 Shaggy Rogers 1304 Winnie the Pooh 1316 Leonardo 1381 Charlie Brown and Snoopy 1463 Mickey Mouse 1501 Raphael 1510 Bugs Bunny 1641 Scooby Doo 1661 Scrooge McDuck 1689 Homer Simpson 1709 Toen 102 4 TH 1911 HomerJ. Simpson 1934 Morty 101 102 ID1 D2 1510 1381 1510 1689 1709 1381 1247 1782 1709 17091247) 1911 1247 1689 1782 1782 1466 1247 1468 1782 1304 1316 1304 14681101 1501 1934 1468 1641 Du coad gradepot yos 05 SET IN 28 FAL 15 CSET 3 1 2 FALL 0 IN 2 FALL 304 SE 3 IN 2 FALL 116 SET 0 IN 2 FALL 11 CSE 3 2. FALL 5 CSEL 0 IN 2 FALL 8 (9 3 20 FALL FL 501 CSE TIL 0 IN 2 FALL 501 CSEL 3 3. 2712 PLL 541 CSEL IN 2 FALL 541 CSE 3 IN 2 FALL 1782 1310 1641 1468 1101 1641 1934 1501 1247 1911 1025 1101 1247 1501 1911 1501 1501 1934 1316 1934 1934 1304 1304 1661 1661 1025 Write an expression in SQL for each of the following queries: POEL 4:24 PM 1/15/2021