Consider the following table $$Student$$ which is assigned with student$$s

marks and grades. Add one more column $$Eligible$$ to the table which

stores Boolean values $$y$$ or $$n$.$

Write a stored procedure to calculate the average of the total$\_$marks

and assign the value to the $$Eligible$$ column based on the criteria that

the student who got total$\_$marks above the average mark is eligible.Consider the following table "Student" which is assigned with student's marks and grades. Add one more column "Eligible" to the table which stores Boolean values $\text{'}y\text{'}$ or $\text{'}n\text{'}.$

Write a stored procedure to calculate the average of the total marks and assign the value to the "Eligible" column based on the criteria that the student who got total marks above the average mark is eligible.