keep getting errors in my sequences, any help with this would be perfect.

Using MySQL Workbench:

3A) Create a stored procedure called MentoredStudents which will display student first and last names. Only students who are being mentored are to be selected. Sort the output by student last name, then first name. Paste this SQL in a Word document for later submission to Brightspace; specify this requirement number before the SQL (3a)

3B) Create a stored procedure called MentoringCount which will display the professor name and the number of students he/she is mentoring. Sort the output by the professor name. Paste the SQL in above noted Word document; specify this requirement number before the SQL (3b).

3C) Create a stored procedure called NonMentoringProfessors which will display professor name of those who are not mentoring (meaning, there is no record for them in the student_professor table). Use a subquery to determine the output. Sort the output by the professor name. Paste the SQL in above noted Word document; specify this requirement number before the SQL (3c).

3D) Execute the MentoredStudents stored procedure and capture a screen image of the entire desktop. Image should show the number of records being returned by the stored procedure from the MySQL Workbench Output window. Paste the screen image in above noted Word document; specify this requirement number before the SQL (3d).

3E) Execute the MentoringCount stored procedure and capture a screen image of the entire desktop. Image should show the number of records being returned by the stored procedure from the MySQL Workbench Output window. Paste the screen image in above noted Word document; specify this requirement number before the SQL (3e).

3F) Execute the NonMentoringProfessors stored procedure and capture a screen image of the entire desktop. Image should show the number of records being returned by the stored procedure from the MySQL Workbench Output window. Paste the screen image in above noted Word document; specify this requirement number before the SQL (3f).

4A) Backup one of the database you have created duirng this course. Note, when you get the the Object Selection tab (as shown in video), make sure to select only the database you want to backup.

4B) Execute this SQL, make sure to change databasename on third line to the database you are backing up

SELECT table_schema AS Database_Name, MIN(create_time) AS Creation_Time FROM information_schema.tables WHERE table_schema = 'databasename';

4C) Restore the database using the backup file you just created

4D) Execute this SQL, make sure to change databasename on third line to the database you are backing up

SELECT table_schema AS Database_Name, MIN(create_time) AS Creation_Time FROM information_schema.tables WHERE table_schema = 'databasename';

Tables and colums are

-professor - professorId, professorProgram, PhoneNo, Age, ProfessorName

-student - studentno, studentprogram, phoneno, age, firstname, lastname

-student_professor - student_professor_id, professorId, StudentNo, Mentor