TOPIC: SQL Stored procedures S_ID Name Gender City Attendance Quiz Quiz Quiz Assign Assign Assign Final % I 1 2 3 1 2 3 (10) (10) (10) (10) (15) (10) (45) 101 201 5 7 34 69 88 ON 5 12 11 10 301 401 501 601 5 Ella F Christian M Sofia F Lillian F John M Joseph M Califomia Texas Arizona Maryland Califomia Hawaii Colin 00 al lalu 6 3 7 43 26 34 68 82 60 72 9 4 8 lol lol 7 O 00 8 14 la 41 22 6 T_ID 1101 1102 1103 1104 CourseName Digital marketing AI and data science Web development Cyber Security SID 101 301 401 201 CASE: The above tables are extracted an examination department of an institution. The examination department wants to have a consolidated total of students' scores in each subject, where, the weightage of quizzes, assignments and attendance are 25%, 35% and 5% respectively. The remaining weightage belongs to the final term result. Also, they requested the IT department for a procedure which generates Letter Grades and respective Grade Points (as mentioned in the table below). As the institution has many campuses over the country, they also need to have a City-wise students' progress for campus-wise comparison Marks Grade Points 88-100 4 81-87 B+ 3.5 74-80 B 3 67-73 C+ C 2.5 60-66 C 2 Below 60 F Styles TOPTOHSQL Stored procedures SID Name Gender City Attendance Quiz Quiz Quiz Assign.Assign Assign Final % 1 3 1 2 3 (10) (10) (10) (10) (15) (10) (45) 7 34 101 201 301 401 501 601 Ella F Christian M Sofia F Lillian F John M Joseph M 12 11 10 Califomia Texas Arizona Maryland Califomia Hawaii 5 6 5 6 7 43 26 69 88 68 82 60 72 6 7 5 4 8 5 5 8 5 DONNlulo 6 3 7 6 9 34 8 41 8 5 14 4 22 TID 1101 1102 1103 1104 CourseName Digital marketing AI and data science Web development Cyber Security SID 101 301 401 201 CASE: The above tables are extracted an examination department of an institution. The examination department wants to have a consolidated total of students' scores in each subject, where, the weightage of quizzes, assignments and attendance are 25%, 35% and 5% respectively. The remaining weightage belongs to the final term result. Also, they requested the IT department for a procedure which generates Letter Grades and respective Grade Points (as mentioned in the table below). As the institution has many campuses over the country, they also need to have a City-wise students progress for campus-wise comparison Marks Grade Points 88-100 A 4 81-87 B+ 3.5 74-80 B 67-73 C+ 2.5 60-66 2 Below 60 F 0 TOPIC: SQL Stored procedures S_ID Name Gender City Attendance Quiz Quiz Quiz Assign Assign Assign Final % I 1 2 3 1 2 3 (10) (10) (10) (10) (15) (10) (45) 101 201 5 7 34 69 88 ON 5 12 11 10 301 401 501 601 5 Ella F Christian M Sofia F Lillian F John M Joseph M Califomia Texas Arizona Maryland Califomia Hawaii Colin 00 al lalu 6 3 7 43 26 34 68 82 60 72 9 4 8 lol lol 7 O 00 8 14 la 41 22 6 T_ID 1101 1102 1103 1104 CourseName Digital marketing AI and data science Web development Cyber Security SID 101 301 401 201 CASE: The above tables are extracted an examination department of an institution. The examination department wants to have a consolidated total of students' scores in each subject, where, the weightage of quizzes, assignments and attendance are 25%, 35% and 5% respectively. The remaining weightage belongs to the final term result. Also, they requested the IT department for a procedure which generates Letter Grades and respective Grade Points (as mentioned in the table below). As the institution has many campuses over the country, they also need to have a City-wise students' progress for campus-wise comparison Marks Grade Points 88-100 4 81-87 B+ 3.5 74-80 B 3 67-73 C+ C 2.5 60-66 C 2 Below 60 F Styles TOPTOHSQL Stored procedures SID Name Gender City Attendance Quiz Quiz Quiz Assign.Assign Assign Final % 1 3 1 2 3 (10) (10) (10) (10) (15) (10) (45) 7 34 101 201 301 401 501 601 Ella F Christian M Sofia F Lillian F John M Joseph M 12 11 10 Califomia Texas Arizona Maryland Califomia Hawaii 5 6 5 6 7 43 26 69 88 68 82 60 72 6 7 5 4 8 5 5 8 5 DONNlulo 6 3 7 6 9 34 8 41 8 5 14 4 22 TID 1101 1102 1103 1104 CourseName Digital marketing AI and data science Web development Cyber Security SID 101 301 401 201 CASE: The above tables are extracted an examination department of an institution. The examination department wants to have a consolidated total of students' scores in each subject, where, the weightage of quizzes, assignments and attendance are 25%, 35% and 5% respectively. The remaining weightage belongs to the final term result. Also, they requested the IT department for a procedure which generates Letter Grades and respective Grade Points (as mentioned in the table below). As the institution has many campuses over the country, they also need to have a City-wise students progress for campus-wise comparison Marks Grade Points 88-100 A 4 81-87 B+ 3.5 74-80 B 67-73 C+ 2.5 60-66 2 Below 60 F 0