Problem 7: Establish a database view called BuffaloCustomersView that lists the last name,

first name, and E-mail address of customers that live in the city of Buffalo, NY. Then execute a

SELECT query to verify the view.

Expected Output:

last_name first_name email

Latasha

Hays

Mckee Sarai

Decker Rubin

Evelina

Agnes

Lore

Byrd

Sims

Sykes

Barton

Anton

Bridges Chantell

Bush

Lamar

latasha.hays@hotmail.com

sarai.mckee@msn.com

rubin.decker@gmail.com

evelina.byrd@msn.com

agnes.sims@aol.com

lore.sykes@aol.com

anton.barton@msn.com

chantell.bridges@yahoo.com

lamar.bush@msn.com