IP SESSION MA CIS485CookieExerc PHPSessionScripts cis485Exam03New PHP SESSIONMySQl Stores hosted cuny.edu/webapps/blackboard/content/listContent,jsp?course icd Purpose: Practice creation of stored procedures Instruction Use Users table to create stored procedures for the following information queries 1. Write a stored procedure to find the earliest registration date by a OUT parameter. (use mino stored procedure to find the registration date by a IN user id parameter and a OUT parameter. 3. Write a stored procedure to add a new user. Provide IN parameters of user.id, first email, pass and registration_date. 4. Write a stored procedure to delete a user by providing an IN user_id. 5. Write a stored procedure to retrieve all the records from users table? 6. Write a stored procedure to update the email of a user by an IN user, id and IN email para name, last ete Thing to submit: 1. All the stored procedure statements. 2. A screen shot for the successful execution of each stored procedure. Submit a Word file that contains all the results and screen shot. 2 Create the SP to change the register.php code as: Replacing Sq INSERT INTO users (first_name, last_name, email, pass, registration_ date) VALUES (Sfn, Sin, SHA1(Sp'), NOWO" with Sq"CALL register_proc('$fn', 'Sin', Se', "$p')" A ti