Please answer the questions from 3B-1 to 3B-4. Use SQL to answer the questions.

182 Chapter (Lesson PROBLEM SOLVING EXERCISES Run the script file outdoorDB v4. sal to load the outdoor Clubs & Product database to complete the following exercises, Ex3B-1. Create procedure "ex3b membership" that displays membership id, first nam last name, and city attribute values for all customers who have club membership. Save the procedure as a script with filename ex3bl E3B-2. Create a procedure "ex3b order details" that displays from the product order tab order id, order date, and total ribute values for an input customer id value. Include e, exception that maps the Oracle server emor for an invalid customer id input, and displ a message "Customer ID not correct. Try again Save the procedure as a script file with filename ex3b2 Ex3B-3. Create a procedure "ex3b membership status" hat receives an input Date value and displays from the club membership table, the membership id, customer first name, and customer last name attribute values along with a time status calculated value for the time remaining with respect to the input date, membership date and duration values. If the input date is beyond the membership time duration, a message should display "Membership has expired." Save the procedure as a script file with filename ex3b3. Ex3B-4. Create a procedure "ex3b membership duration" that displays membership id, duration, first name, last name, city attribute values for customers who have club membership, along with the name attribute value of the sporting club. The value of the sporting club name should be returned by a func "ex3b club name." Save the procedure as a script file with filename ex3b4 while save the function as ex3b4 clubname Ex3B-5. Add an attribut 182 Chapter (Lesson PROBLEM SOLVING EXERCISES Run the script file outdoorDB v4. sal to load the outdoor Clubs & Product database to complete the following exercises, Ex3B-1. Create procedure "ex3b membership" that displays membership id, first nam last name, and city attribute values for all customers who have club membership. Save the procedure as a script with filename ex3bl E3B-2. Create a procedure "ex3b order details" that displays from the product order tab order id, order date, and total ribute values for an input customer id value. Include e, exception that maps the Oracle server emor for an invalid customer id input, and displ a message "Customer ID not correct. Try again Save the procedure as a script file with filename ex3b2 Ex3B-3. Create a procedure "ex3b membership status" hat receives an input Date value and displays from the club membership table, the membership id, customer first name, and customer last name attribute values along with a time status calculated value for the time remaining with respect to the input date, membership date and duration values. If the input date is beyond the membership time duration, a message should display "Membership has expired." Save the procedure as a script file with filename ex3b3. Ex3B-4. Create a procedure "ex3b membership duration" that displays membership id, duration, first name, last name, city attribute values for customers who have club membership, along with the name attribute value of the sporting club. The value of the sporting club name should be returned by a func "ex3b club name." Save the procedure as a script file with filename ex3b4 while save the function as ex3b4 clubname Ex3B-5. Add an attribut