***Note : posting this for the 3rd time so don't waste my turn and answer this properly***

final term result is in 2nd picture

i need query for atore procedure of aggregate of finals

TOPIC: SQL Stored procedures: S ID Name Gender City Attendance Quiz Quiz Quiz Assign % 1 2 3 1 (10) (10) (10) (10) 5 8 6 5 101 Ella F California 69 201 Christian M Texas 88 6 7 7 5 301 Sofia F 68 5 2 5 8 401 Lillian F Arizona Maryland California 82 6 3 4 5 501 John M 60 7 5 8 9 601 Joseph M Hawaii 72 8 6 0 5 TID CourseName S ID 1101 101 1102 301 Digital marketing AI and data science Web development Cyber Security 1103 401 1104 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 3 67-73 C+ 2.5 60-66 2 Below 60 F 0 rocedures: nder City 2 3 3 Attendance Quiz Quiz Quiz Assign Assign Assign Final % 1 1 3 (10) (10) (15) (10) (45) 69 5 8 6 12 7 34 California 5 1 Texas 88 6 7 7 5 11 6 43 Arizona 68 5 2 5 8 10 3 26 82 6 3 4 5 9 7 34 Maryland California 60 7 5 8 9 8 6 41 Hawaii 72 8 6 0 5 14 4 22 S ID 101 urseName gital marketing and data science eb development ber Security 301 401 201 s are extracted an mination department of an ation department wants to have a consolidated in each subject, where, the weightage of quizzes, ance are 25%, 35% and 5% respectively. The belongs to the final term result. Also, they tment for a procedure which generates Letter Grade Points (as mentioned in the table below). many campuses over the country, they also need lents' progress for campus-wise comparison. Marks Grade Points 88-100 A 4 81-87 B+ 3.5 74-80 B 3 67-73 C+ 2.5 60-66 2 Yo Below 60 F 0 Read Only - You can't save changes...