using mysql Create a view called invoice_summary. This view should display the invoice ID, date in, date out, description, quantity, and price. After creating this view, select from it while showing order summaries for those containing men's shirts where the date out was on or after October 1, 2017.

table info:

Table Details for Customer

TTable rows are editable. All changes are immediate! Click to insert a record.

customer_id

first_name

last_name

street

city

state

zipcode

phone

email

12

Kylie

Cleaton

0 Towne Court

Des Moines

IA

50393

515-156-1494

kcleatonb@somewhere.com

13

Table Details for Invoice

Field	Type	Null	Key	Default	Extra
invoice_id	int(11)	NO	PRI	NULL	auto_increment
date_in	date	NO		NULL
date_out	date	YES		NULL
customer_id	int(11)	NO	MUL	NULL

Constraint Name	Constraint Column(s)	Referenced Table	Referenced Column(s)	Update Rule	Delete Rule
invoice_fk	customer_id	customer	customer_id	RESTRICT	RESTRICT

Jedidiah

Bugbee

Table Details for Invoice Item

Field	Type	Null	Key	Default	Extra
invoice_id	int(11)	NO	PRI	NULL
item_id	int(11)	NO	PRI	NULL
quantity	int(5)	NO		NULL

Constraint Name	Constraint Column(s)	Referenced Table	Referenced Column(s)	Update Rule	Delete Rule
invoice_item_fk1	invoice_id	invoice	invoice_id	CASCADE	CASCADE
invoice_item_fk2	item_id	item	item_id	CASCADE	CASCADE

Table Details for Item

Field	Type	Null	Key	Default	Extra
item_id	int(11)	NO	PRI	NULL	auto_increment
description	blob	NO		NULL
price	double(8,2)	NO		NULL