Search for question
Question

Problem 3: Create a stored procedure that lists mountain bikes for a specified brand. 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 GetMountainBikesByBrand

@Brand VARCHAR (255)

AS

Then execute the following stored procedure call to get a list of the mountain bikes produced by

Haro

EXEC GetMountainBikesByBrand @Brand 'Haro' ;

Expected Output:

product_name

Haro Flightline One ST-2017

Haro Flightline Two 26 Plus - 2017

Haro Shift R3-2017

Haro SR 1.1-2017

Haro SR 1.2-2017

Haro SR 1.3-2017

model year list price

2017

2017

2017

2017

2017

2017

379.99

549.99

1469.99

539.99

869.99

1409.99

=

Fig: 1