Problem 5: Create a stored procedure that lists the top five priced bikes at a specified store.

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

presented in descending price order. The skeleton of the stored procedure is provided below.

CREATE PROCEDURE GetTopFive PricedBikesByStoreName

@StoreName VARCHAR(255)

AS

Then execute the following stored procedure call to get a list of the top five priced bikes at the

Baldwin Bikes store:

EXEC GetTopFive PricedBikesByStoreName @StoreName='Baldwin Bikes';

Expected Output:

product_name

Trek Domane SLR 9 Disc - 2018

Trek Domane SLR 8 Disc - 2018

Trek Silque SLR 8 Women's - 2017

Trek Domane SL Frameset - 2018

Trek Domane SL Frameset Women's - 2018

model year list_price

2018

11999.99

2018

7499.99

2017

6499.99

2018

6499.99

2018

6499.99