l am not able to understand how to add my personl information to the student table and how to create stored procedure as below:

This is the requires information

USE COLLEGE;

as the database

and the table as below to create stored procedure to pass the in argument and out the result

[8] Create a stored procedure name Student_Add that takes arguments for LastName, FirstName, Sex, MajorlD, and DateOfBirth, and adds the person to the Student table. Your stored procedure should automatically set EnrolledDate to today's date and automatically create the email address from the student's name. You'll need to use the CONCAT function to create the email address in the form FirstLast@college.edu. 3. Call your stored procedure to add yourself as a student, and then run this SELECT statement to list out the new record. SELECT FROM WHERE student student, id (SELECT MAX(ID) FROM Student); =