CustomerID	CustomerName	City	State	CreditLimit
1000	Smith	Phoenix	AZ	2500
1001	Jones	St. Louis	MO	1500
1002	Jeffries	Atlanta	GA	4000
1003	Gilkey	Phoenix	AZ	5000
1004	Lankford	Phoenix	AZ	2000
1005	Zeile	Chicago	IL	2000
1006	Pagnozzi	Salt Lake City	UT	5000
1007	Arocha	Chicago	IL	1000
1008	Sepulveda	Jersey City	NJ	2500
1009	Puente	Pittsburgh	PA	2500
1010	Edmonds	Minneapolis	MN	2000
1011	Moates	Arlington	VA	1500
1012	Leo	Charlotte	NC	1500
1013	Warn	Austin	TX	2000
1014	Sacks	St. Petersburg	FL	3000
1015	Elders	Baton Rouge	LA	1500
1016	Hamaker	Lincoln	NB	1000
1017	Guillaume	Minneapolis	MN	4000
1018	Mallette	San Bernardino	CA	2000
1019	Wedell	Lubbock	TX	2000
1020	Bruckner	Milwaukee	WI	2000

ItemID	Description	SteCost	ListPrice	QuantityOnHand
1010	Blender	14	29.95	200
1015	Toaster	12	19.95	300
1020	Mixer	23	33.95	250
1025	Television	499	699.95	74
1030	Freezer	799	999.95	32
1035	Refrigerator	699	849.95	25
1040	Radio	45	79.97	100
1045	Clock	79	99.95	300
1050	Electric Knife	4	9.99	287
1055	Popcorn Popper	13	19.99	165
1060	Toaster Oven	9	23.95	55
1065	Vacuum	127	199.87	12

Invoice	SaleDate	SalesPerson	CustomerID	Amount
101	10/3/2018	Wilson	1000	1,549.90
102	10/5/2018	Mahomet	1003	299.85
103	10/5/2018	Jackson	1002	1,449.80
104	10/15/2018	Drezen	1000	799.90
105	10/15/2018	Martinez	1005	849.95
106	10/16/2018	Martinez	1007	99.95
107	10/29/2018	Mahomet	1002	2,209.74
108	11/3/2018	Martinez	1000	779.90
109	11/4/2018	Martinez	1002	319.88
110	11/4/2018	Drezen	1015	15.99
111	11/5/2018	Wilson	1014	67.90
112	11/8/2018	Martinez	1009	79.97
113	11/8/2018	Mahomet	1013	4,489.45
114	11/8/2018	Martinez	1011	1,649.85
115	11/10/2018	Martinez	1019	1,089.86
116	11/10/2018	Drezen	1001	47.90
117	11/11/2018	Martinez	1013	79.80
118	11/14/2018	Martinez	1013	1,399.90
119	11/16/2018	Martinez	1020	359.75
120	11/19/2018	Drezen	1005	165.75
121	11/20/2018	Mahomet	1017	999.95
122	11/21/2018	Martinez	1003	59.85
123	11/22/2018	Wilson	1012	99.75
124	11/25/2018	Mahomet	1014	139.91
125	11/25/2018	Wilson	1009	49.90
126	11/26/2018	Martinez	1004	135.79
127	11/26/2018	Wilson	1016	259.69
128	11/29/2018	Drezen	1009	247.77
129	12/1/2018	Jackson	1003	203.70
130	12/1/2018	Martinez	1019	79.97
131	12/3/2018	Mahomet	1004	199.95
132	12/5/2018	Drezen	1014	3,999.80
133	12/5/2018	Mahomet	1003	2,729.57
134	12/6/2018	Jackson	1003	19.95
135	12/6/2018	Martinez	1009	1,129.77
136	12/7/2018	Mahomet	1015	19.95
137	12/7/2018	Drezen	1006	1,666.92
138	12/10/2018	Martinez	1018	7,263.40
139	12/11/2018	Mahomet	1003	1,551.72
140	12/11/2018	Mahomet	1006	1,171.04
141	12/13/2018	Martinez	1020	79.97
142	12/13/2018	Drezen	1008	849.95
143	12/14/2018	Martinez	1019	2,899.55
144	12/14/2018	Mahomet	1002	717.46

Invoice	ItemID	Quantity	SellPrice
101	1025	1	699.95
101	1035	1	849.95
102	1045	3	99.95
103	1010	1	29.95
103	1015	1	19.95
103	1025	2	699.95
104	1025	1	699.95
104	1045	1	99.95
105	1035	1	849.95
106	1045	1	99.95
107	1030	1	999.95
107	1035	1	849.95
107	1040	2	79.97
107	1045	2	99.95
108	1025	1	689.95
108	1045	1	89.95
109	1040	4	79.97
110	1055	1	15.99
111	1020	2	33.95
112	1040	1	79.97
113	1010	1	29.95
113	1030	4	999.95
113	1050	2	9.99
113	1055	2	19.99
113	1065	2	199.87
114	1025	1	699.95
114	1035	1	849.95
114	1045	1	99.95
115	1035	1	849.95
115	1040	3	79.97
116	1060	2	23.95
117	1015	4	19.95
118	1025	2	699.95
119	1010	2	29.95
119	1045	3	99.95
120	1010	1	29.95
120	1020	4	33.95
121	1030	1	999.95
122	1015	3	19.95
123	1015	5	19.95
124	1040	3	79.97
125	1010	1	29.95
125	1015	1	19.95
126	1020	3	33.95
126	1050	1	9.99
126	1060	1	23.95
127	1015	5	19.95
127	1040	2	79.97
128	1060	2	23.95
128	1065	1	199.87
129	1020	6	33.95
130	1040	1	79.97
131	1045	1	99.95
132	1030	4	999.95
133	1015	5	19.95
133	1035	3	849.95
133	1040	1	79.97
134	1015	1	19.95
135	1010	3	29.95
135	1030	1	999.95
135	1050	2	9.99
135	1055	1	19.99
136	1015	1	19.95
137	1020	2	33.95
137	1045	4	99.95
137	1065	6	199.87
138	1015	2	19.95
138	1025	3	699.95
138	1035	6	849.95
138	1060	1	23.95
139	1025	2	699.95
139	1040	1	79.97
139	1060	3	23.95
140	1010	6	29.95
140	1040	4	79.97
140	1060	3	23.95
140	1065	3	199.87
141	1040	1	79.97
142	1035	1	849.95
143	1015	5	19.95
143	1025	4	699.95
144	1010	3	26.95
144	1020	2	30.95
144	1055	6	10.87
144	1060	5	21.95
144	1065	2	199.87

1. List Invoice, ItemID, Description, SellPrice, ListPrice, Quantity, and computer the Extension (SellPrice x Quantity) for all items sold where the SellPrice is different than the ListPrice. Sort by ItemID in descending order.
2. Computer the profit margin for each item sold. Calculate the profit margin as (SellPrice StdCost) / SellPrice. List Invoice, SaleDate, ItemID, SellPrice, Quantity, and computer ProfitMargin. Sortt by ProfitMargin in descending order.
3. Computer the profit for each line of the invoices. Calculate the profit as (SellPrice StdCost) x Quantity. List Invoice, SaleDate, ItemID, SellPrice, Quantity, and computed Profit. Sort by Invoice in ascending, then Profit in descending order.

Advanced queries:

1. How many sales transactions were made in October? Name your output column Num_of_Sales
2. How many customers live in Arizona? List the State and CountOfCustomers.
3. How many customers live in each state? List the State and CountOfCustomers. Sort the list alphabetically by State.
4. How much did each salesperson sell based on SalesAmount? List SalesPerson and TotalAmount. Sort from largest TotalAmount to smallest.
5. How many units of each item were sold? List ItemID, Description, and TotalSold. Sort on TotalSold in ascending order.
6. Compute a total for each invoice based on Quantity times SellPrice. Name your total InvoiceTotal. Display Invoices where InvoiceTotal does not equal Amount. List Invoice, SaleDate, SalesPerson, Amount, and InvoiceTotal.

Note: If no rows meet your criteria, consider changing the value of Amount for Invoice 101 to a different value to test your query.

PLEASE SHOW ANWSER IN ACCESS, PLEASE LINK ACCESS FILE