Write a script that creates and calls a stored procedure named test.

Databases

Exercise in MySQL.

Use the my_guitar_shop database to do the following:

  1. Start with the program on slide 11 in the Chapter 13 Power Point.
  2. Make sure you can run the program as is.
    1. Clean up any squiggly red lines. There are bad characters.
    2. You will need to call the procedure test as in slide 4.
    3. Hint: copy the USE and DROP from slide 3.
    4. Change the delimiter back to”;”.
  3. Change the procedure for my_guitar_shop as instructed below.
  4. Write a script that creates and calls a stored procedure named test. This stored procedure should use two variables to store (1) the count of all of the products in the Products table and (2) the average list price for those products. If the product count is greater than or equal to 7, the stored procedure should display a result set that displays the values of both variables. Otherwise, the procedure should display a result set that displays a message that says, “The number of products is less than 7”.
  5. Make sure to test both outcomes. Hint: change the comparison operator to test.

Follow syntax instructions: Statement and clauses are in all caps (anything in blue). Files and columns are in lower case. Indent continuing statements