Using the Class database, answer the following questions:
1. Create a stored procedure that for any student id entered, alist of absences for that
student will be displayed. Display the student id, student name,and the dates the
student has missed. Display the total number of days missed forthis student. Name
this stored procedure
StudentAbsences
.
a. What did you write for your stored procedure? Insert the snipof the contents of the
stored procedure here:
b. Run your stored procedure for student 17. Insert your snipshowing your stored
procedure call and results here:
Expert Answer
Answer to Using the Class database, answer the following questions: 1. Create a stored procedure that for any student id entered, …