SQL. I need a fast answer please (online assignment) thanks,

Given:

mysql> Delimiter $$

create procedure totalCreditsRegisterdByStudent()

begin

declare done int default 0;

declare current_sId int;

declare sIdCur cursor for select studentId from student;

declare continue handler for not found set done = 1;

_____________________________________________________

_____________________________________________________

______________________________________________________

end $$

Delimiter ;

Consider the following tables registration and student, where the column studentId in table registration is a foreign key that references studentId in table student registration studentid CRN credits 1 11123 4 1 10253 3 1 14523 2 4 11123 4 4 10253 3 4 14523 2 4 15523 4 5 15523 4 student studentId totalCredits 1 0 4 0 5 0 While applying the process to develop information systems applications in databases, create a stored procedure in SQL totalCreditsRegisterdByStudent() that will update the totalCredits in the table student by summing the credits registered by student (from table registration). Part of the procedure is given below; fill in the missing code as follows