using mysql Without entering table IDs except to connect the tables, use subqueries to change Jedidiah Bugbee's quantity of Dress Shirts included on his March 21, 2018 invoice from 6 to 3.

table info:

Table Details for Customer

TABLE STRUCTURE

TABLE DATA

CREATE SCRIPT

INSERT SCRIPT

Table 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

TABLE STRUCTURE

TABLE DATA

CREATE SCRIPT

INSERT SCRIPT

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