--Only want answer to Question 2-4(question 2-2 is needed to answer 2-4)-- This needs to be in PL/SQL

Assignment 2-2: Creating a Flowchart The Brewbeans application needs a block that determines whether a customer is rated high, mid, or low based on his or her total purchases. The block needs to determine the rating and then display the results onscreen. The code rates the customer high if total purchases are greater than $200, mid if greater than $100, and low if $100 or lower. Develop a flowchart to outline the conditional processing steps needed for this block.

Assignment 2-4: Using CASE Statements Create a block using a CASE statement to perform the actions described in Assignment 2-2. Use a scalar variable for the total purchase amount, and initialize this variable to different values to test your block.