SQL Candy Assignment

PLEASE READ ATTACHMENT FIRST FOR DETAILED INSTRUCTIONS AND SCREENSHOTS.

The details for this assignment are attached. Here are the basics:

Attachments:

· 2017_product_data_students-final.csv

· 2018_product_data_students-final.csv

· 2019_product_data_students-final.csv

· Candy_part_1_skeleton_for_students.SQL

Your company wants to merge its old product order data into a new data mart to facilitate analysis. You have been tasked with writing an ETL (extract, transform, and load) code sequence, and executing it on three years’ worth of order data.

In this assignment, you will produce SQL code which scrubs and imports each of the three years’ worth of data, and produces an output file called stagingTable.

Along with these instructions, there is another document, ‘Additional Clarification on the Week 6 Candy Assignment’. Please read that document carefully.

You should also read the ‘Data Notes’ in part 3 of this document. It is very important that you understand the data and how the data changes over the three years, so you can create a ‘stagingTable’ the effectively combines the data that might have been captured in different ways over the years.

Let’s get started!

Part A: Upload all the files you will need to SQLlite:

1. Import the file called “2017_product_data_students.csv” to SQLiteonline.com. When you import it, give it the table name “pd2017” (no quotes) and set the column name to “First line.”

2. Import “2018_product_data_students.csv” as “pd2018”

3. Import “2019_product_data_students.csv” as “pd2019”

4. If you SELECT * FROM pd2017, you should see something like the below screenshot. Note you should see all three of the import tables on the left, and the pd2017 data should match what is shown as selected.

Part B: Extract and Transform your data

Your job is to use SQL to perform an ETL which will accomplish the following: INSTRUCTIONS IN ATTACHMENT.

1. Start with the skeleton starter script we give you, attached to this assignment. Modify the CREATE TABLE command so the schema is as follows: SEE ATTACHMENT

2. Get the 2017 bit of the script working. SEE ATTACHMENT

3. Get the 2018 part of the script working. SEE ATTACHMENT

4. Get the 2019 part of the script working. SEE ATTACHMENT

5. The script will load it into one final table and call it stagingTable

6. Run the checksum script to verify you have the stagingTable calculated correctly.

7. Export your final output table under the name “XX_output_final.csv” where XX are your initials. To export this, you can just use the Export button on the SQLlite menu (it’s right next to the Import button.)

You should do this all in SQLlite. You should not export to Excel and do your manipulations in Excel.

Part C: 2017 Data Notes

Your order 2017 data is contained in the attached file, “2017_product_data_students.csv” and you should have imported it as “pd2017.” A sample of this file’s type of data is contained below in Table 1 Sample of order data from 2017. (Note your file may or may not have the same data in it.)

Your field definitions follow:

· Month: integer, corresponds to the month of the sale. For example, 5 = May.

· Country: text, should all be USA. (All data in this exercise should be USA.)

· Region: text, represents the regions within the country.

· State: text, USPS state abbreviations. Each state is within one region.

· Product: text. This is the name of a packaged food product.

· Per-unit price: integer. This represents the per-unit price in cents; for example, 300 indicates that Orange Creepies sell for $3.00 per package. (For the purposes of this exercise, disregard all currency formatting and just use 300 to represent $3.00.)

· Quantity: integer. This represents how many items were in that particular order. The first order here was for 49 packages of Orange Creepies.

· Order Total: integer. This is the per-unit price x the quantity. The first line here indicates that 300 x 49 = 14700 (or $147.00) was the price of the first order.

Table 1 Sample of order data from 2017 – SEE ATTACHMENT

2018 Data Notes:

Your order 2018 data is contained in the attached file, “2018_product_data_students.csv”

A sample of this file’s data is contained below as Table 2 Sample of order data from 2018. (Note your file may or may not have the same data in it.)

Your field definitions follow:

· Month: integer, corresponds to the month of the sale. For example, 5 = May.

· Region: text, represents the regions within the country.

· Customer_ID: integer, represents the customer’s unique Customer ID number.

· Product: text. This is the name of a packaged food product.

· Per-unit price: integer. This represents the per-unit price in cents; for example, 363 indicates that PearApple sells for $3.63 per package. (For the purposes of this exercise, you should disregard all currency formatting and just use 363 to represent $3.63.)

· Quantity_1: integer. This represents how many items were in the first shipment of that particular order. This year we had shipping problems, and could often not ship the entire order all at once. Orders were split into two shipments where necessary, and Quantity_1 reflects how many units were shipped first. (Assume all shipments were completed in the month listed, and that no shipments had the first shipment in one month and the second shipment in the subsequent month.)

· Quantity_2: integer. This represents how many items were in the second shipment of that particular order. A 0 indicates a second shipment was not necessary. To get the total number of items shipped, you need to add Quantity_1 and Quantity_2.

· The first line here reflects that PearApple has a first shipment of 25 units, and a second shipment of 92 unit, all within the month of January, for a total of 25 + 92 = 117 units.

Table 2 Sample of order data from 2018 – SEE ATTACHED

2019 Data Notes:

Your order 2019 data is contained in the attached file, “2019_product_data_students.csv.”

A sample of this file’s data is contained below as Table 3 Sample of order data from 2019. (Note your file may or may not have the same data in it.)

Your field definitions follow:

· Month: integer, corresponds to the month of the sale. For example, 5 = May.

· Country: text, represents the country of the customer. Should all be USA.

· Region: text, represents the regions within the country.

· State: USPS code for the 50 United States.

· Product: text. Same as previous years.

· Per-unit price: integer. This represents the per-unit price in cents; same as previous years.

· Quantity: This represents how many items were in that particular order. The first order here was for 95 packages of Only Pancakes.

· Order Subtotal: This represents the order subtotal, calculated as per-unit price x quantity. For example, the first order here reflects a per-unit price of 413 cents x 95 units, for a subtotal of 39,235 (or $392.35).

· Quantity Discount: This represents the new policy (effective January 1, 2019) that all orders 90 units and over will automatically earn a 10% discount. An order of 89 units does not earn the discount; an order of 90 units does earn the discount. All order discounts have been rounded to the nearest penny, so you can assume this field has no decimals in it. In the data below,

o Order 0, on the first line, of 95 Only Pancakes to Florida, did qualify for the Quantity Discount, because an order quantity of 95 exceeded the 90 threshold. The Quantity Discount has been computed as 3924, or 10% of 39235. In this case, the final order total would be 39,235 – 3,924 = 35,311 (or $353.11).

o Order 4, on the fifth line, of 31 Future Toasts to North Carolina, did not qualify for the Quantity Discount. Therefore, the Order total would simply be the Order subtotal.

Table 3 Sample of order data from 2019 – SEE ATTACHED

Part D: Check Your Own Work

1. You can run the following SQL code on your staging table. There is nothing to turn in from this bit. It should yield the following first few rows:

Select region, yearint, monthInt, count(*) from stagingTable where monthInt = 5 group by region, yearInt, monthInt;

2. You can also run the following code to debug. You should get the following rows:

Select yearInt, monthInt, state, customer_id, product_name, orderTotal from stagingTable

where product_name = 'Big Waffle' and monthint=4

order by product_name, yearInt, monthInt, state, customer_id, orderTotal;

Now that you’ve debugged your code, it’s time to get a checksum! Run the following code to get a checksum. The checksum will be a number. Put this checksum number on the top of your homework. See table below for help with your CHECKSUM result.

select sum(yearInt * monthInt * orderTotal)%2341 as checksum from stagingTable;

3. Once you get the result of your CHECKSUM look at table below for ways to troubleshoot any issues with your ETL statements. SEE ATTACHMENT

TURN IN:

1. Your output file, called “XX_output_final.csv” where XX are your initials.

2. All the SQL code you used to execute this.

3. A document that contains

a. CHECKSUM: XXX where XXX is the checksum number produced. Put this in big font right on the top.

b. A one page outline of your ETL process. Which functions did you use, and what logic did you follow? This should be at the level that your boss, who has an MBA but not an IT/database background, can follow it. Do not use “computer-ese” here; use regular business English.

	Month	Country	Region	State	Product	Per-Unit Price	Quantity	Order Subtotal	Quantity Discount
0	9	USA	South	FL	Only Pancakes	413	95	39235	3924
1	6	USA	West	HI	Big Waffle	268	93	24924	2492
2	5	USA	Northeast	RI	Grey Gummies	446	95	42370	4237
3	9	USA	Midwest	NE	Funky Pops	380	100	38000	3800
4	11	USA	South	NC	Future Toast	253	31	7843	0
5	8	USA	West	WA	Mr Greens	447	76	33972	0
6	8	USA	South	MD	Giant Gummies	347	93	32271	3227
7	1	USA	South	TN	Power Gels	193	11	2123	0
8	1	USA	South	FL	Red Hot Chili Peppers	233	24	5592	0
9	12	USA	South	DE	Nap Be Gone	500	67	33500	0
10	2	USA	Northeast	MA	Cheezos	372	63	23436	0
11	1	USA	South	NC	GMO Guardian	176	77	13552	0
12	4	USA	South	DE	Only Pancakes	413	86	35518	0
13	3	USA	South	KY	Rotpunkt	220	20	4400	0
14	2	USA	Midwest	IL	Red Hot Chili Peppers	233	82	19106	0
15	8	USA	Midwest	IL	Panda Gummies	104	33	3432	0
16	11	USA	Midwest	NE	Yellow Zonkers	134	29	3886	0
17	7	USA	West	CA	Grey Gummies	446	97	43262	4326
18	11	USA	South	NC	Future Toast	253	93	23529	2353
19	10	USA	Midwest	MO	Red Hot Chili Peppers	233	77	17941	0
20	12	USA	South	KY	Orange Creepies	300	88	26400	0
21	4	USA	West	CA	Big Waffle	268	7	1876	0
22	3	USA	West	NV	Cheezos	372	77	28644	0
23	7	USA	West	OR	Power Gels	193	15	2895	0
24	2	USA	Northeast	VT	PearApple	363	57	20691	0
25	1	USA	South	NC	GMO Guardian	176	35	6160	0
26	3	USA	South	FL	Meat B Gone	495	34	16830	0
27	9	USA	South	TN	Yellow Zonkers	134	43	5762	0
28	1	USA	West	CA	Ultra-Salty Chips	454	34	15436	0
29	10	USA	South	MD	Farm Fresh	365	14	5110	0
30	6	USA	South	TN	Red Rock Candy	189	55	10395	0
31	6	USA	West	WA	Panda Gummies	104	19	1976	0
32	6	USA	South	MD	Meat B Gone	495	91	45045	4505
33	12	USA	West	CA	GMO Guardian	176	46	8096	0
34	4	USA	South	NC	Big Waffle	268	83	22244	0
35	1	USA	South	TN	Mr Greens	447	17	7599	0
36	4	USA	South	MD	Meat B Gone	495	54	26730	0
37	8	USA	South	SC	Purple Pain	105	12	1260	0
38	4	USA	South	FL	Crocodile Tears	143	40	5720	0
39	4	USA	West	CA	Big Waffle	268	2	536	0
40	2	USA	Northeast	VT	Big Waffle	268	68	18224	0
41	9	USA	Northeast	MA	Ultra-Salty Chips	454	29	13166	0
42	10	USA	West	CA	Funky Pops	380	31	11780	0
43	3	USA	South	TN	Farm Fresh	365	43	15695	0
44	12	USA	South	MD	Orange Creepies	300	100	30000	3000
45	6	USA	South	DE	Mr Greens	447	33	14751	0
46	1	USA	Northeast	MA	Power Gels	193	63	12159	0
47	11	USA	South	FL	Only Pancakes	413	65	26845	0
48	5	USA	West	OR	Farm Fresh	365	79	28835	0
49	2	USA	West	AZ	Farm Fresh	365	36	13140	0
50	11	USA	South	FL	Just The Fruit	160	85	13600	0
51	12	USA	Midwest	NE	Organiks	257	23	5911	0
52	4	USA	West	HI	Big Waffle	268	87	23316	0
53	7	USA	South	MD	Just The Fruit	160	27	4320	0
54	4	USA	South	DE	Rotpunkt	220	88	19360	0
55	12	USA	West	AZ	Mr Greens	447	42	18774	0
56	7	USA	West	NV	Meat B Gone	495	38	18810	0
57	3	USA	West	OR	Red Rock Candy	189	68	12852	0
58	3	USA	West	OR	Ultra-Salty Chips	454	89	40406	0
59	5	USA	Midwest	NE	Grey Gummies	446	12	5352	0
60	11	USA	South	FL	Panda Gummies	104	96	9984	998
61	5	USA	Midwest	MO	Red Rock Candy	189	77	14553	0
62	3	USA	West	NV	Just The Fruit	160	40	6400	0
63	3	USA	Northeast	MA	Purple Pain	105	3	315	0
64	2	USA	South	NC	Only Pancakes	413	66	27258	0
65	11	USA	West	ID	GMO Guardian	176	30	5280	0
66	3	USA	Northeast	RI	Yellow Zonkers	134	16	2144	0
67	3	USA	Northeast	MA	Giant Gummies	347	7	2429	0
68	12	USA	West	WA	Yellow Zonkers	134	49	6566	0
69	10	USA	West	WA	Purple Pain	105	9	945	0
70	12	USA	Northeast	RI	Red Hot Chili Peppers	233	17	3961	0
71	7	USA	West	AZ	Giant Gummies	347	68	23596	0
72	9	USA	Midwest	NE	Red Rock Candy	189	8	1512	0
73	11	USA	South	SC	Future Toast	253	98	24794	2479
74	1	USA	West	AZ	Mr Greens	447	74	33078	0
75	3	USA	South	MD	Mr Greens	447	13	5811	0
76	10	USA	South	NC	Power Gels	193	96	18528	1853
77	1	USA	West	OR	Rotpunkt	220	58	12760	0
78	6	USA	South	TN	Grey Gummies	446	72	32112	0
79	3	USA	West	OR	Mr Greens	447	73	32631	0
80	2	USA	West	CA	Giant Gummies	347	25	8675	0
81	4	USA	Midwest	MO	PearApple	363	4	1452	0
82	12	USA	Northeast	RI	Big Waffle	268	25	6700	0
83	6	USA	Northeast	VT	Just The Fruit	160	17	2720	0
84	10	USA	Midwest	MI	Grey Gummies	446	2	892	0
85	4	USA	South	MD	Future Toast	253	65	16445	0
86	7	USA	South	TN	Purple Pain	105	41	4305	0
87	1	USA	West	WA	Mr Greens	447	98	43806	4381
88	5	USA	South	DE	PearApple	363	39	14157	0
89	11	USA	Midwest	NE	Panda Gummies	104	2	208	0
90	8	USA	Northeast	MA	PearApple	363	65	23595	0
91	12	USA	South	MD	Ultra-Salty Chips	454	16	7264	0
92	11	USA	West	WA	Just The Fruit	160	78	12480	0
93	9	USA	South	FL	Organiks	257	100	25700	2570
94	9	USA	South	TN	Ultra-Salty Chips	454	76	34504	0
95	5	USA	South	FL	Nap Be Gone	500	74	37000	0
96	12	USA	West	CA	Organiks	257	73	18761	0
97	8	USA	Midwest	IL	Cheezos	372	84	31248	0
98	4	USA	Midwest	MO	PearApple	363	26	9438	0
99	7	USA	South	DE	Organiks	257	68	17476	0
100	9	USA	South	TN	Green Lightning	161	36	5796	0
101	11	USA	Northeast	VT	PearApple	363	69	25047	0
102	12	USA	South	SC	Farm Fresh	365	64	23360	0
103	6	USA	South	FL	PearApple	363	42	15246	0
104	8	USA	Midwest	MI	Funky Pops	380	79	30020	0
105	6	USA	South	NC	Yellow Zonkers	134	25	3350	0
106	9	USA	West	WA	Mr Greens	447	94	42018	4202
107	4	USA	Midwest	MO	Green Lightning	161	91	14651	1465
108	2	USA	West	CA	Future Toast	253	5	1265	0
109	1	USA	South	MD	Power Gels	193	86	16598	0
110	5	USA	West	OR	Orange Creepies	300	76	22800	0
111	11	USA	Midwest	MO	Purple Pain	105	12	1260	0
112	2	USA	Midwest	NE	Red Rock Candy	189	5	945	0
113	1	USA	South	FL	GMO Guardian	176	75	13200	0
114	1	USA	Northeast	MA	Red Hot Chili Peppers	233	20	4660	0
115	6	USA	Northeast	MA	Orange Creepies	300	58	17400	0
116	10	USA	South	KY	Giant Gummies	347	85	29495	0
117	5	USA	South	NC	GMO Guardian	176	39	6864	0
118	7	USA	South	TN	Purple Pain	105	4	420	0
119	5	USA	West	OR	Only Pancakes	413	89	36757	0
120	3	USA	South	FL	Orange Creepies	300	33	9900	0
121	5	USA	West	CA	Nap Be Gone	500	26	13000	0
122	5	USA	Northeast	RI	Mr Greens	447	71	31737	0
123	7	USA	South	FL	Future Toast	253	80	20240	0
124	9	USA	South	DE	PearApple	363	2	726	0
125	3	USA	South	DE	GMO Guardian	176	7	1232	0
126	1	USA	Midwest	MI	GMO Guardian	176	27	4752	0
127	5	USA	South	NC	Giant Gummies	347	76	26372	0
128	11	USA	South	FL	Organiks	257	39	10023	0
129	2	USA	Midwest	IL	Grey Gummies	446	65	28990	0
130	12	USA	South	KY	Grey Gummies	446	31	13826	0
131	3	USA	West	ID	Red Rock Candy	189	65	12285	0
132	3	USA	West	ID	Funky Pops	380	53	20140	0
133	4	USA	South	TN	Just The Fruit	160	4	640	0
134	7	USA	Midwest	IL	Future Toast	253	17	4301	0
135	5	USA	Midwest	MI	GMO Guardian	176	36	6336	0
136	10	USA	West	AZ	Green Lightning	161	67	10787	0
137	9	USA	West	HI	Purple Pain	105	17	1785	0
138	7	USA	Northeast	RI	Yellow Zonkers	134	100	13400	1340
139	12	USA	Northeast	MA	Rotpunkt	220	33	7260	0
140	12	USA	West	HI	Green Lightning	161	40	6440	0
141	4	USA	Midwest	NE	Rotpunkt	220	86	18920	0
142	6	USA	South	MD	Orange Creepies	300	8	2400	0
143	1	USA	West	CA	Organiks	257	80	20560	0
144	6	USA	Midwest	NE	Panda Gummies	104	79	8216	0
145	9	USA	South	MD	Big Waffle	268	28	7504	0
146	11	USA	Northeast	VT	Orange Creepies	300	86	25800	0
147	12	USA	West	NV	Farm Fresh	365	63	22995	0
148	6	USA	West	ID	Mr Greens	447	100	44700	4470
149	2	USA	Midwest	NE	Rotpunkt	220	23	5060	0
150	8	USA	West	WA	Rotpunkt	220	78	17160	0
151	11	USA	South	FL	Mr Greens	447	45	20115	0
152	10	USA	South	TN	Orange Creepies	300	55	16500	0
153	8	USA	Northeast	VT	Future Toast	253	46	11638	0
154	9	USA	West	OR	PearApple	363	42	15246	0
155	4	USA	South	FL	Red Rock Candy	189	64	12096	0
156	6	USA	Midwest	MI	Nap Be Gone	500	88	44000	0
157	4	USA	South	KY	Organiks	257	32	8224	0
158	2	USA	South	SC	Future Toast	253	83	20999	0
159	6	USA	South	DE	Big Waffle	268	54	14472	0
160	9	USA	Midwest	NE	Just The Fruit	160	94	15040	1504
161	11	USA	South	TN	Grey Gummies	446	45	20070	0
162	5	USA	South	NC	Nap Be Gone	500	88	44000	0
163	6	USA	West	HI	Green Lightning	161	78	12558	0
164	10	USA	West	WA	Farm Fresh	365	10	3650	0
165	12	USA	South	SC	Crocodile Tears	143	68	9724	0
166	6	USA	Northeast	MA	Big Waffle	268	17	4556	0
167	7	USA	South	MD	Yellow Zonkers	134	29	3886	0
168	12	USA	South	TN	Purple Pain	105	38	3990	0
169	10	USA	Midwest	MO	Cheezos	372	99	36828	3683
170	8	USA	South	KY	GMO Guardian	176	12	2112	0
171	5	USA	Midwest	MO	Green Lightning	161	64	10304	0
172	4	USA	South	MD	Orange Creepies	300	28	8400	0
173	9	USA	South	FL	PearApple	363	57	20691	0
174	1	USA	Northeast	VT	Cheezos	372	73	27156	0
175	7	USA	Northeast	VT	Cheezos	372	46	17112	0
176	11	USA	South	FL	PearApple	363	94	34122	3412
177	6	USA	Midwest	MI	Giant Gummies	347	48	16656	0
178	8	USA	South	NC	Only Pancakes	413	60	24780	0
179	1	USA	Midwest	MI	Rotpunkt	220	39	8580	0
180	10	USA	South	TN	Funky Pops	380	64	24320	0
181	3	USA	West	WA	Rotpunkt	220	58	12760	0
182	8	USA	Northeast	MA	Crocodile Tears	143	68	9724	0
183	11	USA	South	FL	Big Waffle	268	42	11256	0
184	2	USA	West	AZ	Cheezos	372	81	30132	0
185	2	USA	West	NV	Future Toast	253	89	22517	0
186	5	USA	Northeast	MA	Meat B Gone	495	94	46530	4653
187	7	USA	Midwest	MO	Yellow Zonkers	134	61	8174	0
188	9	USA	South	TN	Green Lightning	161	87	14007	0
189	7	USA	West	WA	Purple Pain	105	24	2520	0
190	9	USA	West	CA	Panda Gummies	104	20	2080	0
191	6	USA	West	HI	Giant Gummies	347	74	25678	0
192	2	USA	South	FL	Just The Fruit	160	73	11680	0
193	5	USA	Northeast	VT	Cheezos	372	81	30132	0
194	3	USA	Northeast	RI	Big Waffle	268	70	18760	0
195	6	USA	South	MD	Panda Gummies	104	40	4160	0
196	10	USA	South	TN	Funky Pops	380	97	36860	3686
197	5	USA	South	KY	Only Pancakes	413	7	2891	0
198	10	USA	South	FL	Red Hot Chili Peppers	233	68	15844	0
199	4	USA	South	SC	Farm Fresh	365	42	15330	0
200	1	USA	South	FL	PearApple	363	7	2541	0
201	1	USA	South	NC	Crocodile Tears	143	7	1001	0
202	1	USA	West	NV	Orange Creepies	300	47	14100	0
203	12	USA	Midwest	IL	Crocodile Tears	143	57	8151	0
204	5	USA	West	AZ	Farm Fresh	365	22	8030	0
205	6	USA	West	AZ	Rotpunkt	220	23	5060	0
206	7	USA	Midwest	MI	Orange Creepies	300	71	21300	0
207	5	USA	South	KY	Crocodile Tears	143	16	2288	0
208	12	USA	South	TN	Crocodile Tears	143	23	3289	0
209	9	USA	South	TN	Ultra-Salty Chips	454	96	43584	4358
210	1	USA	West	AZ	GMO Guardian	176	60	10560	0
211	6	USA	Midwest	IL	Red Rock Candy	189	66	12474	0
212	10	USA	Northeast	RI	Green Lightning	161	9	1449	0
213	12	USA	Midwest	MI	Green Lightning	161	52	8372	0
214	5	USA	South	FL	Just The Fruit	160	2	320	0
215	5	USA	Midwest	MO	Rotpunkt	220	85	18700	0
216	9	USA	South	KY	Power Gels	193	68	13124	0
217	7	USA	South	SC	Orange Creepies	300	62	18600	0
218	6	USA	Midwest	MO	Purple Pain	105	96	10080	1008
219	8	USA	West	HI	Cheezos	372	89	33108	0
220	12	USA	South	TN	Giant Gummies	347	11	3817	0
221	2	USA	West	OR	Red Rock Candy	189	3	567	0
222	3	USA	Midwest	MI	Big Waffle	268	19	5092	0
223	8	USA	Midwest	MO	Grey Gummies	446	81	36126	0
224	2	USA	Midwest	MO	Farm Fresh	365	74	27010	0
225	7	USA	West	NV	Nap Be Gone	500	18	9000	0
226	4	USA	West	ID	PearApple	363	14	5082	0
227	10	USA	West	AZ	Yellow Zonkers	134	37	4958	0
228	5	USA	South	TN	GMO Guardian	176	93	16368	1637
229	8	USA	South	MD	Funky Pops	380	97	36860	3686
230	8	USA	Northeast	MA	Organiks	257	68	17476	0
231	1	USA	Midwest	IL	Cheezos	372	74	27528	0
232	7	USA	Northeast	MA	Only Pancakes	413	6	2478	0
233	4	USA	South	NC	Orange Creepies	300	3	900	0
234	6	USA	South	TN	Panda Gummies	104	59	6136	0
235	12	USA	Midwest	MO	Power Gels	193	42	8106	0
236	1	USA	Midwest	MI	Big Waffle	268	20	5360	0
237	5	USA	South	DE	Ultra-Salty Chips	454	70	31780	0
238	9	USA	Northeast	MA	Organiks	257	17	4369	0
239	4	USA	South	TN	Grey Gummies	446	61	27206	0
240	10	USA	West	HI	Purple Pain	105	6	630	0
241	2	USA	Midwest	NE	Only Pancakes	413	35	14455	0
242	9	USA	West	NV	Rotpunkt	220	5	1100	0
243	4	USA	South	FL	Crocodile Tears	143	88	12584	0
244	5	USA	South	FL	Future Toast	253	72	18216	0
245	10	USA	Midwest	MO	Only Pancakes	413	26	10738	0
246	3	USA	South	SC	Orange Creepies	300	81	24300	0
247	6	USA	South	FL	Crocodile Tears	143	76	10868	0
248	5	USA	South	FL	Just The Fruit	160	24	3840	0
249	12	USA	Midwest	MO	Future Toast	253	15	3795	0
250	4	USA	West	NV	Organiks	257	10	2570	0
251	11	USA	South	NC	Cheezos	372	87	32364	0
252	5	USA	West	ID	Rotpunkt	220	84	18480	0
253	12	USA	West	NV	Panda Gummies	104	96	9984	998
254	4	USA	West	WA	Yellow Zonkers	134	24	3216	0
255	1	USA	South	FL	Giant Gummies	347	87	30189	0
256	4	USA	West	WA	GMO Guardian	176	96	16896	1690
257	1	USA	South	DE	Meat B Gone	495	96	47520	4752
258	2	USA	Midwest	MO	Organiks	257	98	25186	2519
259	4	USA	West	CA	Red Hot Chili Peppers	233	14	3262	0
260	9	USA	West	AZ	Meat B Gone	495	88	43560	0
261	2	USA	Northeast	VT	Mr Greens	447	87	38889	0
262	8	USA	South	DE	Yellow Zonkers	134	62	8308	0
263	7	USA	West	OR	Farm Fresh	365	55	20075	0
264	10	USA	Northeast	MA	Rotpunkt	220	80	17600	0
265	6	USA	Northeast	RI	Grey Gummies	446	41	18286	0
266	10	USA	Midwest	MO	Farm Fresh	365	71	25915	0
267	6	USA	Midwest	NE	Giant Gummies	347	21	7287	0
268	9	USA	South	SC	PearApple	363	13	4719	0
269	4	USA	South	DE	Rotpunkt	220	2	440	0
270	6	USA	Midwest	NE	Mr Greens	447	42	18774	0
271	3	USA	Northeast	MA	Giant Gummies	347	68	23596	0
272	10	USA	Midwest	MO	Ultra-Salty Chips	454	37	16798	0
273	2	USA	South	MD	Crocodile Tears	143	17	2431	0
274	9	USA	Midwest	MI	PearApple	363	46	16698	0
275	4	USA	West	WA	Mr Greens	447	11	4917	0
276	7	USA	South	NC	Funky Pops	380	15	5700	0
277	4	USA	West	ID	Rotpunkt	220	87	19140	0
278	2	USA	Midwest	NE	Farm Fresh	365	89	32485	0
279	10	USA	Midwest	MO	Orange Creepies	300	65	19500	0
280	8	USA	South	FL	Only Pancakes	413	59	24367	0
281	3	USA	Northeast	VT	Just The Fruit	160	45	7200	0
282	6	USA	Northeast	VT	GMO Guardian	176	19	3344	0
283	11	USA	West	AZ	Red Rock Candy	189	29	5481	0
284	5	USA	South	TN	Farm Fresh	365	85	31025	0
285	2	USA	South	SC	Red Rock Candy	189	19	3591	0
286	7	USA	South	NC	Crocodile Tears	143	25	3575	0
287	3	USA	West	CA	Green Lightning	161	62	9982	0
288	12	USA	Northeast	RI	GMO Guardian	176	28	4928	0
289	5	USA	Midwest	NE	Future Toast	253	70	17710	0
290	4	USA	Midwest	NE	Orange Creepies	300	13	3900	0
291	1	USA	South	MD	Future Toast	253	83	20999	0
292	11	USA	South	FL	Power Gels	193	17	3281	0
293	11	USA	West	HI	PearApple	363	38	13794	0
294	9	USA	South	MD	Farm Fresh	365	22	8030	0
295	6	USA	West	NV	Only Pancakes	413	100	41300	4130
296	2	USA	South	MD	Green Lightning	161	68	10948	0
297	11	USA	South	MD	Mr Greens	447	72	32184	0
298	3	USA	South	KY	Crocodile Tears	143	34	4862	0
299	3	USA	West	NV	Organiks	257	74	19018	0
300	3	USA	Midwest	MO	Panda Gummies	104	71	7384	0
301	7	USA	West	OR	Power Gels	193	28	5404	0
302	11	USA	South	KY	Grey Gummies	446	13	5798	0
303	9	USA	Midwest	IL	Power Gels	193	42	8106	0
304	12	USA	West	NV	Red Hot Chili Peppers	233	66	15378	0
305	3	USA	South	TN	Only Pancakes	413	43	17759	0
306	10	USA	Midwest	MO	Giant Gummies	347	64	22208	0
307	1	USA	South	SC	Green Lightning	161	29	4669	0
308	4	USA	West	OR	PearApple	363	2	726	0
309	8	USA	South	TN	Funky Pops	380	94	35720	3572
310	8	USA	South	FL	GMO Guardian	176	11	1936	0
311	11	USA	West	WA	Green Lightning	161	97	15617	1562
312	9	USA	South	FL	Red Hot Chili Peppers	233	59	13747	0
313	3	USA	South	MD	Ultra-Salty Chips	454	72	32688	0
314	3	USA	West	HI	Purple Pain	105	66	6930	0
315	11	USA	South	SC	Power Gels	193	4	772	0
316	11	USA	South	TN	Purple Pain	105	79	8295	0
317	3	USA	Midwest	MI	Rotpunkt	220	28	6160	0
318	12	USA	South	DE	Big Waffle	268	98	26264	2626
319	7	USA	West	OR	Nap Be Gone	500	97	48500	4850
320	6	USA	South	MD	Orange Creepies	300	26	7800	0
321	6	USA	South	FL	Farm Fresh	365	66	24090	0
322	4	USA	Midwest	MI	Crocodile Tears	143	43	6149	0
323	4	USA	Midwest	NE	Rotpunkt	220	33	7260	0
324	9	USA	Midwest	MO	Just The Fruit	160	61	9760	0
325	5	USA	South	DE	Giant Gummies	347	38	13186	0
326	7	USA	West	WA	Just The Fruit	160	8	1280	0
327	4	USA	West	HI	Farm Fresh	365	11	4015	0
328	8	USA	West	ID	Big Waffle	268	37	9916	0
329	4	USA	West	NV	Future Toast	253	42	10626	0
330	11	USA	South	MD	Yellow Zonkers	134	37	4958	0
331	5	USA	South	MD	Green Lightning	161	47	7567	0
332	9	USA	Midwest	MO	Big Waffle	268	71	19028	0
333	6	USA	South	MD	Ultra-Salty Chips	454	8	3632	0
334	4	USA	Northeast	RI	Panda Gummies	104	1	104	0
335	9	USA	West	WA	Power Gels	193	85	16405	0
336	8	USA	West	OR	Big Waffle	268	97	25996	2600
337	10	USA	South	NC	Grey Gummies	446	75	33450	0
338	6	USA	West	OR	Rotpunkt	220	77	16940	0
339	4	USA	West	CA	Farm Fresh	365	42	15330	0
340	6	USA	South	FL	Power Gels	193	21	4053	0
341	10	USA	West	AZ	Farm Fresh	365	91	33215	3322
342	9	USA	South	DE	Grey Gummies	446	83	37018	0
343	12	USA	Midwest	IL	Green Lightning	161	66	10626	0
344	4	USA	Midwest	NE	Only Pancakes	413	55	22715	0
345	1	USA	West	ID	Panda Gummies	104	75	7800	0
346	1	USA	Midwest	NE	Red Hot Chili Peppers	233	49	11417	0
347	8	USA	South	SC	Panda Gummies	104	18	1872	0
348	5	USA	South	MD	GMO Guardian	176	8	1408	0
349	5	USA	South	MD	Yellow Zonkers	134	2	268	0
350	2	USA	Northeast	RI	Green Lightning	161	45	7245	0
351	10	USA	Northeast	RI	Red Rock Candy	189	19	3591	0
352	8	USA	West	ID	Future Toast	253	70	17710	0
353	8	USA	Midwest	NE	Organiks	257	33	8481	0
354	11	USA	West	AZ	PearApple	363	58	21054	0
355	5	USA	West	CA	Panda Gummies	104	95	9880	988
356	8	USA	Midwest	IL	Giant Gummies	347	68	23596	0
357	1	USA	Midwest	IL	Orange Creepies	300	10	3000	0
358	4	USA	South	MD	Power Gels	193	27	5211	0
359	2	USA	South	FL	PearApple	363	84	30492	0
360	1	USA	West	OR	Orange Creepies	300	59	17700	0
361	9	USA	Midwest	IL	Mr Greens	447	66	29502	0
362	4	USA	West	NV	Grey Gummies	446	72	32112	0
363	7	USA	South	MD	Mr Greens	447	12	5364	0
364	12	USA	West	CA	Crocodile Tears	143	7	1001	0
365	3	USA	West	HI	Just The Fruit	160	34	5440	0
366	2	USA	West	NV	Nap Be Gone	500	57	28500	0
367	10	USA	South	TN	Just The Fruit	160	35	5600	0
368	2	USA	West	CA	Orange Creepies	300	76	22800	0
369	9	USA	Midwest	MO	Crocodile Tears	143	5	715	0
370	5	USA	South	FL	Giant Gummies	347	93	32271	3227
371	12	USA	South	NC	PearApple	363	16	5808	0
372	12	USA	West	OR	Just The Fruit	160	33	5280	0
373	5	USA	South	FL	Mr Greens	447	16	7152	0
374	6	USA	South	FL	Crocodile Tears	143	7	1001	0
375	12	USA	West	AZ	PearApple	363	44	15972	0
376	9	USA	Northeast	VT	Grey Gummies	446	61	27206	0
377	5	USA	West	ID	Funky Pops	380	76	28880	0
378	6	USA	South	MD	Ultra-Salty Chips	454	56	25424	0
379	8	USA	South	KY	Ultra-Salty Chips	454	3	1362	0
380	3	USA	West	OR	Rotpunkt	220	55	12100	0
381	6	USA	West	HI	Orange Creepies	300	67	20100	0
382	9	USA	Midwest	NE	Future Toast	253	76	19228	0
383	12	USA	West	OR	Purple Pain	105	91	9555	956
384	2	USA	West	AZ	Cheezos	372	75	27900	0
385	1	USA	West	ID	Mr Greens	447	82	36654	0
386	8	USA	West	AZ	Nap Be Gone	500	33	16500	0
387	7	USA	West	AZ	Mr Greens	447	72	32184	0
388	7	USA	South	TN	Purple Pain	105	37	3885	0
389	12	USA	Midwest	MO	Purple Pain	105	65	6825	0
390	8	USA	South	DE	Crocodile Tears	143	48	6864	0
391	12	USA	West	AZ	Red Hot Chili Peppers	233	38	8854	0
392	10	USA	South	FL	Red Rock Candy	189	44	8316	0
393	12	USA	West	OR	Green Lightning	161	56	9016	0
394	8	USA	West	AZ	Green Lightning	161	67	10787	0
395	1	USA	West	HI	Cheezos	372	24	8928	0
396	11	USA	Midwest	MI	Yellow Zonkers	134	33	4422	0
397	3	USA	West	NV	Farm Fresh	365	40	14600	0
398	7	USA	South	KY	Rotpunkt	220	97	21340	2134
399	9	USA	West	ID	Yellow Zonkers	134	18	2412	0
400	1	USA	Midwest	NE	Organiks	257	68	17476	0
401	7	USA	Northeast	MA	Big Waffle	268	36	9648	0
402	12	USA	Northeast	MA	Panda Gummies	104	38	3952	0
403	9	USA	Midwest	NE	Purple Pain	105	68	7140	0
404	10	USA	Midwest	NE	Nap Be Gone	500	99	49500	4950
405	12	USA	West	HI	Rotpunkt	220	68	14960	0
406	1	USA	Midwest	MO	Just The Fruit	160	76	12160	0
407	1	USA	Midwest	MI	Red Hot Chili Peppers	233	12	2796	0
408	11	USA	South	FL	Organiks	257	33	8481	0
409	7	USA	West	CA	Green Lightning	161	81	13041	0
410	1	USA	West	ID	Meat B Gone	495	13	6435	0
411	5	USA	West	OR	Yellow Zonkers	134	20	2680	0
412	5	USA	South	TN	Crocodile Tears	143	93	13299	1330
413	1	USA	West	CA	Only Pancakes	413	67	27671	0
414	4	USA	Midwest	NE	PearApple	363	69	25047	0
415	5	USA	Northeast	VT	Ultra-Salty Chips	454	84	38136	0
416	7	USA	West	AZ	Giant Gummies	347	13	4511	0
417	3	USA	South	TN	Meat B Gone	495	9	4455	0
418	6	USA	West	HI	Big Waffle	268	39	10452	0
419	7	USA	Northeast	VT	Big Waffle	268	3	804	0
420	5	USA	West	CA	Only Pancakes	413	29	11977	0
421	9	USA	West	CA	Rotpunkt	220	5	1100	0
422	8	USA	South	FL	Future Toast	253	26	6578	0
423	9	USA	South	DE	Mr Greens	447	9	4023	0
424	10	USA	West	WA	Just The Fruit	160	72	11520	0
425	6	USA	South	TN	Just The Fruit	160	39	6240	0
426	9	USA	South	SC	Just The Fruit	160	64	10240	0
427	7	USA	South	TN	Purple Pain	105	77	8085	0
428	7	USA	Northeast	MA	Organiks	257	45	11565	0
429	9	USA	West	NV	Cheezos	372	47	17484	0
430	3	USA	South	KY	Just The Fruit	160	57	9120	0
431	12	USA	West	OR	Red Hot Chili Peppers	233	54	12582	0
432	2	USA	South	TN	Cheezos	372	39	14508	0
433	9	USA	South	KY	Just The Fruit	160	30	4800	0
434	9	USA	Midwest	MI	GMO Guardian	176	76	13376	0
435	5	USA	Northeast	VT	Yellow Zonkers	134	57	7638	0
436	8	USA	Midwest	MO	Nap Be Gone	500	35	17500	0
437	10	USA	South	FL	Cheezos	372	25	9300	0
438	7	USA	South	TN	Meat B Gone	495	87	43065	0
439	11	USA	Northeast	MA	Future Toast	253	47	11891	0
440	8	USA	South	DE	Funky Pops	380	70	26600	0
441	7	USA	Northeast	MA	Crocodile Tears	143	55	7865	0
442	7	USA	Midwest	NE	GMO Guardian	176	85	14960	0
443	9	USA	West	WA	Nap Be Gone	500	63	31500	0
444	4	USA	South	DE	Organiks	257	40	10280	0
445	9	USA	South	TN	Farm Fresh	365	14	5110	0
446	12	USA	Midwest	IL	Meat B Gone	495	27	13365	0
447	3	USA	West	HI	Power Gels	193	51	9843	0
448	2	USA	South	NC	Future Toast	253	59	14927	0
449	1	USA	South	SC	Funky Pops	380	71	26980	0
450	4	USA	Midwest	MI	Grey Gummies	446	68	30328	0
451	10	USA	Northeast	MA	Future Toast	253	95	24035	2404
452	5	USA	West	NV	Funky Pops	380	78	29640	0
453	6	USA	West	NV	GMO Guardian	176	10	1760	0
454	4	USA	Midwest	IL	Red Hot Chili Peppers	233	44	10252	0
455	10	USA	South	SC	Funky Pops	380	63	23940	0
456	11	USA	South	SC	Purple Pain	105	86	9030	0
457	7	USA	West	HI	Crocodile Tears	143	12	1716	0
458	11	USA	Northeast	RI	Red Hot Chili Peppers	233	67	15611	0
459	1	USA	South	SC	Only Pancakes	413	24	9912	0
460	7	USA	West	WA	Funky Pops	380	78	29640	0
461	8	USA	Midwest	NE	Future Toast	253	100	25300	2530
462	2	USA	Northeast	RI	Meat B Gone	495	87	43065	0
463	8	USA	Midwest	IL	Farm Fresh	365	89	32485	0
464	4	USA	South	SC	Purple Pain	105	44	4620	0
465	5	USA	South	FL	Red Hot Chili Peppers	233	57	13281	0
466	10	USA	Midwest	MO	Just The Fruit	160	89	14240	0
467	12	USA	Northeast	RI	Ultra-Salty Chips	454	3	1362	0
468	1	USA	Midwest	NE	Grey Gummies	446	50	22300	0
469	4	USA	West	HI	Meat B Gone	495	29	14355	0
470	7	USA	South	SC	Purple Pain	105	23	2415	0
471	3	USA	West	AZ	Purple Pain	105	60	6300	0
472	8	USA	Midwest	MO	Giant Gummies	347	85	29495	0
473	1	USA	West	HI	Orange Creepies	300	4	1200	0
474	6	USA	South	TN	Rotpunkt	220	52	11440	0
475	3	USA	South	NC	Funky Pops	380	29	11020	0
476	2	USA	Midwest	MO	Mr Greens	447	95	42465	4247
477	9	USA	West	AZ	Rotpunkt	220	21	4620	0
478	5	USA	Midwest	MO	Rotpunkt	220	65	14300	0
479	11	USA	South	TN	Giant Gummies	347	65	22555	0
480	10	USA	West	HI	Yellow Zonkers	134	35	4690	0
481	4	USA	Northeast	MA	Organiks	257	83	21331	0
482	3	USA	West	CA	Just The Fruit	160	76	12160	0
483	1	USA	Midwest	MO	Nap Be Gone	500	98	49000	4900
484	3	USA	South	MD	Crocodile Tears	143	71	10153	0
485	3	USA	South	NC	Rotpunkt	220	3	660	0
486	3	USA	Northeast	MA	PearApple	363	57	20691	0
487	5	USA	South	SC	Panda Gummies	104	37	3848	0
488	5	USA	Northeast	MA	Yellow Zonkers	134	24	3216	0
489	5	USA	West	AZ	Big Waffle	268	35	9380	0
490	8	USA	South	SC	Just The Fruit	160	22	3520	0
491	10	USA	South	MD	Organiks	257	45	11565	0
492	4	USA	West	ID	Red Hot Chili Peppers	233	79	18407	0
493	5	USA	Midwest	IL	Only Pancakes	413	52	21476	0
494	12	USA	South	TN	GMO Guardian	176	78	13728	0
495	3	USA	South	MD	Future Toast	253	9	2277	0
496	4	USA	West	ID	Ultra-Salty Chips	454	59	26786	0
497	4	USA	Midwest	NE	PearApple	363	84	30492	0
498	2	USA	West	OR	Rotpunkt	220	49	10780	0
499	9	USA	West	HI	Just The Fruit	160	19	3040	0

	Month	Country	Region	State	Product	Per-Unit Price	Quantity	Order Total
0	7	USA	West	CA	Orange Creepies	300	49	14700
1	9	USA	Northeast	RI	Farm Fresh	365	49	17885
2	10	USA	South	TN	Farm Fresh	365	10	3650
3	12	USA	South	FL	Organiks	257	27	6939
4	12	USA	South	MD	PearApple	363	83	30129
5	8	USA	South	KY	Big Waffle	268	5	1340
6	4	USA	South	SC	Farm Fresh	365	82	29930
7	3	USA	West	AZ	Funky Pops	380	62	23560
8	4	USA	Northeast	MA	Ultra-Salty Chips	454	28	12712
9	10	USA	South	DE	Just The Fruit	160	30	4800
10	9	USA	Northeast	MA	Yellow Zonkers	134	92	12328
11	10	USA	South	FL	Purple Pain	105	71	7455
12	1	USA	West	NV	Orange Creepies	300	67	20100
13	8	USA	South	NC	Grey Gummies	446	89	39694
14	7	USA	West	AZ	Farm Fresh	365	43	15695
15	2	USA	West	HI	Future Toast	253	44	11132
16	6	USA	South	MD	Farm Fresh	365	16	5840
17	8	USA	Northeast	RI	Giant Gummies	347	100	34700
18	8	USA	South	MD	Nap Be Gone	500	27	13500
19	7	USA	West	ID	Power Gels	193	42	8106
20	5	USA	South	SC	Power Gels	193	29	5597
21	12	USA	South	NC	Future Toast	253	85	21505
22	3	USA	South	MD	Ultra-Salty Chips	454	16	7264
23	3	USA	West	NV	Giant Gummies	347	61	21167
24	12	USA	South	FL	Future Toast	253	17	4301
25	1	USA	Midwest	MI	Cheezos	372	16	5952
26	6	USA	West	NV	Green Lightning	161	96	15456
27	4	USA	South	DE	Only Pancakes	413	26	10738
28	12	USA	West	AZ	Only Pancakes	413	10	4130
29	2	USA	Northeast	VT	Future Toast	253	59	14927
30	10	USA	Midwest	NE	Future Toast	253	42	10626
31	2	USA	South	TN	Just The Fruit	160	7	1120
32	4	USA	West	WA	Meat B Gone	495	59	29205
33	9	USA	South	DE	Just The Fruit	160	7	1120
34	7	USA	Midwest	IL	Rotpunkt	220	54	11880
35	1	USA	West	CA	Orange Creepies	300	8	2400
36	7	USA	South	DE	Panda Gummies	104	68	7072
37	7	USA	Midwest	MO	Orange Creepies	300	78	23400
38	6	USA	South	FL	Yellow Zonkers	134	94	12596
39	6	USA	South	MD	Giant Gummies	347	71	24637
40	10	USA	South	FL	Grey Gummies	446	46	20516
41	11	USA	South	FL	Just The Fruit	160	10	1600
42	4	USA	South	NC	Red Hot Chili Peppers	233	82	19106
43	4	USA	Northeast	VT	Power Gels	193	78	15054
44	6	USA	South	TN	Nap Be Gone	500	84	42000
45	4	USA	South	NC	GMO Guardian	176	5	880
46	6	USA	Midwest	MO	GMO Guardian	176	23	4048
47	5	USA	Northeast	MA	Only Pancakes	413	2	826
48	3	USA	Midwest	IL	Grey Gummies	446	1	446
49	8	USA	South	MD	Rotpunkt	220	51	11220
50	6	USA	Midwest	MI	Meat B Gone	495	38	18810
51	12	USA	Midwest	MI	Only Pancakes	413	97	40061
52	3	USA	South	DE	Power Gels	193	38	7334
53	10	USA	West	WA	Panda Gummies	104	30	3120
54	2	USA	West	CA	Nap Be Gone	500	96	48000
55	6	USA	Midwest	MI	GMO Guardian	176	57	10032
56	8	USA	South	FL	Crocodile Tears	143	5	715
57	8	USA	South	MD	GMO Guardian	176	60	10560
58	5	USA	South	TN	Rotpunkt	220	66	14520
59	9	USA	South	FL	Meat B Gone	495	23	11385
60	2	USA	West	OR	Purple Pain	105	93	9765
61	9	USA	West	HI	Meat B Gone	495	77	38115
62	11	USA	South	KY	Rotpunkt	220	61	13420
63	9	USA	West	WA	Panda Gummies	104	19	1976
64	9	USA	West	OR	Red Rock Candy	189	92	17388
65	12	USA	South	FL	Purple Pain	105	14	1470
66	2	USA	Northeast	VT	Giant Gummies	347	30	10410
67	8	USA	Northeast	MA	Nap Be Gone	500	5	2500
68	8	USA	South	NC	Future Toast	253	90	22770
69	11	USA	Midwest	MO	Meat B Gone	495	22	10890
70	3	USA	Northeast	RI	Just The Fruit	160	29	4640
71	8	USA	South	MD	Red Rock Candy	189	71	13419
72	9	USA	South	TN	Funky Pops	380	67	25460
73	12	USA	South	DE	Nap Be Gone	500	64	32000
74	4	USA	South	DE	Ultra-Salty Chips	454	67	30418
75	4	USA	West	OR	Orange Creepies	300	15	4500
76	6	USA	South	DE	Red Rock Candy	189	9	1701
77	11	USA	West	NV	Red Hot Chili Peppers	233	87	20271
78	6	USA	South	FL	Mr Greens	447	54	24138
79	7	USA	West	CA	Cheezos	372	20	7440
80	9	USA	South	MD	PearApple	363	39	14157
81	10	USA	South	MD	Cheezos	372	26	9672
82	9	USA	South	MD	Power Gels	193	30	5790
83	12	USA	South	KY	Power Gels	193	73	14089
84	12	USA	Midwest	NE	Ultra-Salty Chips	454	32	14528
85	8	USA	Midwest	MO	GMO Guardian	176	63	11088
86	4	USA	West	WA	Giant Gummies	347	27	9369
87	10	USA	South	FL	Ultra-Salty Chips	454	86	39044
88	6	USA	South	NC	Purple Pain	105	89	9345
89	9	USA	Midwest	IL	Green Lightning	161	54	8694
90	1	USA	South	FL	Panda Gummies	104	14	1456
91	7	USA	South	DE	Power Gels	193	60	11580
92	6	USA	South	MD	Rotpunkt	220	36	7920
93	7	USA	West	HI	Yellow Zonkers	134	59	7906
94	11	USA	South	SC	Nap Be Gone	500	39	19500
95	11	USA	South	FL	Yellow Zonkers	134	67	8978
96	11	USA	South	FL	GMO Guardian	176	13	2288
97	8	USA	Midwest	NE	Ultra-Salty Chips	454	62	28148
98	6	USA	Northeast	MA	Green Lightning	161	92	14812
99	7	USA	South	SC	Cheezos	372	54	20088
100	3	USA	West	HI	PearApple	363	64	23232
101	4	USA	South	FL	Mr Greens	447	31	13857
102	10	USA	Northeast	RI	Funky Pops	380	33	12540
103	10	USA	West	CA	Farm Fresh	365	8	2920
104	3	USA	South	TN	Ultra-Salty Chips	454	24	10896
105	1	USA	South	SC	Only Pancakes	413	31	12803
106	2	USA	West	CA	Red Hot Chili Peppers	233	36	8388
107	3	USA	South	FL	Panda Gummies	104	13	1352
108	2	USA	West	NV	Funky Pops	380	46	17480
109	2	USA	Northeast	RI	Yellow Zonkers	134	7	938
110	9	USA	Northeast	MA	Red Hot Chili Peppers	233	12	2796
111	7	USA	Midwest	NE	Future Toast	253	90	22770
112	11	USA	West	CA	Power Gels	193	87	16791
113	6	USA	South	MD	Mr Greens	447	75	33525
114	7	USA	West	OR	Red Rock Candy	189	83	15687
115	12	USA	South	MD	Panda Gummies	104	26	2704
116	4	USA	Midwest	IL	GMO Guardian	176	89	15664
117	1	USA	Midwest	MI	Just The Fruit	160	7	1120
118	3	USA	West	ID	Giant Gummies	347	80	27760
119	9	USA	West	AZ	Nap Be Gone	500	35	17500
120	3	USA	South	KY	Green Lightning	161	36	5796
121	2	USA	Midwest	IL	Farm Fresh	365	85	31025
122	5	USA	South	TN	Power Gels	193	90	17370
123	5	USA	West	HI	Green Lightning	161	48	7728
124	3	USA	South	KY	GMO Guardian	176	73	12848
125	11	USA	South	FL	Only Pancakes	413	5	2065
126	3	USA	South	KY	Future Toast	253	77	19481
127	9	USA	West	OR	Funky Pops	380	20	7600
128	11	USA	Midwest	MO	Farm Fresh	365	89	32485
129	7	USA	West	CA	Power Gels	193	55	10615
130	9	USA	South	SC	Green Lightning	161	37	5957
131	6	USA	South	SC	PearApple	363	94	34122
132	8	USA	South	KY	Giant Gummies	347	78	27066
133	12	USA	South	DE	Panda Gummies	104	16	1664
134	4	USA	South	MD	Grey Gummies	446	61	27206
135	3	USA	Northeast	VT	Purple Pain	105	7	735
136	4	USA	West	HI	Organiks	257	52	13364
137	1	USA	West	CA	Funky Pops	380	12	4560
138	7	USA	West	HI	Panda Gummies	104	5	520
139	1	USA	Northeast	MA	PearApple	363	1	363
140	4	USA	Midwest	MI	Panda Gummies	104	11	1144
141	5	USA	Midwest	NE	GMO Guardian	176	38	6688
142	3	USA	Midwest	IL	Giant Gummies	347	100	34700
143	2	USA	Northeast	VT	Yellow Zonkers	134	77	10318
144	8	USA	West	AZ	Orange Creepies	300	44	13200
145	3	USA	Midwest	NE	PearApple	363	36	13068
146	3	USA	South	DE	Cheezos	372	91	33852
147	3	USA	South	FL	Future Toast	253	93	23529
148	3	USA	West	HI	GMO Guardian	176	98	17248
149	6	USA	Northeast	VT	Nap Be Gone	500	77	38500
150	9	USA	South	TN	Only Pancakes	413	39	16107
151	10	USA	Northeast	RI	Orange Creepies	300	41	12300
152	3	USA	South	FL	Panda Gummies	104	2	208
153	11	USA	West	ID	Orange Creepies	300	18	5400
154	8	USA	West	AZ	Big Waffle	268	27	7236
155	2	USA	West	AZ	Meat B Gone	495	1	495
156	1	USA	South	FL	Orange Creepies	300	94	28200
157	5	USA	South	MD	Funky Pops	380	69	26220
158	5	USA	South	TN	Ultra-Salty Chips	454	54	24516
159	4	USA	West	CA	Mr Greens	447	37	16539
160	4	USA	Midwest	MO	Red Hot Chili Peppers	233	93	21669
161	10	USA	South	DE	PearApple	363	63	22869
162	8	USA	Midwest	NE	Purple Pain	105	34	3570
163	1	USA	South	TN	Future Toast	253	42	10626
164	12	USA	West	HI	PearApple	363	80	29040
165	6	USA	South	TN	Grey Gummies	446	95	42370
166	10	USA	West	WA	Organiks	257	1	257
167	7	USA	South	TN	Power Gels	193	96	18528
168	8	USA	West	OR	Purple Pain	105	7	735
169	12	USA	West	WA	Crocodile Tears	143	64	9152
170	7	USA	Midwest	IL	Organiks	257	77	19789
171	10	USA	South	DE	Yellow Zonkers	134	61	8174
172	11	USA	Northeast	MA	Ultra-Salty Chips	454	43	19522
173	3	USA	West	WA	Organiks	257	40	10280
174	11	USA	South	FL	Purple Pain	105	14	1470
175	7	USA	Northeast	MA	Red Rock Candy	189	25	4725
176	9	USA	South	NC	Farm Fresh	365	62	22630
177	10	USA	South	TN	Farm Fresh	365	22	8030
178	1	USA	South	DE	Grey Gummies	446	29	12934
179	7	USA	Midwest	MO	Meat B Gone	495	6	2970
180	3	USA	Midwest	NE	Panda Gummies	104	3	312
181	9	USA	West	HI	Farm Fresh	365	76	27740
182	4	USA	South	KY	Mr Greens	447	53	23691
183	1	USA	West	NV	Giant Gummies	347	5	1735
184	8	USA	Midwest	MO	Rotpunkt	220	25	5500
185	2	USA	South	FL	Organiks	257	66	16962
186	1	USA	South	KY	Power Gels	193	75	14475
187	8	USA	South	MD	Mr Greens	447	79	35313
188	7	USA	South	KY	Nap Be Gone	500	57	28500
189	7	USA	Midwest	NE	Mr Greens	447	36	16092
190	11	USA	South	TN	Farm Fresh	365	5	1825
191	11	USA	Midwest	IL	Meat B Gone	495	42	20790
192	12	USA	Midwest	NE	Rotpunkt	220	30	6600
193	1	USA	South	NC	Red Rock Candy	189	88	16632
194	7	USA	West	WA	Yellow Zonkers	134	53	7102
195	10	USA	South	SC	Organiks	257	10	2570
196	12	USA	South	SC	Ultra-Salty Chips	454	7	3178
197	5	USA	Midwest	MO	Crocodile Tears	143	94	13442
198	2	USA	South	MD	Grey Gummies	446	33	14718
199	9	USA	South	FL	Funky Pops	380	9	3420
200	12	USA	Northeast	MA	Cheezos	372	70	26040
201	8	USA	South	DE	Cheezos	372	65	24180
202	11	USA	Northeast	VT	Organiks	257	32	8224
203	11	USA	West	WA	Purple Pain	105	65	6825
204	12	USA	West	WA	Only Pancakes	413	38	15694
205	9	USA	Midwest	IL	Green Lightning	161	51	8211
206	5	USA	South	TN	Crocodile Tears	143	48	6864
207	10	USA	South	FL	Orange Creepies	300	81	24300
208	3	USA	Midwest	NE	Purple Pain	105	27	2835
209	4	USA	South	KY	Yellow Zonkers	134	97	12998
210	1	USA	Midwest	NE	Only Pancakes	413	26	10738
211	7	USA	South	FL	Orange Creepies	300	71	21300
212	11	USA	South	DE	Orange Creepies	300	66	19800
213	6	USA	Midwest	NE	Giant Gummies	347	45	15615
214	11	USA	South	TN	Crocodile Tears	143	67	9581
215	6	USA	South	KY	PearApple	363	80	29040
216	7	USA	Midwest	MO	Nap Be Gone	500	10	5000
217	6	USA	West	HI	Giant Gummies	347	92	31924
218	5	USA	South	TN	Red Rock Candy	189	86	16254
219	3	USA	Midwest	NE	Cheezos	372	12	4464
220	5	USA	South	TN	Ultra-Salty Chips	454	63	28602
221	2	USA	West	AZ	Nap Be Gone	500	89	44500
222	10	USA	Northeast	RI	Crocodile Tears	143	18	2574
223	12	USA	Midwest	MO	Purple Pain	105	66	6930
224	11	USA	Northeast	RI	Ultra-Salty Chips	454	83	37682
225	9	USA	South	FL	Future Toast	253	94	23782
226	2	USA	West	HI	Funky Pops	380	58	22040
227	11	USA	Midwest	IL	Big Waffle	268	41	10988
228	11	USA	Midwest	NE	Only Pancakes	413	92	37996
229	3	USA	South	SC	Power Gels	193	29	5597
230	7	USA	Midwest	IL	Farm Fresh	365	51	18615
231	6	USA	Midwest	MO	Nap Be Gone	500	43	21500
232	11	USA	South	MD	Purple Pain	105	23	2415
233	5	USA	South	TN	GMO Guardian	176	73	12848
234	5	USA	South	TN	PearApple	363	91	33033
235	5	USA	South	TN	Red Rock Candy	189	38	7182
236	4	USA	South	NC	Meat B Gone	495	45	22275
237	2	USA	West	OR	Organiks	257	57	14649
238	2	USA	Midwest	IL	Grey Gummies	446	15	6690
239	12	USA	West	WA	Mr Greens	447	4	1788
240	5	USA	Midwest	NE	Meat B Gone	495	78	38610
241	7	USA	Midwest	NE	Grey Gummies	446	81	36126
242	12	USA	South	KY	Crocodile Tears	143	73	10439
243	2	USA	West	WA	Orange Creepies	300	44	13200
244	4	USA	South	SC	Purple Pain	105	1	105
245	9	USA	Northeast	RI	Panda Gummies	104	15	1560
246	4	USA	South	FL	PearApple	363	1	363
247	8	USA	Northeast	MA	Funky Pops	380	25	9500
248	11	USA	Midwest	IL	Red Rock Candy	189	57	10773
249	7	USA	West	AZ	Green Lightning	161	6	966
250	11	USA	West	HI	Panda Gummies	104	84	8736
251	3	USA	Midwest	MI	Future Toast	253	92	23276
252	2	USA	South	DE	Future Toast	253	11	2783
253	4	USA	South	TN	Purple Pain	105	54	5670
254	4	USA	Northeast	MA	PearApple	363	64	23232
255	5	USA	South	MD	Farm Fresh	365	56	20440
256	6	USA	South	FL	Orange Creepies	300	31	9300
257	11	USA	South	FL	Green Lightning	161	46	7406
258	2	USA	Midwest	MI	Organiks	257	49	12593
259	10	USA	Northeast	RI	Green Lightning	161	38	6118
260	11	USA	West	AZ	Farm Fresh	365	60	21900
261	9	USA	South	MD	Future Toast	253	95	24035
262	7	USA	West	WA	Only Pancakes	413	64	26432
263	1	USA	West	ID	Mr Greens	447	23	10281
264	3	USA	South	FL	Red Rock Candy	189	52	9828
265	11	USA	West	CA	Green Lightning	161	21	3381
266	10	USA	West	CA	Ultra-Salty Chips	454	52	23608
267	12	USA	West	HI	Organiks	257	16	4112
268	11	USA	Midwest	MO	Yellow Zonkers	134	64	8576
269	12	USA	Midwest	MI	Yellow Zonkers	134	91	12194
270	2	USA	South	KY	Farm Fresh	365	14	5110
271	5	USA	South	TN	Red Rock Candy	189	88	16632
272	10	USA	Midwest	MI	Only Pancakes	413	65	26845
273	3	USA	Northeast	VT	Red Hot Chili Peppers	233	87	20271
274	2	USA	South	FL	Funky Pops	380	19	7220
275	3	USA	West	AZ	Red Rock Candy	189	15	2835
276	9	USA	Northeast	MA	Mr Greens	447	41	18327
277	1	USA	West	AZ	Grey Gummies	446	56	24976
278	4	USA	West	NV	Green Lightning	161	88	14168
279	3	USA	South	TN	Funky Pops	380	80	30400
280	8	USA	West	NV	Orange Creepies	300	5	1500
281	6	USA	South	TN	Green Lightning	161	54	8694
282	12	USA	West	OR	Rotpunkt	220	70	15400
283	7	USA	West	AZ	Grey Gummies	446	35	15610
284	3	USA	South	FL	Grey Gummies	446	52	23192
285	3	USA	West	HI	Giant Gummies	347	44	15268
286	4	USA	Midwest	MI	Organiks	257	96	24672
287	6	USA	South	FL	Green Lightning	161	79	12719
288	12	USA	South	FL	Future Toast	253	22	5566
289	6	USA	Midwest	MO	Funky Pops	380	61	23180
290	3	USA	West	OR	Rotpunkt	220	90	19800
291	2	USA	South	FL	GMO Guardian	176	9	1584
292	5	USA	South	NC	Green Lightning	161	82	13202
293	7	USA	West	AZ	Power Gels	193	29	5597
294	9	USA	West	OR	Farm Fresh	365	34	12410
295	8	USA	South	NC	Yellow Zonkers	134	51	6834
296	1	USA	West	NV	Only Pancakes	413	43	17759
297	9	USA	Northeast	RI	PearApple	363	82	29766
298	3	USA	West	WA	Just The Fruit	160	70	11200
299	12	USA	West	AZ	Ultra-Salty Chips	454	39	17706
300	10	USA	Midwest	NE	Rotpunkt	220	17	3740
301	12	USA	Midwest	IL	PearApple	363	65	23595
302	3	USA	West	NV	Farm Fresh	365	43	15695
303	12	USA	West	NV	Giant Gummies	347	31	10757
304	2	USA	Midwest	MO	Big Waffle	268	1	268
305	4	USA	Northeast	MA	Big Waffle	268	62	16616
306	8	USA	Northeast	MA	Green Lightning	161	12	1932
307	3	USA	South	KY	Farm Fresh	365	4	1460
308	6	USA	West	OR	Nap Be Gone	500	87	43500
309	4	USA	Northeast	MA	PearApple	363	37	13431
310	5	USA	Midwest	MO	Red Hot Chili Peppers	233	32	7456
311	3	USA	South	MD	Big Waffle	268	38	10184
312	11	USA	West	AZ	Farm Fresh	365	67	24455
313	6	USA	Midwest	IL	PearApple	363	37	13431
314	5	USA	South	FL	Farm Fresh	365	56	20440
315	3	USA	South	MD	Power Gels	193	34	6562
316	8	USA	South	KY	Green Lightning	161	10	1610
317	11	USA	West	NV	Future Toast	253	67	16951
318	5	USA	West	HI	Organiks	257	99	25443
319	11	USA	South	DE	Mr Greens	447	85	37995
320	9	USA	Northeast	RI	Rotpunkt	220	37	8140
321	1	USA	West	OR	Purple Pain	105	86	9030
322	3	USA	South	TN	Rotpunkt	220	72	15840
323	3	USA	Northeast	VT	Grey Gummies	446	92	41032
324	4	USA	West	WA	Rotpunkt	220	97	21340
325	7	USA	West	AZ	Farm Fresh	365	38	13870
326	11	USA	Midwest	IL	Cheezos	372	90	33480
327	12	USA	West	NV	Red Hot Chili Peppers	233	39	9087
328	5	USA	West	OR	Just The Fruit	160	90	14400
329	7	USA	West	ID	Nap Be Gone	500	25	12500
330	7	USA	South	FL	Funky Pops	380	65	24700
331	9	USA	South	TN	Funky Pops	380	88	33440
332	2	USA	South	FL	Funky Pops	380	57	21660
333	8	USA	West	WA	Farm Fresh	365	81	29565
334	6	USA	West	CA	Giant Gummies	347	68	23596
335	4	USA	Northeast	VT	Organiks	257	26	6682
336	6	USA	South	TN	Orange Creepies	300	58	17400
337	2	USA	South	NC	Farm Fresh	365	33	12045
338	8	USA	Northeast	MA	Purple Pain	105	44	4620
339	8	USA	South	TN	Power Gels	193	50	9650
340	11	USA	West	HI	Power Gels	193	21	4053
341	7	USA	South	TN	Red Rock Candy	189	15	2835
342	6	USA	South	NC	Yellow Zonkers	134	20	2680
343	1	USA	Midwest	MO	Giant Gummies	347	46	15962
344	3	USA	Northeast	MA	Panda Gummies	104	11	1144
345	1	USA	South	SC	Grey Gummies	446	29	12934
346	4	USA	South	KY	Cheezos	372	28	10416
347	2	USA	South	DE	Big Waffle	268	93	24924
348	5	USA	Midwest	MO	Red Hot Chili Peppers	233	94	21902
349	11	USA	West	HI	Green Lightning	161	53	8533
350	11	USA	South	SC	Green Lightning	161	33	5313
351	12	USA	West	NV	Giant Gummies	347	17	5899
352	4	USA	Northeast	RI	Meat B Gone	495	55	27225
353	12	USA	West	AZ	Yellow Zonkers	134	29	3886
354	9	USA	West	WA	Organiks	257	80	20560
355	11	USA	West	OR	Purple Pain	105	5	525
356	5	USA	Midwest	IL	Rotpunkt	220	33	7260
357	6	USA	Northeast	VT	Red Rock Candy	189	8	1512
358	2	USA	South	NC	Green Lightning	161	16	2576
359	1	USA	West	WA	Rotpunkt	220	96	21120
360	4	USA	South	TN	Green Lightning	161	4	644
361	7	USA	South	MD	Red Hot Chili Peppers	233	11	2563
362	6	USA	West	HI	Cheezos	372	18	6696
363	1	USA	Northeast	VT	Red Rock Candy	189	9	1701
364	7	USA	West	CA	Just The Fruit	160	47	7520
365	9	USA	Northeast	VT	Panda Gummies	104	91	9464
366	1	USA	South	TN	Future Toast	253	3	759
367	6	USA	Midwest	NE	Mr Greens	447	21	9387
368	9	USA	South	KY	Farm Fresh	365	83	30295
369	10	USA	West	ID	Red Hot Chili Peppers	233	9	2097
370	4	USA	South	NC	Rotpunkt	220	22	4840
371	10	USA	Midwest	MI	Ultra-Salty Chips	454	82	37228
372	8	USA	West	CA	Farm Fresh	365	97	35405
373	1	USA	South	MD	Mr Greens	447	53	23691
374	12	USA	South	FL	Rotpunkt	220	90	19800
375	1	USA	West	HI	Red Rock Candy	189	6	1134
376	8	USA	West	OR	Ultra-Salty Chips	454	76	34504
377	2	USA	South	KY	Big Waffle	268	92	24656
378	2	USA	Midwest	IL	Power Gels	193	85	16405
379	8	USA	Midwest	IL	GMO Guardian	176	53	9328
380	4	USA	Midwest	NE	Just The Fruit	160	3	480
381	5	USA	South	KY	Green Lightning	161	59	9499
382	11	USA	Northeast	MA	Only Pancakes	413	24	9912
383	10	USA	Midwest	IL	Cheezos	372	81	30132
384	1	USA	West	OR	Cheezos	372	58	21576
385	12	USA	South	FL	Ultra-Salty Chips	454	33	14982
386	4	USA	South	FL	Future Toast	253	5	1265
387	10	USA	West	CA	Cheezos	372	22	8184
388	1	USA	West	CA	Red Hot Chili Peppers	233	42	9786
389	4	USA	South	FL	Just The Fruit	160	49	7840
390	3	USA	South	SC	Red Rock Candy	189	80	15120
391	4	USA	South	FL	Funky Pops	380	72	27360
392	5	USA	South	FL	Yellow Zonkers	134	94	12596
393	6	USA	South	TN	Ultra-Salty Chips	454	99	44946
394	9	USA	West	OR	Farm Fresh	365	49	17885
395	4	USA	South	DE	Funky Pops	380	21	7980
396	10	USA	South	KY	Funky Pops	380	73	27740
397	5	USA	South	KY	Nap Be Gone	500	13	6500
398	3	USA	South	SC	Orange Creepies	300	54	16200
399	12	USA	South	NC	Farm Fresh	365	67	24455
400	9	USA	West	CA	Crocodile Tears	143	69	9867
401	3	USA	Midwest	NE	Green Lightning	161	60	9660
402	9	USA	South	DE	Organiks	257	50	12850
403	1	USA	West	ID	Mr Greens	447	10	4470
404	8	USA	West	ID	Giant Gummies	347	92	31924
405	9	USA	South	NC	Future Toast	253	86	21758
406	9	USA	Midwest	IL	Just The Fruit	160	46	7360
407	7	USA	West	HI	Organiks	257	66	16962
408	1	USA	South	TN	Red Hot Chili Peppers	233	23	5359
409	10	USA	South	FL	Meat B Gone	495	83	41085
410	7	USA	Northeast	VT	PearApple	363	88	31944
411	7	USA	Midwest	IL	Meat B Gone	495	43	21285
412	9	USA	South	FL	Red Rock Candy	189	65	12285
413	8	USA	South	KY	Nap Be Gone	500	92	46000
414	3	USA	South	FL	Only Pancakes	413	41	16933
415	6	USA	South	FL	Power Gels	193	33	6369
416	3	USA	West	NV	Panda Gummies	104	27	2808
417	5	USA	West	AZ	Future Toast	253	94	23782
418	8	USA	Midwest	IL	Just The Fruit	160	98	15680
419	3	USA	South	KY	Funky Pops	380	52	19760
420	4	USA	Northeast	MA	Red Hot Chili Peppers	233	77	17941
421	1	USA	South	MD	Red Rock Candy	189	74	13986
422	2	USA	West	WA	Funky Pops	380	89	33820
423	3	USA	Midwest	MI	Just The Fruit	160	66	10560
424	2	USA	Midwest	MI	Meat B Gone	495	21	10395
425	9	USA	South	KY	Meat B Gone	495	30	14850
426	6	USA	South	TN	Power Gels	193	41	7913
427	2	USA	South	DE	Panda Gummies	104	98	10192
428	9	USA	Midwest	IL	Big Waffle	268	1	268
429	11	USA	West	ID	Grey Gummies	446	3	1338
430	3	USA	Midwest	MI	Big Waffle	268	82	21976
431	9	USA	South	TN	Rotpunkt	220	7	1540
432	2	USA	Northeast	MA	Organiks	257	86	22102
433	8	USA	Midwest	MO	PearApple	363	59	21417
434	5	USA	South	FL	PearApple	363	28	10164
435	2	USA	West	OR	Only Pancakes	413	12	4956
436	5	USA	Midwest	NE	PearApple	363	9	3267
437	2	USA	West	AZ	Ultra-Salty Chips	454	100	45400
438	5	USA	South	MD	Orange Creepies	300	38	11400
439	7	USA	South	FL	Funky Pops	380	73	27740
440	5	USA	South	DE	GMO Guardian	176	80	14080
441	2	USA	Midwest	MI	Cheezos	372	44	16368
442	6	USA	West	WA	Purple Pain	105	3	315
443	4	USA	South	NC	Big Waffle	268	13	3484
444	10	USA	Midwest	MI	PearApple	363	7	2541
445	3	USA	Midwest	NE	Crocodile Tears	143	90	12870
446	8	USA	West	CA	Funky Pops	380	3	1140
447	11	USA	South	KY	PearApple	363	27	9801
448	10	USA	South	NC	Farm Fresh	365	63	22995
449	5	USA	Northeast	RI	Grey Gummies	446	75	33450
450	6	USA	West	AZ	PearApple	363	11	3993
451	6	USA	West	WA	Only Pancakes	413	88	36344
452	4	USA	West	ID	Farm Fresh	365	31	11315
453	2	USA	Midwest	MO	Big Waffle	268	72	19296
454	4	USA	South	DE	Future Toast	253	56	14168
455	12	USA	Midwest	NE	Green Lightning	161	78	12558
456	11	USA	South	KY	PearApple	363	3	1089
457	11	USA	Northeast	VT	Power Gels	193	75	14475
458	3	USA	South	TN	Panda Gummies	104	56	5824
459	9	USA	West	HI	Rotpunkt	220	66	14520
460	9	USA	South	DE	GMO Guardian	176	95	16720
461	11	USA	Midwest	NE	Big Waffle	268	37	9916
462	10	USA	South	FL	Funky Pops	380	25	9500
463	12	USA	West	WA	Funky Pops	380	20	7600
464	2	USA	Midwest	IL	Crocodile Tears	143	42	6006
465	12	USA	West	OR	Funky Pops	380	97	36860
466	10	USA	West	NV	Crocodile Tears	143	92	13156
467	10	USA	West	NV	Mr Greens	447	12	5364
468	12	USA	West	WA	Organiks	257	13	3341
469	5	USA	Northeast	MA	Rotpunkt	220	5	1100
470	1	USA	South	TN	Mr Greens	447	63	28161
471	9	USA	Midwest	IL	Meat B Gone	495	63	31185
472	7	USA	Northeast	VT	Funky Pops	380	61	23180
473	2	USA	Midwest	MI	Red Hot Chili Peppers	233	64	14912
474	4	USA	South	TN	Crocodile Tears	143	83	11869
475	5	USA	South	KY	Giant Gummies	347	7	2429
476	8	USA	Northeast	MA	Cheezos	372	72	26784
477	4	USA	West	CA	Farm Fresh	365	43	15695
478	11	USA	Midwest	IL	Organiks	257	24	6168
479	9	USA	South	NC	Cheezos	372	76	28272
480	7	USA	Midwest	NE	Red Rock Candy	189	86	16254
481	5	USA	South	TN	Red Hot Chili Peppers	233	44	10252
482	12	USA	South	TN	Just The Fruit	160	17	2720
483	7	USA	South	KY	Future Toast	253	10	2530
484	9	USA	South	DE	Farm Fresh	365	82	29930
485	3	USA	West	CA	Orange Creepies	300	54	16200
486	6	USA	South	TN	Future Toast	253	25	6325
487	12	USA	Midwest	MO	Panda Gummies	104	87	9048
488	8	USA	South	TN	Mr Greens	447	52	23244
489	1	USA	West	NV	Power Gels	193	83	16019
490	5	USA	Midwest	MO	Cheezos	372	55	20460
491	12	USA	South	FL	GMO Guardian	176	66	11616
492	4	USA	West	CA	Red Rock Candy	189	92	17388
493	3	USA	West	WA	PearApple	363	30	10890
494	6	USA	Northeast	RI	Crocodile Tears	143	23	3289
495	9	USA	Midwest	MI	Cheezos	372	46	17112
496	3	USA	Northeast	MA	Meat B Gone	495	26	12870
497	6	USA	West	HI	Crocodile Tears	143	66	9438
498	10	USA	South	TN	Orange Creepies	300	57	17100
499	8	USA	West	NV	Power Gels	193	65	12545

Having Trouble Meeting Your Deadline?

Get your assignment on SQL Candy Assignment completed on time. avoid delay and – ORDER NOW

Get a 20% Discount

	Month	Region	Customer_ID	Product	Per-Unit Price	Quantity_1	Quantity_2
0	1	Midwest	280	PearApple	363	25	92
1	5	West	545	Orange Creepies	300	87	79
2	8	Northeast	131	Future Toast	253	90	6
3	4	Midwest	920	Farm Fresh	365	33	74
4	12	South	358	Rotpunkt	220	4	13
5	1	South	855	GMO Guardian	176	17	45
6	8	Midwest	499	Mr Greens	447	37	95
7	4	Midwest	172	Just The Fruit	160	84	39
8	5	West	618	Funky Pops	380	28	95
9	12	South	116	Giant Gummies	347	98	76
10	11	West	458	Organiks	257	66	68
11	12	Midwest	350	Funky Pops	380	63	90
12	7	South	976	Mr Greens	447	23	99
13	3	South	234	Crocodile Tears	143	64	28
14	6	Midwest	480	Crocodile Tears	143	15	15
15	4	Northeast	554	Giant Gummies	347	26	56
16	1	West	918	Just The Fruit	160	1	75
17	5	Midwest	493	Red Rock Candy	189	40	44
18	11	Midwest	322	Just The Fruit	160	17	97
19	5	South	480	Power Gels	193	8	21
20	3	Midwest	409	Funky Pops	380	32	32
21	6	Midwest	411	Cheezos	372	75	68
22	10	South	162	Nap Be Gone	500	92	52
23	3	Midwest	52	Only Pancakes	413	40	89
24	3	West	824	Red Rock Candy	189	90	10
25	1	South	60	Meat B Gone	495	35	67
26	4	South	788	Panda Gummies	104	29	50
27	6	West	30	Grey Gummies	446	73	88
28	3	Midwest	218	Funky Pops	380	21	52
29	11	Northeast	821	Green Lightning	161	55	79
30	5	West	936	Purple Pain	105	45	84
31	2	South	315	Big Waffle	268	61	30
32	12	West	124	Just The Fruit	160	34	76
33	3	Northeast	883	Ultra-Salty Chips	454	61	6
34	11	South	329	Power Gels	193	89	59
35	9	South	624	Grey Gummies	446	85	92
36	5	Northeast	795	Rotpunkt	220	91	96
37	11	Midwest	776	Meat B Gone	495	5	99
38	11	Northeast	288	Yellow Zonkers	134	35	6
39	4	South	416	Rotpunkt	220	92	20
40	11	Northeast	651	Purple Pain	105	54	1
41	6	West	870	Just The Fruit	160	40	20
42	7	Midwest	468	Just The Fruit	160	13	4
43	4	Midwest	643	Ultra-Salty Chips	454	62	22
44	12	Northeast	339	Mr Greens	447	93	91
45	2	West	19	Funky Pops	380	12	29
46	4	West	525	Only Pancakes	413	75	88
47	4	South	512	Mr Greens	447	35	64
48	12	Northeast	542	Only Pancakes	413	92	30
49	4	Midwest	770	Mr Greens	447	67	77
50	6	Midwest	676	Red Rock Candy	189	9	40
51	8	West	809	Farm Fresh	365	73	98
52	7	West	716	Mr Greens	447	30	12
53	7	South	511	Funky Pops	380	37	45
54	5	South	406	Red Rock Candy	189	71	80
55	8	Midwest	431	Crocodile Tears	143	76	87
56	5	West	802	Panda Gummies	104	56	69
57	12	Midwest	269	Panda Gummies	104	20	87
58	12	Midwest	739	Purple Pain	105	94	35
59	3	Northeast	644	Meat B Gone	495	63	9
60	4	South	302	Yellow Zonkers	134	87	54
61	5	Midwest	565	Mr Greens	447	81	8
62	12	Northeast	109	GMO Guardian	176	10	66
63	6	South	277	Mr Greens	447	49	4
64	10	Midwest	33	GMO Guardian	176	25	61
65	4	West	434	Just The Fruit	160	9	48
66	6	South	815	Grey Gummies	446	37	66
67	6	South	638	Mr Greens	447	56	37
68	4	Northeast	397	Purple Pain	105	85	16
69	11	West	169	Nap Be Gone	500	15	42
70	4	South	681	Power Gels	193	80	80
71	12	Midwest	930	Red Hot Chili Peppers	233	76	52
72	12	West	591	Ultra-Salty Chips	454	88	34
73	9	South	748	Ultra-Salty Chips	454	96	67
74	4	Northeast	122	Just The Fruit	160	33	98
75	8	Midwest	348	Orange Creepies	300	84	41
76	12	South	116	Ultra-Salty Chips	454	44	44
77	9	Northeast	510	Crocodile Tears	143	50	76
78	2	Midwest	481	Red Rock Candy	189	71	89
79	8	Northeast	873	Green Lightning	161	99	32
80	12	Midwest	483	Meat B Gone	495	92	20
81	2	Northeast	257	Organiks	257	78	45
82	4	West	531	Giant Gummies	347	10	29
83	5	Northeast	17	Farm Fresh	365	7	93
84	4	South	173	Only Pancakes	413	72	9
85	2	South	580	Red Rock Candy	189	16	71
86	10	Northeast	985	Big Waffle	268	2	81
87	8	West	645	Red Hot Chili Peppers	233	67	64
88	6	Midwest	869	Meat B Gone	495	61	83
89	11	Northeast	215	PearApple	363	73	24
90	10	Midwest	765	Nap Be Gone	500	56	60
91	1	West	707	Only Pancakes	413	77	32
92	5	South	8	Red Rock Candy	189	26	50
93	6	West	567	Orange Creepies	300	5	52
94	9	South	160	Crocodile Tears	143	50	94
95	8	West	183	Big Waffle	268	22	36
96	10	Midwest	358	Organiks	257	96	68
97	3	South	913	PearApple	363	27	88
98	6	Northeast	594	Mr Greens	447	80	52
99	6	South	190	Meat B Gone	495	93	90
100	5	Northeast	498	Red Rock Candy	189	18	92
101	4	South	576	Just The Fruit	160	52	80
102	2	South	353	Green Lightning	161	95	74
103	12	South	962	Orange Creepies	300	7	28
104	6	South	965	Crocodile Tears	143	74	86
105	3	West	534	Only Pancakes	413	63	81
106	3	Midwest	754	Nap Be Gone	500	70	3
107	12	South	958	Panda Gummies	104	57	74
108	1	South	890	Crocodile Tears	143	97	57
109	10	West	584	Giant Gummies	347	98	52
110	5	Northeast	734	Big Waffle	268	57	76
111	1	Midwest	561	Organiks	257	68	39
112	10	Northeast	428	Farm Fresh	365	4	31
113	12	Midwest	238	Yellow Zonkers	134	45	92
114	2	West	340	Just The Fruit	160	98	24
115	11	Northeast	681	Panda Gummies	104	31	94
116	5	Northeast	678	Yellow Zonkers	134	91	28
117	8	West	576	Purple Pain	105	43	51
118	3	South	88	Big Waffle	268	57	74
119	1	West	223	Farm Fresh	365	40	35
120	6	Midwest	357	Just The Fruit	160	13	44
121	6	Northeast	657	Panda Gummies	104	40	51
122	10	West	301	Panda Gummies	104	79	15
123	10	South	862	Panda Gummies	104	99	93
124	6	West	618	Red Hot Chili Peppers	233	12	94
125	1	Midwest	688	Orange Creepies	300	83	79
126	12	South	516	Nap Be Gone	500	67	41
127	6	Midwest	784	Big Waffle	268	19	66
128	4	Midwest	376	Giant Gummies	347	64	94
129	5	West	839	Farm Fresh	365	28	81
130	3	South	624	Crocodile Tears	143	39	86
131	5	Midwest	638	Only Pancakes	413	59	72
132	9	South	578	Only Pancakes	413	48	50
133	4	Midwest	738	Yellow Zonkers	134	21	99
134	9	Northeast	708	Only Pancakes	413	57	73
135	11	Midwest	795	Power Gels	193	5	36
136	11	Midwest	154	Only Pancakes	413	94	97
137	9	West	222	Ultra-Salty Chips	454	80	9
138	1	South	610	Nap Be Gone	500	65	30
139	3	South	872	Purple Pain	105	12	6
140	10	South	221	Just The Fruit	160	67	46
141	12	West	313	Yellow Zonkers	134	53	85
142	5	South	103	Grey Gummies	446	45	5
143	5	West	863	Cheezos	372	12	4
144	4	South	256	Crocodile Tears	143	2	100
145	2	West	720	Just The Fruit	160	70	34
146	7	Midwest	734	Ultra-Salty Chips	454	28	76
147	4	West	7	Power Gels	193	23	54
148	12	Midwest	775	Orange Creepies	300	17	46
149	9	West	896	Future Toast	253	78	5
150	12	West	783	Ultra-Salty Chips	454	25	72
151	5	South	513	Purple Pain	105	89	36
152	4	West	725	Red Rock Candy	189	62	46
153	5	South	234	Power Gels	193	98	93
154	3	Northeast	491	Grey Gummies	446	24	95
155	10	South	782	GMO Guardian	176	43	72
156	11	South	417	Farm Fresh	365	4	98
157	8	West	253	Cheezos	372	14	89
158	11	West	292	Rotpunkt	220	8	50
159	1	South	818	Crocodile Tears	143	87	51
160	2	West	234	Giant Gummies	347	48	7
161	3	Midwest	778	Funky Pops	380	75	15
162	2	South	504	Crocodile Tears	143	59	45
163	6	Midwest	114	Yellow Zonkers	134	70	73
164	5	South	246	Green Lightning	161	14	71
165	10	West	128	Funky Pops	380	63	42
166	5	West	970	Organiks	257	84	90
167	11	South	360	Funky Pops	380	76	58
168	7	West	730	Big Waffle	268	82	48
169	12	South	37	Organiks	257	83	47
170	12	Northeast	282	Ultra-Salty Chips	454	12	3
171	4	West	205	Meat B Gone	495	35	13
172	1	South	308	Big Waffle	268	9	81
173	5	South	754	Green Lightning	161	38	9
174	3	South	155	Big Waffle	268	64	99
175	12	South	742	Giant Gummies	347	34	74
176	8	Northeast	323	Green Lightning	161	75	15
177	7	South	573	Future Toast	253	75	98
178	2	Northeast	120	Mr Greens	447	95	37
179	11	West	194	Yellow Zonkers	134	89	57
180	2	Midwest	204	Grey Gummies	446	73	26
181	1	West	761	Organiks	257	29	47
182	11	West	555	Panda Gummies	104	81	76
183	2	West	680	PearApple	363	2	58
184	9	South	784	Meat B Gone	495	17	42
185	3	Northeast	193	Giant Gummies	347	36	86
186	1	Midwest	857	Orange Creepies	300	98	54
187	7	Northeast	860	Power Gels	193	49	82
188	8	West	548	Meat B Gone	495	21	44
189	5	South	348	Grey Gummies	446	17	51
190	5	South	401	Red Hot Chili Peppers	233	20	25
191	4	Midwest	968	Orange Creepies	300	71	58
192	10	West	866	Panda Gummies	104	59	42
193	10	Midwest	433	Just The Fruit	160	31	100
194	8	West	380	Green Lightning	161	4	28
195	9	South	772	Power Gels	193	47	93
196	3	West	203	Future Toast	253	38	69
197	2	West	696	Red Hot Chili Peppers	233	17	40
198	3	Midwest	616	Green Lightning	161	92	22
199	1	Northeast	457	Big Waffle	268	48	64
200	8	West	535	Grey Gummies	446	76	16
201	10	South	244	Big Waffle	268	53	35
202	6	South	710	Power Gels	193	97	22
203	10	South	624	Only Pancakes	413	88	43
204	4	Midwest	213	Organiks	257	45	52
205	11	West	364	PearApple	363	54	55
206	3	South	508	PearApple	363	82	99
207	4	South	929	Big Waffle	268	58	40
208	6	Northeast	359	Big Waffle	268	49	36
209	8	West	669	Purple Pain	105	76	92
210	9	South	421	Mr Greens	447	61	23
211	10	West	439	Orange Creepies	300	42	38
212	9	Midwest	632	Ultra-Salty Chips	454	74	49
213	9	Midwest	19	Mr Greens	447	79	31
214	5	South	187	Red Rock Candy	189	93	63
215	4	West	535	Giant Gummies	347	82	10
216	7	South	519	Giant Gummies	347	69	81
217	2	South	962	Green Lightning	161	56	49
218	11	Midwest	145	Mr Greens	447	95	47
219	7	West	849	Organiks	257	75	47
220	5	South	79	Cheezos	372	27	58
221	2	Northeast	643	Power Gels	193	37	68
222	5	Northeast	881	Nap Be Gone	500	51	68
223	10	Midwest	5	Cheezos	372	35	93
224	12	West	458	Giant Gummies	347	38	7
225	9	Northeast	335	Farm Fresh	365	98	78
226	12	West	585	Only Pancakes	413	17	28
227	6	South	1	Red Rock Candy	189	2	84
228	11	South	15	Only Pancakes	413	14	47
229	1	Midwest	548	Mr Greens	447	14	17
230	5	South	189	Green Lightning	161	99	46
231	10	Midwest	721	Green Lightning	161	94	61
232	11	South	276	Future Toast	253	48	17
233	2	South	721	Just The Fruit	160	96	48
234	9	South	143	Nap Be Gone	500	77	99
235	11	Northeast	129	Power Gels	193	34	77
236	4	Midwest	727	Grey Gummies	446	21	19
237	6	Northeast	945	Crocodile Tears	143	16	31
238	4	South	817	Panda Gummies	104	70	68
239	2	Northeast	267	Panda Gummies	104	20	35
240	6	South	520	Red Hot Chili Peppers	233	96	66
241	2	South	714	Farm Fresh	365	37	24
242	4	Northeast	347	Rotpunkt	220	85	63
243	9	West	545	Grey Gummies	446	72	52
244	1	South	265	Mr Greens	447	83	33
245	12	West	549	Just The Fruit	160	75	81
246	8	Northeast	49	Yellow Zonkers	134	16	82
247	11	West	305	Organiks	257	93	39
248	12	South	619	Green Lightning	161	1	90
249	3	West	172	Red Rock Candy	189	47	51
250	12	Midwest	9	Rotpunkt	220	28	27
251	9	South	36	Only Pancakes	413	18	6
252	9	Northeast	576	Power Gels	193	18	15
253	9	Midwest	893	Power Gels	193	43	61
254	1	Midwest	505	Mr Greens	447	99	85
255	3	Midwest	152	Future Toast	253	81	79
256	12	Midwest	420	Power Gels	193	87	38
257	1	Midwest	320	Purple Pain	105	52	79
258	4	West	653	Big Waffle	268	73	61
259	10	West	190	Red Hot Chili Peppers	233	85	30
260	6	Midwest	389	Yellow Zonkers	134	22	73
261	9	South	91	Future Toast	253	14	25
262	10	Northeast	856	Only Pancakes	413	20	43
263	6	South	406	Organiks	257	24	64
264	6	West	174	Big Waffle	268	21	48
265	8	West	165	Ultra-Salty Chips	454	35	49
266	5	Northeast	405	Green Lightning	161	97	8
267	11	South	360	Funky Pops	380	48	85
268	11	Midwest	645	Nap Be Gone	500	48	87
269	10	Midwest	114	PearApple	363	62	42
270	11	Northeast	574	Farm Fresh	365	90	33
271	10	South	985	Green Lightning	161	54	69
272	1	South	493	Red Hot Chili Peppers	233	92	67
273	8	South	146	Just The Fruit	160	97	11
274	10	West	967	Red Hot Chili Peppers	233	7	74
275	12	South	992	Panda Gummies	104	70	47
276	11	Northeast	865	Panda Gummies	104	21	80
277	10	Midwest	754	Crocodile Tears	143	49	20
278	4	West	40	Rotpunkt	220	92	71
279	3	West	290	PearApple	363	50	7
280	12	Northeast	994	PearApple	363	86	50
281	5	Midwest	191	Grey Gummies	446	43	86
282	1	South	748	Crocodile Tears	143	89	58
283	2	West	907	Rotpunkt	220	7	60
284	2	Northeast	656	Ultra-Salty Chips	454	90	26
285	1	Midwest	740	Red Hot Chili Peppers	233	52	42
286	12	South	305	Ultra-Salty Chips	454	68	83
287	12	West	260	Crocodile Tears	143	18	43
288	2	Northeast	471	Meat B Gone	495	63	65
289	5	West	421	Green Lightning	161	20	91
290	11	Northeast	407	Giant Gummies	347	39	63
291	4	West	583	GMO Guardian	176	9	54
292	12	West	940	Power Gels	193	7	42
293	2	South	519	Just The Fruit	160	23	14
294	6	South	623	Organiks	257	22	12
295	6	South	476	Power Gels	193	60	58
296	5	Midwest	747	Yellow Zonkers	134	14	38
297	4	West	647	Green Lightning	161	45	64
298	6	Midwest	578	Organiks	257	12	44
299	7	Midwest	462	GMO Guardian	176	66	66
300	7	Midwest	229	Grey Gummies	446	42	92
301	7	Midwest	196	Crocodile Tears	143	30	29
302	8	South	459	Farm Fresh	365	22	81
303	9	South	450	PearApple	363	55	74
304	5	Midwest	435	Organiks	257	56	100
305	3	West	953	Only Pancakes	413	26	3
306	4	West	290	Organiks	257	79	65
307	12	West	952	Just The Fruit	160	60	27
308	11	South	132	Farm Fresh	365	71	25
309	5	Northeast	259	Funky Pops	380	46	81
310	6	West	951	Just The Fruit	160	66	55
311	5	Midwest	444	Red Rock Candy	189	49	93
312	6	South	286	Purple Pain	105	48	33
313	11	South	745	GMO Guardian	176	48	87
314	10	West	847	Purple Pain	105	24	74
315	5	Northeast	152	Nap Be Gone	500	12	72
316	7	West	584	Meat B Gone	495	63	93
317	6	South	900	Mr Greens	447	35	79
318	4	South	902	PearApple	363	23	37
319	6	Northeast	986	Grey Gummies	446	78	98
320	9	South	340	Panda Gummies	104	84	29
321	5	Midwest	211	Rotpunkt	220	42	42
322	3	West	698	Mr Greens	447	25	44
323	3	Northeast	552	Grey Gummies	446	99	7
324	9	South	748	Grey Gummies	446	66	92
325	12	West	394	Cheezos	372	59	82
326	7	Midwest	656	Rotpunkt	220	8	44
327	12	South	990	Organiks	257	28	34
328	3	Midwest	323	Yellow Zonkers	134	89	47
329	4	Northeast	732	Farm Fresh	365	66	10
330	12	South	924	Power Gels	193	33	65
331	12	Midwest	294	Purple Pain	105	68	12
332	11	West	894	Red Hot Chili Peppers	233	86	86
333	7	South	776	Red Rock Candy	189	9	66
334	3	Midwest	639	Farm Fresh	365	30	50
335	6	West	52	Orange Creepies	300	30	93
336	5	West	910	Nap Be Gone	500	39	28
337	1	West	416	Purple Pain	105	95	64
338	6	Northeast	204	Yellow Zonkers	134	61	1
339	7	Northeast	106	Ultra-Salty Chips	454	36	78
340	10	Midwest	602	GMO Guardian	176	21	33
341	10	South	328	Just The Fruit	160	20	79
342	7	South	803	Cheezos	372	59	67
343	8	West	117	Only Pancakes	413	27	92
344	8	West	173	Grey Gummies	446	7	49
345	12	West	95	Funky Pops	380	38	32
346	5	South	38	Crocodile Tears	143	39	81
347	2	Northeast	337	Nap Be Gone	500	5	25
348	3	Midwest	734	Green Lightning	161	42	77
349	8	Midwest	592	Future Toast	253	49	33
350	6	South	69	Funky Pops	380	14	91
351	7	South	397	Cheezos	372	54	35
352	9	West	763	Farm Fresh	365	15	39
353	9	West	919	Orange Creepies	300	60	8
354	9	Northeast	89	Funky Pops	380	96	56
355	7	West	154	PearApple	363	33	55
356	9	Midwest	410	Panda Gummies	104	48	78
357	9	South	142	Panda Gummies	104	95	5
358	11	Northeast	83	Future Toast	253	51	71
359	2	Northeast	84	Farm Fresh	365	9	23
360	8	Northeast	29	Orange Creepies	300	62	84
361	8	Northeast	933	Green Lightning	161	38	88
362	11	Midwest	16	Organiks	257	33	96
363	1	South	493	Green Lightning	161	30	28
364	1	Midwest	856	Funky Pops	380	14	15
365	1	Midwest	775	GMO Guardian	176	69	26
366	3	West	249	Giant Gummies	347	80	52
367	1	Northeast	831	Ultra-Salty Chips	454	28	53
368	10	South	372	Red Hot Chili Peppers	233	58	97
369	11	South	567	Funky Pops	380	83	45
370	6	South	398	Panda Gummies	104	92	13
371	6	South	529	Big Waffle	268	43	35
372	7	West	320	Giant Gummies	347	29	11
373	1	South	507	Red Hot Chili Peppers	233	80	73
374	2	West	518	Grey Gummies	446	7	76
375	9	West	25	Grey Gummies	446	21	43
376	3	South	901	Funky Pops	380	67	16
377	4	South	226	PearApple	363	63	39
378	10	South	226	Just The Fruit	160	83	86
379	1	South	197	Purple Pain	105	40	18
380	8	Northeast	411	Organiks	257	67	84
381	4	Midwest	431	Meat B Gone	495	63	11
382	7	South	904	Meat B Gone	495	79	46
383	1	Northeast	685	Organiks	257	47	68
384	8	Northeast	732	Future Toast	253	72	13
385	8	West	215	Green Lightning	161	50	73
386	9	South	728	Farm Fresh	365	97	98
387	10	South	877	Ultra-Salty Chips	454	48	70
388	5	Midwest	699	Giant Gummies	347	21	96
389	10	Midwest	539	Only Pancakes	413	86	55
390	7	Midwest	834	Mr Greens	447	78	10
391	9	Midwest	201	Yellow Zonkers	134	10	52
392	6	Midwest	934	Purple Pain	105	92	33
393	11	South	286	Ultra-Salty Chips	454	4	97
394	6	South	774	Power Gels	193	74	29
395	8	Midwest	662	Grey Gummies	446	42	96
396	1	Midwest	524	Giant Gummies	347	84	96
397	8	Midwest	948	Grey Gummies	446	37	93
398	3	West	164	Red Hot Chili Peppers	233	8	30
399	4	West	250	Grey Gummies	446	98	64
400	3	West	832	Purple Pain	105	21	81
401	3	Midwest	307	Red Rock Candy	189	48	45
402	4	West	288	Meat B Gone	495	93	25
403	9	South	62	Nap Be Gone	500	62	47
404	11	West	967	Power Gels	193	8	54
405	8	South	142	Funky Pops	380	73	85
406	12	Northeast	104	Funky Pops	380	46	81
407	2	South	242	Ultra-Salty Chips	454	51	63
408	11	South	880	Funky Pops	380	75	12
409	6	Midwest	781	Yellow Zonkers	134	67	19
410	3	Northeast	598	Panda Gummies	104	18	15
411	11	South	908	Future Toast	253	46	85
412	6	Midwest	507	Meat B Gone	495	43	15
413	11	Midwest	830	Giant Gummies	347	63	63
414	3	South	801	Rotpunkt	220	90	71
415	9	Midwest	341	Red Rock Candy	189	76	30
416	7	Northeast	103	Red Rock Candy	189	77	77
417	12	West	89	Yellow Zonkers	134	81	91
418	5	South	836	Cheezos	372	86	63
419	10	South	457	Orange Creepies	300	40	91
420	12	South	546	Purple Pain	105	68	86
421	12	Midwest	850	Giant Gummies	347	82	97
422	3	Midwest	309	Nap Be Gone	500	100	33
423	4	West	856	Big Waffle	268	57	87
424	10	Midwest	256	Mr Greens	447	78	63
425	9	South	193	Orange Creepies	300	43	54
426	8	Northeast	958	PearApple	363	31	72
427	10	Midwest	78	Ultra-Salty Chips	454	94	46
428	6	West	730	Farm Fresh	365	100	50
429	9	South	443	Mr Greens	447	73	15
430	1	Midwest	31	Crocodile Tears	143	31	70
431	5	Midwest	32	Mr Greens	447	28	72
432	4	Northeast	274	Big Waffle	268	26	77
433	7	Northeast	359	Big Waffle	268	85	72
434	3	Midwest	965	Cheezos	372	76	36
435	6	Northeast	587	Green Lightning	161	11	19
436	11	South	70	Yellow Zonkers	134	42	56
437	6	Midwest	252	Red Hot Chili Peppers	233	42	32
438	3	South	51	Purple Pain	105	87	56
439	11	South	59	Red Rock Candy	189	53	78
440	8	Midwest	937	Crocodile Tears	143	2	8
441	11	Northeast	304	Future Toast	253	65	12
442	3	West	282	Red Rock Candy	189	19	24
443	11	South	279	Future Toast	253	2	43
444	4	Northeast	971	Mr Greens	447	48	99
445	1	Northeast	454	Crocodile Tears	143	47	57
446	11	Midwest	406	GMO Guardian	176	77	25
447	3	Northeast	317	PearApple	363	47	20
448	3	South	258	Purple Pain	105	88	29
449	7	South	616	Power Gels	193	52	91
450	2	Midwest	976	Green Lightning	161	30	3
451	6	West	180	Big Waffle	268	53	67
452	5	West	897	Cheezos	372	95	82
453	1	South	231	Nap Be Gone	500	5	46
454	5	Midwest	694	Cheezos	372	5	22
455	3	Midwest	945	Yellow Zonkers	134	84	91
456	11	South	609	Orange Creepies	300	50	11
457	3	South	896	Organiks	257	43	94
458	6	Midwest	497	Red Hot Chili Peppers	233	98	82
459	6	Northeast	995	Nap Be Gone	500	88	51
460	3	South	556	Purple Pain	105	61	77
461	12	Northeast	244	Yellow Zonkers	134	93	34
462	11	Midwest	15	Future Toast	253	35	25
463	2	Northeast	761	Organiks	257	62	19
464	9	Northeast	345	PearApple	363	89	45
465	5	South	937	Green Lightning	161	17	24
466	1	West	387	Crocodile Tears	143	54	62
467	10	West	361	Orange Creepies	300	11	21
468	9	South	11	Giant Gummies	347	59	33
469	1	West	346	Big Waffle	268	38	75
470	11	South	408	Rotpunkt	220	17	100
471	8	South	257	Power Gels	193	58	73
472	1	Midwest	781	Yellow Zonkers	134	59	100
473	4	South	950	Just The Fruit	160	87	47
474	8	Midwest	849	Mr Greens	447	55	37
475	4	Midwest	668	Big Waffle	268	97	70
476	7	South	413	Crocodile Tears	143	36	93
477	5	Northeast	733	Orange Creepies	300	61	41
478	12	South	258	Farm Fresh	365	58	29
479	8	South	314	Just The Fruit	160	61	20
480	5	West	964	Green Lightning	161	52	20
481	6	South	875	Giant Gummies	347	90	95
482	10	Midwest	98	Meat B Gone	495	88	96
483	8	South	650	Meat B Gone	495	94	70
484	6	Midwest	601	Mr Greens	447	98	22
485	2	Midwest	72	Crocodile Tears	143	91	75
486	5	Northeast	567	Red Hot Chili Peppers	233	88	42
487	11	South	659	Nap Be Gone	500	59	76
488	7	South	643	Cheezos	372	71	42
489	8	South	154	Crocodile Tears	143	24	25
490	12	South	958	Meat B Gone	495	29	99
491	12	Northeast	781	Red Hot Chili Peppers	233	28	35
492	9	South	601	Nap Be Gone	500	1	17
493	1	Midwest	485	Only Pancakes	413	38	29
494	12	Midwest	769	Giant Gummies	347	70	25
495	9	South	148	Panda Gummies	104	21	32
496	6	West	991	Giant Gummies	347	94	6
497	12	Midwest	467	Funky Pops	380	65	48
498	9	South	298	Panda Gummies	104	39	20
499	7	West	73	Panda Gummies	104	25	15

Additional clarification regarding Week 6 ETL Candy Assignment.

The difficult part about this week's work is not necessarily the SQL, it's the Extract-Transform-Load part.

First a few general comments on INSERT INTO and populating a database:

INSERT INTO destinationTable("x","y","z")

SELECT a,b,c FROM sourceTable;

Is different from

INSERT INTO desinationTable ("x","y","z")

VALUES (1,2,3);

The latter defines and inserts the VALUES on the spot. But in both the order is extremely important.

In the former and certainly when conducting ETL, the two tables, source and destination may not have the same column names, but it is essential that in the statement that you carefully choose the destinationTable column names for INSERT INTO and the sourceTable for SELECT so they match. But choosing x,y,z for INSERT INTO and then a,b,c for SELECT is the same as INSERT INTO z,y,x with SELECT c,b,a.

Also, as is the case in this Candy assignment, the data itself may need to be manipulated/multiplied/added/etc in some way to get it into a standard form across years.

For example, the following gets FirstName and LastName directly from sourceTable. There is NO SUCH field as AnnualSalary in sourceTable, however there is a MonthlySalary. So the code then multiplies MonthlySalary by 12 to get AnnualSalary. Here you have to be careful about the commas. Until the first comma, FirstName and LastName are being INSERTed INTO FirstName and LastName respectively, after the second comma, the calculation is being INSERTed INTO AnnualSalary.

After AnnualSalary is calculated from “MonthlySalary”, we see that there are two values for bonus pay, Bonus1 and Bonus2. We can calculate TotalBonusPay by adding the two values together in the SELECT statement.

CREATE TABLE destinationTable (FirstName TEXT, LastName TEXT, AnnualSalary INTEGER, TotalBonusPay INTEGER);

INSERT INTO destinationTable("FirstName","LastName","AnnualSalary","TotalBonusPay")

SELECT "FirstName","LastName","MonthlySalary" * 12, "Bonus1" + "Bonus2" FROM sourceTable;

Now let’s look specifically at our Candy dataset.

If we had 'perfect' data, an INSERT INTO and SELECT statement to populate stagingTable might look something like this, 11 fields in stagingTable from 11 fields in pd2017, all nicely arranged with the same names, same values. However, note they sometimes use different field names:

stagingTable uses Product_Name and unitPrice, while pd2017 uses Product and Per-Unit_Price.

What’s important here is that the field names for INSERT INTO correspond to stagingTable (where we’re inserting the data) and SELECT correspond to pd2017 (or pd2018 or pd2019).

INSERT INTO stagingTable("monthInt", "state", "country", "region", "Product_Name", "unitPrice" –you need to fill this in here)

SELECT "Month", "State", "Country", "Region", "Product", "Per-Unit_price", "Quantity", "Order_Total" FROM pd2017;

HOWEVER, rarely does data comes in a neat format. So you first need to look at the data (you can do this in Excel). Start with 2017 and you'll see the following columns, not 11 fields, only 8:

2017:

2018:

2019:

You should note how the fields/columns changed over the years. Attention: the following list is NOT complete. Important information is given in each year's Data Notes (part c) and conduct your own analysis of the differences in data. This is the heart of the ETL process and you will document this in your one page write up as a part of this assignment.

Now look at the stagingTable structure:

Each year MUST conform to this stagingTable structure so that all three years can be analyzed.

· However, we're not going to 'make up' customer_id where there is none.

· Also don’t worry about adding data to country where it might be listed as ‘null’.

· The most important fields that must be properly populated in stagingTable for proper analysis are quantity and orderTotal.

2017 will be imported relatively straightforward via an INSERT INTO and SELECT command.

2018 and 2019, however, will require you to choose the correct fields (from stagingTable) in the INSERT INTO command and then SELECT fields FROM pd2018 or pd2019 which will sometimes require some basic math to 'transform' the data into a common, usable format.

Again, this ‘Additional Clarification’ does not describe ALL of the differences in data that you will need to address. Properly identifying differences and discrepancies and transforming the data into a usable format is essential to the ETL task.

Finally, you're not making up any data, just transforming what is there. Also note that 'year' is not an element in any of the individual year table, which is why you need an UPDATE command after your INSERT INTO and SELECT command after each year. This for 2018:

UPDATE stagingTable SET yearInt=2018 WHERE yearInt ISNULL;

–Skeleton Candy Part 1 – extract from 2017, 2018, 2019 tables and put into stagingTable –Students, see notes below where it says –you need to fill this in here –Create the staging table DROP TABLE IF EXISTS stagingTable; CREATE TABLE stagingTable ( yearInt INT(4), monthInt INT(2), –there will be more you need to fill in here ); –Insert 2017 Data INSERT INTO stagingTable("monthInt", "state", "country", "region", "Product_Name", "unitPrice" –you need to fill this in here) SELECT "Month", "State", "Country", "Region", "Product", "Per-Unit_price", "Quantity", "Order_Total" FROM pd2017 ; UPDATE stagingTable SET yearInt=2017; –Insert 2018 Data INSERT INTO stagingTable( — you need to fill this in here –) SELECT … FROM pd2018 ; UPDATE stagingTable SET yearInt=2018 WHERE yearInt ISNULL; –Insert 2019 Data INSERT INTO stagingTable(– you need to fill this in here –) SELECT … FROM pd2019 ; UPDATE stagingTable ( — you need to fill this in here ); SELECT * FROM stagingTable;

UMGC IFSM 330 Candy Assignment

Attachments:

· 2017_product_data_students-final.csv

· 2018_product_data_students-final.csv

· 2019_product_data_students-final.csv

· Candy_part_1_skeleton_for_students.SQL

In this assignment, you will produce SQL code which scrubs and imports each of the three years’ worth of data, and produces an output file called stagingTable.

Along with these instructions, there is another document, ‘Additional Clarification on the Week 6 Candy Assignment’. Please read that document carefully.

Let’s get started!

Part A: Upload all the files you will need to SQLlite:

1. Import the file called “2017_product_data_students.csv” to SQLiteonline.com. When you import it, give it the table name “pd2017” (no quotes) and set the column name to “First line.”

2. Import “2018_product_data_students.csv” as “pd2018”

3. Import “2019_product_data_students.csv” as “pd2019”

Part B: Extract and Transform your data

Your job is to use SQL to perform an ETL which will accomplish the following:

1. Start with the skeleton starter script we give you, attached to this assignment. Modify the CREATE TABLE command so the schema is as follows:

Computer code

Notes about what you need to do

DROP TABLE IF EXISTS stagingTable;

Leave this code alone – it ensures you a fresh start

CREATE TABLE stagingTable (

yearInt INT(4),

monthInt INT(2),

–there will be more you need to fill in here

);

Right now this creates stagingTable with only two fields, the yearInt and monthInt. Modify the code where highlighted in yellow to correspond to the schema below.

And of course, when you’re done coding, remove the ‘– there will be more you need to fill in here’ comment

2. Get the 2017 bit of the script working.

Computer code	Notes about what you need to do
–Insert 2017 Data	This is a comment telling you the 2017 data is going to be inserted here
INSERT INTO stagingTable("monthInt", "state", "country", "region", "Product_Name", "unitPrice" –you need to fill this in here)	After you have created stagingTable, this is the first half of a command that will insert the data into stagingTable. You need to replace the yellow highlighted material with your own code to complete it.
SELECT "Month", "State", "Country", "Region", "Product", "Per-Unit_price", "Quantity", "Order_Total" FROM pd2017 ;	This is the second half of a command that will insert data into stagingTable. You don’t need to change anything here.
UPDATE stagingTable SET yearInt=2017;	This sets the year to 2017 for this data. You don’t need to change this.

3. Get the 2018 part of the script working.

Computer code	Notes about what you need to do
–Insert 2018 Data	Comment.
INSERT INTO stagingTable(–you need to fill this in here)	This is the first half of a command that will insert the data into stagingTable. You need to replace the yellow highlighted material with your own code to complete it. See the rules below for more details.
SELECT … FROM pd2018 ;	This is the second half of a command that will insert data into stagingTable. You need to replace the yellow highlighted material.
UPDATE stagingTable SET yearInt=2018 WHERE yearInt ISNULL;	This sets the year to 2018 for any new entries which don’t yet have a year. You don’t need to change this.

4. Get the 2019 part of the script working.

Computer code	Notes about what you need to do
–Insert 2019 Data	Comment.
INSERT INTO stagingTable(–you need to fill this in here)	You need to replace the yellow highlighted material with your own code to complete it. See the rules below for more details.
SELECT … FROM pd2019 ;	You need to replace the yellow highlighted material.
UPDATE stagingTable …;	You need to replace the yellow highlighted material.

5. The script will load it into one final table and call it stagingTable

6. Run the checksum script to verify you have the stagingTable calculated correctly.

You should do this all in SQLlite. You should not export to Excel and do your manipulations in Excel.

Part C: 2017 Data Notes

Your field definitions follow:

· Month: integer, corresponds to the month of the sale. For example, 5 = May.

· Country: text, should all be USA. (All data in this exercise should be USA.)

· Region: text, represents the regions within the country.

· State: text, USPS state abbreviations. Each state is within one region.

· Product: text. This is the name of a packaged food product.

· Quantity: integer. This represents how many items were in that particular order. The first order here was for 49 packages of Orange Creepies.

· Order Total: integer. This is the per-unit price x the quantity. The first line here indicates that 300 x 49 = 14700 (or $147.00) was the price of the first order.

Table 1 Sample of order data from 2017

	Month	Country	Region	State	Product	Per-Unit Price	Quantity	Order Total
0	7	USA	West	CA	Orange Creepies	300	49	14700
1	9	USA	Northeast	RI	Farm Fresh	365	49	17885
2	10	USA	South	TN	Farm Fresh	365	10	3650
3	12	USA	South	FL	Organiks	257	27	6939
4	12	USA	South	MD	PearApple	363	83	30129
5	8	USA	South	KY	Big Waffle	268	5	1340

2018 Data Notes:

Your order 2018 data is contained in the attached file, “2018_product_data_students.csv”

A sample of this file’s data is contained below as Table 2 Sample of order data from 2018. (Note your file may or may not have the same data in it.)

Your field definitions follow:

· Month: integer, corresponds to the month of the sale. For example, 5 = May.

· Region: text, represents the regions within the country.

· Customer_ID: integer, represents the customer’s unique Customer ID number.

· Product: text. This is the name of a packaged food product.

· The first line here reflects that PearApple has a first shipment of 25 units, and a second shipment of 92 unit, all within the month of January, for a total of 25 + 92 = 117 units.

Table 2 Sample of order data from 2018

	Month	Region	Customer_ID	Product	Per-Unit Price	Quantity_1	Quantity_2
0	1	Midwest	280	PearApple	363	25	92
1	5	West	545	Orange Creepies	300	87	79
2	8	Northeast	131	Future Toast	253	90	6
3	4	Midwest	920	Farm Fresh	365	33	74
4	12	South	358	Rotpunkt	220	4	13
5	1	South	855	GMO Guardian	176	17	45

2019 Data Notes:

Your order 2019 data is contained in the attached file, “2019_product_data_students.csv.”

A sample of this file’s data is contained below as Table 3 Sample of order data from 2019. (Note your file may or may not have the same data in it.)

Your field definitions follow:

· Month: integer, corresponds to the month of the sale. For example, 5 = May.

· Country: text, represents the country of the customer. Should all be USA.

· Region: text, represents the regions within the country.

· State: USPS code for the 50 United States.

· Product: text. Same as previous years.

· Per-unit price: integer. This represents the per-unit price in cents; same as previous years.

· Quantity: This represents how many items were in that particular order. The first order here was for 95 packages of Only Pancakes.

· Order 0, on the first line, of 95 Only Pancakes to Florida, did qualify for the Quantity Discount, because an order quantity of 95 exceeded the 90 threshold. The Quantity Discount has been computed as 3924, or 10% of 39235. In this case, the final order total would be 39,235 – 3,924 = 35,311 (or $353.11).

· Order 4, on the fifth line, of 31 Future Toasts to North Carolina, did not qualify for the Quantity Discount. Therefore, the Order total would simply be the Order subtotal.

Table 3 Sample of order data from 2019

	Month	Country	Region	State	Product	Per-Unit Price	Quantity	Order Subtotal	Quantity Discount
0	9	USA	South	FL	Only Pancakes	413	95	39235	3924
1	6	USA	West	HI	Big Waffle	268	93	24924	2492
2	5	USA	Northeast	RI	Grey Gummies	446	95	42370	4237
3	9	USA	Midwest	NE	Funky Pops	380	100	38000	3800
4	11	USA	South	NC	Future Toast	253	31	7843	0
5	8	USA	West	WA	Mr Greens	447	76	33972	0
6	8	USA	South	MD	Giant Gummies	347	93	32271	3227

Part D: Check Your Own Work

1. You can run the following SQL code on your staging table. There is nothing to turn in from this bit. It should yield the following first few rows:

Select region, yearint, monthInt, count(*) from stagingTable where monthInt = 5 group by region, yearInt, monthInt;

2. You can also run the following code to debug. You should get the following rows:

Select yearInt, monthInt, state, customer_id, product_name, orderTotal from stagingTable

where product_name = 'Big Waffle' and monthint=4

order by product_name, yearInt, monthInt, state, customer_id, orderTotal;

select sum(yearInt * monthInt * orderTotal)%2341 as checksum from stagingTable;

3. Once you get the result of your CHECKSUM look at table below for ways to troubleshoot any issues with your ETL statements.

If you get this checksum:	Hint:
1021	No further troubleshooting needed, go ahead, and submit your 3 deliverables
315	Look at your calculation for OrderTotal for 2019
349	Look at your calculation for OrderTotal for 2018 AND 2019
1944	Look at your calculation for OrderTotal for 2018 AND 2019 (hint: subtotal is NOT equal to ordertotal)
1767	Look at how your calculation for the quantity total for 2018. Look at your calculation for OrderTotal for 2019
953	Look at how your calculation for the quantity total for 2018. Look at your calculation for OrderTotal for 2018 AND 2019
Other	Look carefully at your syntax for every field. Run your 2017 insert first, then run your 2018 insert, then your 2019 insert statement.

TURN IN:

1. Your output file, called “XX_output_final.csv” where XX are your initials.

2. All the SQL code you used to execute this.

3. A document that contains

a. CHECKSUM: XXX where XXX is the checksum number produced. Put this in big font right on the top.

IFSM 330 Week 6 Candy v04 13

Having Trouble Meeting Your Deadline?

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A

QUALITATIVE Journal Submit Article Reviews Here

week 3 assignment

Discussion + APA format +

week 4 project

Corey’s Home wk 3 CMGT/582

Ethical Issues of Modern Information System

Payments

QUICK LINKS

Discover

Help

Having Trouble Meeting Your Deadline?

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A

Similar Posts

Payments

QUICK LINKS

Discover

Help

Get in touch