Problem 4: Create a stored procedure that lists bikes within a specified price range. The output

must show the bike name, model year, and list price. The results need to be presented in

alphabetical order based on bike name. The skeleton of the stored procedure is provided

below.

CREATE PROCEDURE GetBikesByPriceRange

@MinPrice Decimal (10,2), @MaxPrice Decimal (10,2)

AS

Then execute the following stored procedure call to get a list of bikes priced between $6000 and

$12000:

EXEC GetBikesByPriceRange @MinPrice=6000, @MaxPrice=12000;

Expected Output:

product_name

Trek Domane SL Frameset - 2018

Trek Domane SL Frameset Women's - 2018

model year list_price

2018

6499.99

2018

6499.99