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