Refer to Critical Thinking Assignment Option 2 in Module 2. Your tasks begin by generating and executing the SQL statements to create the Sales and Purchased Items tables. Next, you will develop and execute the SQL statements to populate the 2 database tables from the data in their respective tables in the Critical Thinking Assignment. Finally, you will write and execute queries to display all attributes (columns) and tuples (rows) in the 2 database tables.

Important reminder, refer to the instructions from Module 1 for creating database. This step must be completed before you can create and populate tables within the database.

The deliverables for this assignment are:

1. Screenprint after the database is created.
2. Screenprint after the 2 database tables are created.
3. Screenprint of the query results for each table.
4. A brief description of your key learnings from this assignment.

Sales Table

LastName	FirstName	Phone	InvoiceDate	InvoiceItem	Price	Tax	Total
Shire	Robert	206-524-2422	12/14/2017	Antique Desk	3000.00	249.00	3249.00
Shire	Robert	206-524-2422	12/14/2017	Antique Desk Chair	500.00	41.50	541.50
Goodyear	Katherine	206-524-3544	12/15/2017	Dining Table Linens	1000.00	83.00	1083.00
Bancroft	Chris	426-635-9788	12/15/2017	Candles	50.00	4.16	54.16
Griffith	John	206-524-4656	12/23/2017	Candles	45.00	3.74	48.74
Shire	Robert	206-524-2422	1/5/2018	Desk Lamp	250.00	20.75	270.75
Tierney	Doris	425-635-8677	1/10/2018	Dining Table Linens	750.00	62.25	812.25
Anderson	Donna	360-538-3544	1/12/2018	Book Shelf	250.00	20.75	270.75
Goodyear	Katherine	206-524-3544	1/15/2018	Antique Chair	1250.00	103.75	1353.75
Goodyear	Katherine	206-524-3544	1/15/2018	Antique Chair	1750.00	145.25	1895.25
Tierney	Doris	425-635-8677	1/25/2018	Antique Candle Holders	350.00	29.05	379.05

Purchased Items Table

PurchaseItem	PurchasePrice	Purchase Date	Vendor	Phone
Antique Desk	1800.00	11/7/2017	European Specialties	206-325-7868
Antique Desk	1750.00	11/7/2017	European Specialties	206-325-7868
Antique Candle Holders	210.00	11/7/2017	European Specialties	206-325-7868
Antique Candle Holders	200.00	11/7/2017	European Specialties	206-325-7868
Dining Table Linens	600.00	11/14/2017	Linen and Things	206-325-6755
Candles	30.00	11/14/2017	Linen and Things	206-325-6755
Desk Lamp	150.00	11/14/2017	Lamps and Lighting	206-325-8977
Floor Lamp	300.00	11/14/2017	Lamps and Lighting	206-325-8977
Dining Table Linens	450.00	11/21/2017	Linen and Things	206-325-6755
Candles	27.00	11/21/2017	Linen and Things	206-325-6755
Book Shelf	150.00	11/21/2017	Harrison, Denise	425-746-4332
Antique Desk	1000.00	11/28/2017	Lee, Andrew	425-746-5433
Antique Desk Chair	300.00	11/28/2017	Lee, Andrew	425-746-5433
Antique Chair	750.00	11/28/2017	New York Brokerage	206-325-9088
Antique Chair	1050.00	11/28/2017	New York Brokerage	206-325-9088