Problem 6: Establish a database view called Company StaffListView that lists the last name,

first name, and E-mail address of the staff from all the company stores. Then execute a

SELECT query to verify the view.

Expected Output:

last_name first_name email

Jackson Fabiola fabiola jackson@bikes.shop

Copeland Mireya

Serrano Genna

mireya.copeland@bikes.shop

genna.serrano@bikes.shop

virgie.wiggins@bikes.shop

jannette.david@bikes.shop

Wiggins Virgie

David

Boyer

Daniel Venita

Vargas Kali

Terrell Layla

Houston Bemardine bemardine.houston@bikes.shop

Jannette

Marcelene marcelene.boyer@bikes.shop

venita.daniel@bikes.shop

kali.vargas@bikes.shop

layla.terrell@bikes.shop