Problem 10: Establish a database view called Unshipped RowlettBikes Orders View that lists

the orders that have not been shipped. The view needs to contain the order ID, customer first

name, customer last name, and order date. Unshipped orders are signified by order_status = 1.

Then execute a SELECT query to verify the view.

Expected Output:

order_id first_name last_name

Kirkland

Aguilar

Shepard

Booth

Vinson

Espinoza

Mosley

Carter

1512 Jayne

1515

Elinore

1528 Aleta

1529

1539

1572 Garry

1597

Lolita

1601

Mozelle

Cleotilde

Merlene

order_date

2018-04-09

2018-04-10

2018-04-12

2018-04-12

2018-04-15

2018-04-22

2018-04-28

2018-04-29