USE lab10;

DELIMITER //
CREATE PROCEDURE RightStoredProcedure()
BEGIN
	SELECT student.FirstName, student.StudentProgram, professor.ProfessorName, professor.ProfessorProgram
		FROM professor
			RIGHT JOIN student
			ON professor.ProfessorProgram = student.StudentProgram;
END //
DELIMITER ;