Question: Please answer the three questions: 156 Chapter 30esson A) sou Language PROBLEMSOLVING EXERCISES to load the Outdoor Clubs & Product datab Run the script file
Please answer the three questions:

156 Chapter 30esson A) sou Language PROBLEMSOLVING EXERCISES to load the Outdoor Clubs & Product datab Run the script file outdoorDB v4.sql to exercises. block program unit that displays for each spori Ex3A-1. a OL of membership id, p date n membership details in the form For those sporting clubs that do not yet and values. should be ex3ai membership, "No unit as a script file with product anonymous block program displays Ex3A-2. create a block program unit that price attribute value. Save the product table, and a status text based on the with filename ex3a2. The rule anonymous block program unit as a script file categorizing the price status text display are: Price Status Price Range Low $5.00 Medium Between 5 and 20 High 20 The program unit output is as follows: Product Name Price Status Low Medium High Ex3A-3. create a PLUSQL anonymous block program unit that counts how many products lisedn the product table fall within the price range categories shown below. Save the PLSQL anonymous block program unit a scriptfile with flename ex3a3.The rule for categorizing price ranges are: Price Range Price Status
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
