Problem 2: Create a stored procedure that lists the customers from a specified zip code. The

skeleton of the stored procedure is provided below.

CREATE PROCEDURE GetCustomersByZipCode

@ZipCode VARCHAR (5)

AS

Then execute the following stored procedure call to get the records of customers living in the

75115 zip code:

EXEC GetCustomersByZipCode @ZipCode ¹75115';

Expected Output:

customer_id first_name last_name phone email

Bobbie

Cecilia

Liliana

Bao

Sheml

Gena

64

687

913

1108

1134

1192

1203

1230

Foster

Camacho NULL

NULL bobbie foster@yahoo.com

cecilia.camacho@yahoo.com

NULL liliana.kem@yahoo.com

NULL bao.wade@gmail.com

shemil.alvarado@hotmail.com

NULL gena.owens@gmail.com

NULL

georgeann.rojas@msn.com

NULL jesus.burch@hotmail.com

Kerr

Wade

Alvarado NULL

Owens

Georgeann Rojas

Jesus

Burch

=

street

988 Pineknoll Ave.

682 Mountainview Rd.

3 Cherry Drive

7587 Church St.

9434 Cypress Court

43 Buckingham St.

691 Devon Ave.

7024 Squaw Creek Street

city state zip_code

Desoto TX 75115

Desoto TX 75115

Desoto TX

Desoto TX

Desoto TX

75115

75115

75115

Desoto TX

75115

Desoto TX 75115

Desoto TX 75115