Need help on this question with my sql code. Thank You Create a stored procedure namedprc_new_rental to insert new rows in the RENTAL table. The procedure shouldsatisfy the following conditions:a. The membership number will be provided as parameter.b. Use a count() function to verify that the membership number exits in theMEMBERSHIP table. If it does not exist, then a message should bedisplayed that the membership does not exist and no data should be writtento the database.c. If the membership does exist, then retrieve the membership balance anddisplay a message that the balance is the previous balance. (e.g., if themembership has a balance of 5.00, then display "previous balance: $5.00.)

A stored procedure called prc_new_rental has been developed in response to the request to help with the addition of new rows to the RENTAL database. The purpose of this operation is to fulfill the demands mentioned in the request, which include the need to validate membership presence in the MEMBERSHIP database and to supply a membership number as a parameter. When a membership cannot be located, an informational message is sent and no information is entered into the database. On the other hand, the process inserts the new rental record after retrieving and displaying the prior balance upon identification of a legitimate membership.Please refer to the following steps for the complete solution to the problem above.To meet the needs you've mentioned, you can develop a stored procedure in a database system like MySQL. Here is an example stored procedure called prc_new_rental that adds new rows to the RENTAL database, displays the previous balance, and verifies the existence of members :=1DELIMITER // 2 3CREATE PROCEDURE prc_new_rental(IN p_membership_number INT, IN p_rental_amount DECIMAL(10, 2)) 4BEGIN 5 DECLARE v_balance DECIMAL(10, 2); 6 7 -- Check if the membership exists 8 SELECT COUNT(*) INTO v_balance 9 FROM MEMBERSHIP 10 WHERE membership_number = p_membership_number; 11 12 IF v_balance = 0 THEN 13 SIGNAL SQLSTATE '45000' 14 SET MESSAGE_TEXT = 'Membership does not exist.'; 15 ELSE 16 -- Get the previous balance 17 SELECT balance INTO v_balance 18 FROM MEMBERSHIP 19 WHERE membership_number = p_membership_number; 20 21 -- Display the previous balance 22 SELECT CONCAT('Previous balance: $', FORMAT(v_balance, 2)) AS Message; 23 24 -- Update the membership balance with the new rental amount 25 UPDATE MEMBERSHIP 26 SET balance = v_balance - p_rental_amount 27 WHERE membership_number = p_membership_number; 28 29 -- Insert the rental record into the RENTAL table 30 INSERT INTO RENTAL (membership_number, rental_amount) 31 VALUES (p_membership_number, p_rental_amount); 32 END IF; 33END // 34 35DELIMITER ;Note : -- is used for commenting in SQL.Two parameters are required for this stored procedure: the membership number (p_membership_number) and the rental amount (p_rental_amount). It initially uses the COUNT function to see if the membership is present. If the membership is not found, an error message is displayed. In the event that the membership is found, the rental record is inserted into the RENTAL table, the prior balance is retrieved, shown, and updated with the new rental amount.This carefully designed stored procedure prioritizes data integrity and makes sure that users are aware of membership status and previous balance before completing the transaction. It provides a dependable and organized method for adding new rental entries. It effectively integrates the database processes required to meet the requirements.