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.
Exercise in MySQL. Use the my_guitar_shop database to do the following: Start with the program on slide 11 in the Chapter 13 Power Point. Make sure you can run the program as is. Clean up any squiggly red lines. There are bad characters. You will need to call the procedure test as in slide 4. […]
