Problem 1: Create a stored procedure that lists the last name, first name, and E-mail

address of the staff from all the company stores. The output needs to be in alphabetical

order based on last name then by first name. The skeleton of the stored procedure is

provided below.

CREATE PROCEDURE Get Company Staff List

AS

Then execute the following stored procedure call to get the staff listing:

EXEC GetCompany StaffList;

Expected Output:

last_name first name email

Boyer

marcelene.boyer@bikes.shop

Marcelene

Copeland Mireya mireya.copeland@bikes.shop

Daniel

Venita

venita.daniel@bikes.shop

David

jannette.david@bikes.shop

Jannette

Houston Bemardine bemardine.houston@bikes.shop

Jackson Fabiola fabiola jackson@bikes.shop

Serrano Genna

Layla

Terrell

Vargas Kali

Winnins Vimnie

genna.serrano@bikes.shop

layla.terrell@bikes.shop

kali.vargas@bikes.shop

vimie winnins@bikes shon