Problem $9$: Create a stored procedure that lists the stock quantity for each bike category at a specified store. The output must show the bike category and stock quantity value. The results need to be presented in ascending order based on bike category. The skeleton of the stored procedure is provided below.

CREATE PROCEDURE GetCategoryStockQuantityForStore

@StoreName VARCHAR$(255)$

AS

Then execute the following stored procedure call to get the bike category stock quantities for the Santa Cruz Bikes store:

EXEC GetCategoryStockQuantityForStore @StoreName$=$'Santa Cruz Bikes';

Expected Output:

Problem $10$: Create a stored procedure that presents the sales discount average and standard deviation for bike brands at or above a specified discount value. The output must show the brand names in alphabetical order along with the associated statistics. The skeleton of the stored procedure is provided below. $($Hint: The HAVING clause needs to be used.$)$

CREATE PROCEDURE GetBrandAverageSalesDiscountAboveValue

@Discount DECIMAL$(4,2)$

AS

Then execute the following stored procedure call to get the sales discount average and standard deviation values at or above $11\%(0\mathrm{.}11)$:

EXEC GetBrandAverageSalesDiscountAboveValue @Discount$=0\mathrm{.}11$;