text: /*---------------------------------------------------------------------
  
  1. Use the following SQL statement to create the 'sales' table first
     in the SQL window.
  
  	create table sales
  	(
  		cust	varchar(20),
  		prod	varchar(20),
  		day	integer,
  		month	integer,
  		year	integer,
  		state	char(2),
  		quant	integer
  	)
  	
  2. To load the data into the 'sales' table, copy and paste the following
     INSERT statements and execute.  To verify, run the following SQL
     statement, and it should return 500 (rows).
     
     	select count(*) from sales;
     	
  3. To delete all of the rows in the table:
  	
  	truncate table sales;
  
  4. In a rare case, if you need to remove the 'sales' table completely:
  
  	drop table sales;
  
  ---------------------------------------------------------------------*/
  
  insert into sales values ('Bloom', 'Pepsi', 2, 12, 2001, 'NY', 4232);
  insert into sales values ('Knuth', 'Bread', 23, 5, 2005, 'PA', 4167);
  insert into sales values ('Emily', 'Pepsi', 22, 1, 2006, 'CT', 4404);
  insert into sales values ('Emily', 'Fruits', 11, 1, 2000, 'NJ', 4369);
  insert into sales values ('Helen', 'Milk', 7, 11, 2006, 'CT', 210);
  insert into sales values ('Emily', 'Soap', 2, 4, 2002, 'CT', 2549);
  insert into sales values ('Bloom', 'Eggs', 30, 11, 2000, 'NJ', 559);
  insert into sales values ('Bloom', 'Yogurt', 25, 7, 2004, 'PA', 17);
  insert into sales values ('Helen', 'Pepsi', 14, 3, 2002, 'NJ', 3891);
  insert into sales values ('Emily', 'Bread', 28, 9, 2005, 'PA', 42);
  insert into sales values ('Sam', 'Cookies', 20, 11, 2004, 'NY', 3376);
  insert into sales values ('Knuth', 'Milk', 5, 2, 2007, 'PA', 126);
  insert into sales values ('Helen', 'Coke', 11, 4, 2001, 'NY', 668);
  insert into sales values ('Emily', 'Butter', 5, 7, 2005, 'NJ', 3840);
  insert into sales values ('Emily', 'Yogurt', 7, 10, 2005, 'NY', 730);
  insert into sales values ('Sam', 'Soap', 12, 2, 2001, 'NJ', 165);
  insert into sales values ('Knuth', 'Coke', 6, 1, 2003, 'CT', 1557);
  insert into sales values ('Sam', 'Milk', 9, 8, 2001, 'NY', 1132);
  insert into sales values ('Helen', 'Yogurt', 6, 2, 2000, 'PA', 4001);
  insert into sales values ('Sam', 'Milk', 6, 1, 2003, 'PA', 2298);
  insert into sales values ('Knuth', 'Pepsi', 21, 12, 2008, 'CT', 653);
  insert into sales values ('Knuth', 'Eggs', 19, 12, 2006, 'NJ', 1339);
  insert into sales values ('Helen', 'Coke', 19, 10, 2002, 'NJ', 2662);
  insert into sales values ('Knuth', 'Milk', 25, 3, 2001, 'CT', 58);
  insert into sales values ('Bloom', 'Yogurt', 3, 4, 2001, 'NJ', 1203);
  insert into sales values ('Helen', 'Milk', 6, 11, 2001, 'NY', 2422);
  insert into sales values ('Knuth', 'Yogurt', 22, 4, 2005, 'CT', 301);
  insert into sales values ('Helen', 'Pepsi', 24, 9, 2004, 'CT', 2768);
  insert into sales values ('Helen', 'Fruits', 28, 6, 2005, 'PA', 2811);
  insert into sales values ('Knuth', 'Yogurt', 18, 9, 2001, 'NY', 3705);
  insert into sales values ('Helen', 'Pepsi', 1, 10, 2005, 'PA', 1407);
  insert into sales values ('Helen', 'Cookies', 28, 8, 2002, 'NY', 3494);
  insert into sales values ('Helen', 'Cookies', 23, 12, 2004, 'CT', 1194);
  insert into sales values ('Emily', 'Butter', 25, 7, 2000, 'PA', 4008);
  insert into sales values ('Knuth', 'Fruits', 4, 2, 2005, 'PA', 2430);
  insert into sales values ('Emily', 'Cookies', 3, 11, 2004, 'NJ', 2497);
  insert into sales values ('Bloom', 'Coke', 7, 2, 2000, 'NY', 1229);
  insert into sales values ('Emily', 'Bread', 4, 6, 2001, 'CT', 1626);
  insert into sales values ('Helen', 'Soap', 21, 7, 2004, 'PA', 4107);
  insert into sales values ('Helen', 'Coke', 10, 2, 2002, 'NJ', 4237);
  insert into sales values ('Emily', 'Soap', 4, 9, 2003, 'CT', 70);
  insert into sales values ('Knuth', 'Soap', 29, 5, 2001, 'PA', 2961);
  insert into sales values ('Knuth', 'Cookies', 12, 6, 2007, 'NJ', 2615);
  insert into sales values ('Knuth', 'Coke', 9, 5, 2005, 'NY', 1946);
  insert into sales values ('Helen', 'Milk', 10, 5, 2001, 'PA', 1457);
  insert into sales values ('Emily', 'Milk', 3, 9, 2008, 'NJ', 3839);
  insert into sales values ('Helen', 'Yogurt', 24, 2, 2004, 'NY', 900);
  insert into sales values ('Bloom', 'Coke', 6, 10, 2008, 'PA', 2867);
  insert into sales values ('Bloom', 'Soap', 6, 1, 2005, 'CT', 4623);
  insert into sales values ('Helen', 'Fruits', 25, 12, 2006, 'CT', 4015);
  insert into sales values ('Knuth', 'Fruits', 19, 4, 2007, 'NY', 2740);
  insert into sales values ('Emily', 'Eggs', 3, 11, 2006, 'PA', 1060);
  insert into sales values ('Bloom', 'Milk', 8, 9, 2000, 'NJ', 1106);
  insert into sales values ('Bloom', 'Milk', 19, 4, 2003, 'NY', 3516);
  insert into sales values ('Emily', 'Bread', 23, 12, 2005, 'NY', 2071);
  insert into sales values ('Sam', 'Yogurt', 28, 1, 2005, 'NJ', 2293);
  insert into sales values ('Sam', 'Soap', 23, 11, 2005, 'PA', 399);
  insert into sales values ('Emily', 'Fruits', 31, 8, 2005, 'PA', 3913);
  insert into sales values ('Emily', 'Yogurt', 28, 3, 2005, 'NY', 3822);
  insert into sales values ('Sam', 'Fruits', 15, 9, 2006, 'NJ', 4793);
  insert into sales values ('Bloom', 'Soap', 7, 6, 2005, 'PA', 3404);
  insert into sales values ('Emily', 'Fruits', 14, 12, 2003, 'NY', 3864);
  insert into sales values ('Helen', 'Pepsi', 14, 12, 2005, 'NY', 3002);
  insert into sales values ('Sam', 'Yogurt', 23, 6, 2006, 'CT', 363);
  insert into sales values ('Bloom', 'Milk', 15, 10, 2008, 'CT', 4870);
  insert into sales values ('Sam', 'Soap', 20, 11, 2004, 'NJ', 989);
  insert into sales values ('Sam', 'Butter', 20, 10, 2006, 'NY', 1966);
  insert into sales values ('Sam', 'Fruits', 15, 10, 2005, 'CT', 2802);
  insert into sales values ('Bloom', 'Fruits', 26, 11, 2006, 'NJ', 1832);
  insert into sales values ('Emily', 'Cookies', 30, 7, 2005, 'NY', 1844);
  insert into sales values ('Bloom', 'Fruits', 29, 7, 2005, 'NY', 3653);
  insert into sales values ('Helen', 'Milk', 6, 1, 2003, 'CT', 4429);
  insert into sales values ('Knuth', 'Fruits', 16, 9, 2003, 'PA', 1313);
  insert into sales values ('Sam', 'Milk', 7, 4, 2001, 'CT', 811);
  insert into sales values ('Helen', 'Pepsi', 23, 4, 2007, 'CT', 3609);
  insert into sales values ('Emily', 'Cookies', 9, 6, 2002, 'CT', 4925);
  insert into sales values ('Knuth', 'Soap', 16, 12, 2001, 'NY', 4307);
  insert into sales values ('Bloom', 'Fruits', 9, 4, 2000, 'PA', 570);
  insert into sales values ('Emily', 'Bread', 17, 11, 2001, 'PA', 2565);
  insert into sales values ('Helen', 'Eggs', 17, 4, 2006, 'CT', 1807);
  insert into sales values ('Emily', 'Milk', 12, 11, 2002, 'NY', 4986);
  insert into sales values ('Knuth', 'Pepsi', 6, 9, 2006, 'CT', 3760);
  insert into sales values ('Knuth', 'Cookies', 17, 7, 2003, 'CT', 4994);
  insert into sales values ('Sam', 'Pepsi', 13, 9, 2002, 'NJ', 3877);
  insert into sales values ('Helen', 'Eggs', 7, 2, 2003, 'PA', 813);
  insert into sales values ('Helen', 'Butter', 21, 7, 2001, 'NJ', 2086);
  insert into sales values ('Helen', 'Bread', 21, 5, 2000, 'NY', 389);
  insert into sales values ('Knuth', 'Soap', 13, 4, 2008, 'CT', 1160);
  insert into sales values ('Bloom', 'Butter', 16, 8, 2003, 'NY', 1054);
  insert into sales values ('Sam', 'Bread', 13, 11, 2008, 'PA', 93);
  insert into sales values ('Emily', 'Soap', 10, 10, 2000, 'NJ', 4081);
  insert into sales values ('Sam', 'Eggs', 20, 9, 2008, 'PA', 964);
  insert into sales values ('Helen', 'Fruits', 27, 2, 2007, 'CT', 442);
  insert into sales values ('Helen', 'Yogurt', 19, 1, 2007, 'NJ', 2096);
  insert into sales values ('Sam', 'Eggs', 14, 3, 2001, 'NY', 1744);
  insert into sales values ('Emily', 'Cookies', 27, 11, 2006, 'NJ', 3719);
  insert into sales values ('Emily', 'Fruits', 3, 11, 2000, 'NY', 859);
  insert into sales values ('Helen', 'Fruits', 3, 5, 2006, 'NY', 2774);
  insert into sales values ('Emily', 'Fruits', 6, 10, 2000, 'NY', 3027);
  insert into sales values ('Emily', 'Milk', 5, 4, 2005, 'PA', 3211);
  insert into sales values ('Knuth', 'Butter', 1, 4, 2007, 'NY', 839);
  insert into sales values ('Helen', 'Butter', 30, 3, 2008, 'PA', 1786);
  insert into sales values ('Bloom', 'Yogurt', 6, 10, 2000, 'NJ', 2788);
  insert into sales values ('Helen', 'Bread', 11, 10, 2007, 'NJ', 2513);
  insert into sales values ('Emily', 'Cookies', 28, 10, 2005, 'NY', 1656);
  insert into sales values ('Emily', 'Bread', 4, 9, 2000, 'PA', 1572);
  insert into sales values ('Sam', 'Bread', 18, 1, 2002, 'NJ', 1378);
  insert into sales values ('Emily', 'Pepsi', 14, 1, 2004, 'NJ', 2591);
  insert into sales values ('Knuth', 'Fruits', 6, 7, 2001, 'CT', 3756);
  insert into sales values ('Bloom', 'Soap', 3, 11, 2002, 'NJ', 4364);
  insert into sales values ('Sam', 'Milk', 7, 11, 2000, 'CT', 1607);
  insert into sales values ('Emily', 'Yogurt', 9, 6, 2006, 'NY', 3174);
  insert into sales values ('Emily', 'Butter', 23, 2, 2003, 'CT', 212);
  insert into sales values ('Helen', 'Butter', 1, 1, 2006, 'NY', 4281);
  insert into sales values ('Helen', 'Bread', 26, 5, 2006, 'CT', 1406);
  insert into sales values ('Helen', 'Bread', 15, 6, 2003, 'NJ', 1687);
  insert into sales values ('Bloom', 'Pepsi', 26, 5, 2001, 'NJ', 2367);
  insert into sales values ('Helen', 'Pepsi', 23, 6, 2000, 'PA', 1456);
  insert into sales values ('Emily', 'Eggs', 3, 9, 2003, 'NJ', 3126);
  insert into sales values ('Helen', 'Butter', 26, 11, 2006, 'NY', 1685);
  insert into sales values ('Bloom', 'Milk', 31, 10, 2003, 'PA', 553);
  insert into sales values ('Helen', 'Pepsi', 20, 10, 2002, 'NJ', 3817);
  insert into sales values ('Sam', 'Bread', 7, 7, 2007, 'PA', 872);
  insert into sales values ('Sam', 'Pepsi', 16, 3, 2008, 'NJ', 3014);
  insert into sales values ('Bloom', 'Fruits', 30, 1, 2003, 'PA', 3623);
  insert into sales values ('Sam', 'Pepsi', 16, 11, 2003, 'NJ', 3694);
  insert into sales values ('Emily', 'Yogurt', 9, 3, 2003, 'NJ', 2336);
  insert into sales values ('Knuth', 'Coke', 23, 2, 2003, 'PA', 4757);
  insert into sales values ('Bloom', 'Yogurt', 11, 9, 2001, 'NJ', 3172);
  insert into sales values ('Bloom', 'Yogurt', 17, 9, 2003, 'CT', 4004);
  insert into sales values ('Knuth', 'Bread', 16, 2, 2007, 'CT', 4127);
  insert into sales values ('Knuth', 'Cookies', 23, 12, 2008, 'NY', 1485);
  insert into sales values ('Bloom', 'Fruits', 31, 8, 2003, 'NJ', 4094);
  insert into sales values ('Helen', 'Soap', 22, 3, 2008, 'CT', 2203);
  insert into sales values ('Bloom', 'Milk', 20, 1, 2008, 'PA', 2220);
  insert into sales values ('Helen', 'Yogurt', 8, 8, 2007, 'NY', 4909);
  insert into sales values ('Emily', 'Cookies', 22, 7, 2007, 'NJ', 1827);
  insert into sales values ('Emily', 'Eggs', 8, 1, 2006, 'NJ', 4535);
  insert into sales values ('Emily', 'Bread', 21, 3, 2001, 'NY', 492);
  insert into sales values ('Helen', 'Yogurt', 20, 6, 2004, 'CT', 3832);
  insert into sales values ('Emily', 'Eggs', 19, 4, 2001, 'PA', 4658);
  insert into sales values ('Emily', 'Cookies', 2, 1, 2002, 'PA', 3238);
  insert into sales values ('Knuth', 'Eggs', 12, 2, 2007, 'NY', 4313);
  insert into sales values ('Helen', 'Fruits', 5, 6, 2003, 'NJ', 415);
  insert into sales values ('Emily', 'Milk', 9, 6, 2003, 'PA', 1274);
  insert into sales values ('Helen', 'Butter', 1, 11, 2006, 'PA', 278);
  insert into sales values ('Bloom', 'Cookies', 8, 6, 2006, 'NJ', 3887);
  insert into sales values ('Emily', 'Butter', 22, 8, 2004, 'NJ', 1312);
  insert into sales values ('Emily', 'Butter', 20, 2, 2007, 'CT', 1432);
  insert into sales values ('Helen', 'Coke', 15, 7, 2008, 'CT', 3198);
  insert into sales values ('Helen', 'Butter', 11, 4, 2000, 'NJ', 1712);
  insert into sales values ('Knuth', 'Yogurt', 16, 5, 2000, 'PA', 3396);
  insert into sales values ('Helen', 'Butter', 2, 1, 2000, 'NJ', 728);
  insert into sales values ('Helen', 'Fruits', 30, 3, 2007, 'CT', 2525);
  insert into sales values ('Bloom', 'Pepsi', 7, 8, 2006, 'NY', 254);
  insert into sales values ('Helen', 'Pepsi', 13, 2, 2001, 'NJ', 1983);
  insert into sales values ('Helen', 'Soap', 25, 10, 2006, 'NJ', 712);
  insert into sales values ('Knuth', 'Pepsi', 3, 2, 2005, 'NY', 3879);
  insert into sales values ('Emily', 'Milk', 5, 7, 2000, 'PA', 2125);
  insert into sales values ('Bloom', 'Coke', 13, 7, 2001, 'PA', 3654);
  insert into sales values ('Emily', 'Eggs', 8, 7, 2007, 'NJ', 3030);
  insert into sales values ('Bloom', 'Cookies', 20, 6, 2005, 'CT', 1676);
  insert into sales values ('Helen', 'Butter', 17, 2, 2002, 'PA', 566);
  insert into sales values ('Emily', 'Soap', 26, 10, 2000, 'PA', 742);
  insert into sales values ('Bloom', 'Fruits', 14, 8, 2000, 'NY', 3798);
  insert into sales values ('Knuth', 'Bread', 2, 11, 2002, 'NJ', 1013);
  insert into sales values ('Knuth', 'Soap', 12, 11, 2007, 'NY', 3063);
  insert into sales values ('Helen', 'Milk', 28, 2, 2006, 'NY', 4249);
  insert into sales values ('Helen', 'Eggs', 13, 5, 2000, 'CT', 1483);
  insert into sales values ('Emily', 'Eggs', 23, 7, 2007, 'NY', 2012);
  insert into sales values ('Bloom', 'Fruits', 15, 11, 2005, 'CT', 4020);
  insert into sales values ('Emily', 'Eggs', 26, 11, 2002, 'PA', 128);
  insert into sales values ('Bloom', 'Fruits', 13, 4, 2004, 'PA', 2692);
  insert into sales values ('Bloom', 'Milk', 15, 12, 2006, 'NJ', 4616);
  insert into sales values ('Sam', 'Eggs', 31, 1, 2005, 'PA', 4610);
  insert into sales values ('Sam', 'Coke', 23, 1, 2006, 'CT', 2672);
  insert into sales values ('Sam', 'Fruits', 16, 12, 2005, 'PA', 4644);
  insert into sales values ('Sam', 'Butter', 22, 12, 2000, 'NJ', 1715);
  insert into sales values ('Emily', 'Coke', 22, 11, 2003, 'CT', 81);
  insert into sales values ('Knuth', 'Yogurt', 9, 6, 2001, 'NJ', 2167);
  insert into sales values ('Bloom', 'Fruits', 25, 3, 2004, 'PA', 699);
  insert into sales values ('Emily', 'Fruits', 5, 4, 2000, 'PA', 1573);
  insert into sales values ('Sam', 'Eggs', 11, 7, 2004, 'NY', 1417);
  insert into sales values ('Helen', 'Coke', 25, 5, 2008, 'CT', 2554);
  insert into sales values ('Bloom', 'Milk', 27, 1, 2007, 'NY', 4583);
  insert into sales values ('Sam', 'Milk', 28, 12, 2007, 'NY', 1164);
  insert into sales values ('Bloom', 'Cookies', 7, 7, 2003, 'CT', 4546);
  insert into sales values ('Helen', 'Milk', 28, 2, 2006, 'PA', 4794);
  insert into sales values ('Knuth', 'Pepsi', 2, 3, 2002, 'NJ', 2548);
  insert into sales values ('Bloom', 'Pepsi', 30, 11, 2008, 'NJ', 4515);
  insert into sales values ('Helen', 'Butter', 7, 7, 2007, 'PA', 3859);
  insert into sales values ('Sam', 'Soap', 19, 6, 2007, 'NY', 1798);
  insert into sales values ('Helen', 'Coke', 4, 5, 2005, 'CT', 3345);
  insert into sales values ('Bloom', 'Milk', 16, 10, 2001, 'NJ', 2004);
  insert into sales values ('Emily', 'Butter', 16, 11, 2004, 'CT', 2862);
  insert into sales values ('Bloom', 'Bread', 4, 9, 2008, 'NJ', 1698);
  insert into sales values ('Sam', 'Soap', 6, 1, 2003, 'CT', 2461);
  insert into sales values ('Emily', 'Pepsi', 15, 6, 2008, 'NY', 538);
  insert into sales values ('Helen', 'Yogurt', 22, 8, 2006, 'NY', 787);
  insert into sales values ('Sam', 'Yogurt', 22, 1, 2008, 'PA', 2142);
  insert into sales values ('Sam', 'Butter', 14, 12, 2007, 'NJ', 3019);
  insert into sales values ('Sam', 'Pepsi', 19, 12, 2002, 'CT', 4865);
  insert into sales values ('Bloom', 'Fruits', 11, 1, 2004, 'PA', 3006);
  insert into sales values ('Emily', 'Yogurt', 16, 8, 2000, 'CT', 557);
  insert into sales values ('Sam', 'Eggs', 12, 2, 2006, 'NJ', 1091);
  insert into sales values ('Knuth', 'Eggs', 8, 4, 2006, 'PA', 326);
  insert into sales values ('Bloom', 'Yogurt', 7, 12, 2006, 'PA', 783);
  insert into sales values ('Emily', 'Soap', 15, 11, 2003, 'CT', 4106);
  insert into sales values ('Sam', 'Eggs', 7, 11, 2007, 'PA', 4674);
  insert into sales values ('Sam', 'Milk', 7, 4, 2004, 'CT', 385);
  insert into sales values ('Bloom', 'Yogurt', 28, 3, 2008, 'NJ', 1660);
  insert into sales values ('Knuth', 'Coke', 9, 4, 2002, 'CT', 4027);
  insert into sales values ('Emily', 'Cookies', 9, 2, 2007, 'PA', 2500);
  insert into sales values ('Sam', 'Yogurt', 22, 6, 2001, 'CT', 4728);
  insert into sales values ('Knuth', 'Soap', 23, 11, 2002, 'CT', 2915);
  insert into sales values ('Bloom', 'Milk', 4, 12, 2004, 'CT', 1639);
  insert into sales values ('Bloom', 'Pepsi', 10, 7, 2000, 'CT', 94);
  insert into sales values ('Sam', 'Milk', 4, 1, 2008, 'NY', 987);
  insert into sales values ('Sam', 'Yogurt', 21, 5, 2008, 'PA', 4564);
  insert into sales values ('Helen', 'Eggs', 21, 6, 2004, 'NY', 3200);
  insert into sales values ('Knuth', 'Pepsi', 29, 8, 2001, 'NJ', 277);
  insert into sales values ('Knuth', 'Butter', 2, 10, 2007, 'NY', 156);
  insert into sales values ('Sam', 'Soap', 11, 6, 2005, 'NJ', 1883);
  insert into sales values ('Sam', 'Pepsi', 26, 3, 2005, 'PA', 2841);
  insert into sales values ('Knuth', 'Pepsi', 29, 4, 2002, 'CT', 1481);
  insert into sales values ('Sam', 'Yogurt', 2, 9, 2007, 'NY', 1317);
  insert into sales values ('Helen', 'Milk', 19, 9, 2002, 'PA', 3314);
  insert into sales values ('Knuth', 'Coke', 23, 6, 2007, 'CT', 2660);
  insert into sales values ('Sam', 'Coke', 21, 6, 2003, 'NY', 142);
  insert into sales values ('Helen', 'Fruits', 17, 12, 2004, 'CT', 268);
  insert into sales values ('Bloom', 'Fruits', 24, 3, 2004, 'NY', 1268);
  insert into sales values ('Bloom', 'Eggs', 17, 5, 2005, 'CT', 4177);
  insert into sales values ('Helen', 'Pepsi', 18, 1, 2006, 'NJ', 2232);
  insert into sales values ('Helen', 'Butter', 21, 4, 2004, 'NY', 1978);
  insert into sales values ('Helen', 'Butter', 11, 9, 2000, 'NJ', 803);
  insert into sales values ('Helen', 'Milk', 9, 4, 2000, 'NY', 77);
  insert into sales values ('Emily', 'Pepsi', 5, 5, 2001, 'PA', 1682);
  insert into sales values ('Emily', 'Yogurt', 29, 5, 2002, 'CT', 2126);
  insert into sales values ('Emily', 'Yogurt', 4, 8, 2004, 'CT', 3765);
  insert into sales values ('Bloom', 'Cookies', 8, 10, 2002, 'NY', 4570);
  insert into sales values ('Bloom', 'Soap', 10, 4, 2007, 'PA', 1216);
  insert into sales values ('Knuth', 'Soap', 18, 11, 2004, 'PA', 586);
  insert into sales values ('Bloom', 'Bread', 13, 3, 2006, 'NY', 3792);
  insert into sales values ('Emily', 'Coke', 29, 2, 2001, 'NY', 4258);
  insert into sales values ('Bloom', 'Eggs', 24, 1, 2000, 'NY', 666);
  insert into sales values ('Knuth', 'Fruits', 5, 7, 2002, 'NJ', 733);
  insert into sales values ('Sam', 'Bread', 11, 4, 2006, 'NY', 2282);
  insert into sales values ('Knuth', 'Coke', 8, 5, 2004, 'NJ', 1583);
  insert into sales values ('Helen', 'Pepsi', 13, 4, 2006, 'NY', 1931);
  insert into sales values ('Knuth', 'Bread', 9, 10, 2002, 'CT', 1796);
  insert into sales values ('Knuth', 'Pepsi', 17, 6, 2008, 'PA', 2390);
  insert into sales values ('Knuth', 'Eggs', 2, 11, 2004, 'CT', 4317);
  insert into sales values ('Sam', 'Milk', 6, 7, 2005, 'NY', 3120);
  insert into sales values ('Sam', 'Cookies', 8, 2, 2008, 'CT', 2523);
  insert into sales values ('Sam', 'Pepsi', 27, 7, 2008, 'NY', 3189);
  insert into sales values ('Sam', 'Eggs', 11, 5, 2007, 'NY', 3363);
  insert into sales values ('Bloom', 'Bread', 4, 7, 2006, 'CT', 1494);
  insert into sales values ('Helen', 'Butter', 18, 8, 2001, 'NY', 163);
  insert into sales values ('Emily', 'Eggs', 10, 11, 2004, 'CT', 2722);
  insert into sales values ('Sam', 'Coke', 20, 5, 2007, 'CT', 2819);
  insert into sales values ('Emily', 'Milk', 2, 4, 2008, 'CT', 3257);
  insert into sales values ('Bloom', 'Cookies', 9, 9, 2005, 'PA', 1858);
  insert into sales values ('Sam', 'Fruits', 2, 11, 2004, 'NY', 4738);
  insert into sales values ('Knuth', 'Soap', 17, 4, 2008, 'CT', 436);
  insert into sales values ('Bloom', 'Milk', 19, 10, 2008, 'PA', 4377);
  insert into sales values ('Bloom', 'Cookies', 8, 10, 2000, 'CT', 3545);
  insert into sales values ('Emily', 'Fruits', 5, 11, 2001, 'NJ', 3743);
  insert into sales values ('Sam', 'Soap', 28, 8, 2000, 'PA', 2956);
  insert into sales values ('Sam', 'Bread', 29, 8, 2000, 'CT', 1599);
  insert into sales values ('Knuth', 'Fruits', 23, 12, 2008, 'NJ', 3939);
  insert into sales values ('Knuth', 'Yogurt', 14, 3, 2007, 'PA', 4361);
  insert into sales values ('Knuth', 'Soap', 9, 2, 2005, 'NJ', 657);
  insert into sales values ('Sam', 'Coke', 24, 8, 2004, 'PA', 3053);
  insert into sales values ('Sam', 'Pepsi', 16, 4, 2003, 'CT', 160);
  insert into sales values ('Emily', 'Coke', 13, 2, 2000, 'CT', 2909);
  insert into sales values ('Emily', 'Butter', 13, 2, 2001, 'NY', 2826);
  insert into sales values ('Bloom', 'Soap', 5, 7, 2002, 'CT', 387);
  insert into sales values ('Emily', 'Milk', 14, 3, 2005, 'CT', 2589);
  insert into sales values ('Sam', 'Soap', 6, 4, 2003, 'PA', 4954);
  insert into sales values ('Helen', 'Eggs', 13, 6, 2000, 'PA', 2817);
  insert into sales values ('Bloom', 'Coke', 14, 1, 2008, 'CT', 928);
  insert into sales values ('Emily', 'Cookies', 27, 1, 2001, 'CT', 3654);
  insert into sales values ('Knuth', 'Cookies', 7, 10, 2001, 'PA', 1367);
  insert into sales values ('Bloom', 'Fruits', 9, 7, 2002, 'NY', 612);
  insert into sales values ('Helen', 'Yogurt', 2, 12, 2005, 'NY', 1128);
  insert into sales values ('Bloom', 'Bread', 22, 1, 2003, 'CT', 2220);
  insert into sales values ('Knuth', 'Coke', 13, 12, 2007, 'PA', 2928);
  insert into sales values ('Bloom', 'Fruits', 5, 5, 2002, 'PA', 4444);
  insert into sales values ('Knuth', 'Fruits', 12, 1, 2002, 'NJ', 1368);
  insert into sales values ('Knuth', 'Cookies', 6, 6, 2003, 'NJ', 3683);
  insert into sales values ('Bloom', 'Eggs', 22, 9, 2006, 'NY', 3150);
  insert into sales values ('Sam', 'Butter', 27, 2, 2006, 'PA', 673);
  insert into sales values ('Helen', 'Bread', 24, 1, 2002, 'CT', 3530);
  insert into sales values ('Bloom', 'Pepsi', 1, 6, 2003, 'NJ', 1368);
  insert into sales values ('Sam', 'Soap', 4, 1, 2003, 'NJ', 2356);
  insert into sales values ('Knuth', 'Pepsi', 2, 6, 2002, 'NY', 3936);
  insert into sales values ('Emily', 'Coke', 6, 11, 2008, 'NY', 1917);
  insert into sales values ('Knuth', 'Fruits', 26, 8, 2001, 'NY', 24);
  insert into sales values ('Sam', 'Cookies', 22, 12, 2008, 'PA', 1657);
  insert into sales values ('Emily', 'Fruits', 28, 4, 2005, 'NY', 2102);
  insert into sales values ('Helen', 'Butter', 10, 2, 2005, 'NJ', 3288);
  insert into sales values ('Emily', 'Coke', 15, 2, 2007, 'NY', 1330);
  insert into sales values ('Knuth', 'Eggs', 6, 2, 2006, 'NY', 3788);
  insert into sales values ('Emily', 'Cookies', 3, 11, 2008, 'NJ', 173);
  insert into sales values ('Sam', 'Cookies', 9, 10, 2007, 'CT', 132);
  insert into sales values ('Bloom', 'Bread', 14, 9, 2007, 'CT', 3261);
  insert into sales values ('Emily', 'Bread', 2, 4, 2005, 'NJ', 4467);
  insert into sales values ('Knuth', 'Coke', 17, 8, 2007, 'PA', 2812);
  insert into sales values ('Emily', 'Cookies', 19, 5, 2001, 'NY', 2685);
  insert into sales values ('Knuth', 'Pepsi', 11, 9, 2004, 'NY', 4942);
  insert into sales values ('Knuth', 'Pepsi', 12, 8, 2004, 'CT', 1244);
  insert into sales values ('Bloom', 'Soap', 17, 9, 2002, 'PA', 270);
  insert into sales values ('Emily', 'Cookies', 1, 10, 2000, 'NJ', 658);
  insert into sales values ('Helen', 'Soap', 3, 9, 2007, 'NJ', 2934);
  insert into sales values ('Knuth', 'Soap', 16, 1, 2001, 'CT', 1098);
  insert into sales values ('Knuth', 'Eggs', 9, 4, 2003, 'CT', 2151);
  insert into sales values ('Knuth', 'Milk', 13, 4, 2006, 'NY', 2424);
  insert into sales values ('Knuth', 'Pepsi', 13, 12, 2007, 'PA', 2538);
  insert into sales values ('Knuth', 'Butter', 8, 10, 2008, 'PA', 2852);
  insert into sales values ('Emily', 'Soap', 4, 8, 2001, 'NJ', 3901);
  insert into sales values ('Emily', 'Coke', 20, 2, 2004, 'NJ', 1301);
  insert into sales values ('Bloom', 'Bread', 5, 3, 2007, 'NJ', 2277);
  insert into sales values ('Knuth', 'Fruits', 18, 9, 2003, 'CT', 159);
  insert into sales values ('Helen', 'Yogurt', 1, 10, 2007, 'CT', 3366);
  insert into sales values ('Emily', 'Bread', 13, 5, 2001, 'NJ', 232);
  insert into sales values ('Helen', 'Milk', 24, 12, 2006, 'NY', 311);
  insert into sales values ('Helen', 'Butter', 12, 11, 2001, 'NY', 1357);
  insert into sales values ('Bloom', 'Coke', 30, 9, 2000, 'NJ', 2714);
  insert into sales values ('Helen', 'Milk', 6, 3, 2003, 'CT', 1249);
  insert into sales values ('Helen', 'Butter', 15, 7, 2005, 'NJ', 942);
  insert into sales values ('Sam', 'Fruits', 21, 11, 2006, 'CT', 3399);
  insert into sales values ('Knuth', 'Yogurt', 2, 10, 2006, 'PA', 2497);
  insert into sales values ('Emily', 'Milk', 2, 7, 2008, 'CT', 26);
  insert into sales values ('Sam', 'Pepsi', 28, 9, 2008, 'NY', 4797);
  insert into sales values ('Helen', 'Bread', 3, 6, 2008, 'NY', 4855);
  insert into sales values ('Sam', 'Bread', 13, 6, 2007, 'NJ', 3187);
  insert into sales values ('Emily', 'Bread', 21, 6, 2000, 'NJ', 141);
  insert into sales values ('Knuth', 'Bread', 5, 8, 2000, 'CT', 2063);
  insert into sales values ('Emily', 'Pepsi', 4, 10, 2003, 'CT', 4135);
  insert into sales values ('Knuth', 'Bread', 27, 3, 2008, 'CT', 4372);
  insert into sales values ('Sam', 'Pepsi', 19, 6, 2001, 'NJ', 3368);
  insert into sales values ('Helen', 'Fruits', 21, 1, 2005, 'CT', 2360);
  insert into sales values ('Helen', 'Bread', 12, 12, 2004, 'CT', 4114);
  insert into sales values ('Bloom', 'Yogurt', 28, 4, 2005, 'NY', 4043);
  insert into sales values ('Bloom', 'Bread', 25, 8, 2004, 'PA', 3100);
  insert into sales values ('Bloom', 'Milk', 3, 5, 2001, 'NJ', 1794);
  insert into sales values ('Knuth', 'Pepsi', 27, 7, 2008, 'NJ', 4689);
  insert into sales values ('Emily', 'Eggs', 1, 12, 2003, 'NY', 1595);
  insert into sales values ('Bloom', 'Coke', 5, 4, 2003, 'PA', 2681);
  insert into sales values ('Helen', 'Butter', 5, 7, 2004, 'NJ', 1174);
  insert into sales values ('Knuth', 'Eggs', 18, 10, 2001, 'NJ', 2353);
  insert into sales values ('Knuth', 'Coke', 9, 10, 2002, 'NJ', 766);
  insert into sales values ('Bloom', 'Bread', 22, 6, 2008, 'NJ', 944);
  insert into sales values ('Emily', 'Bread', 31, 4, 2008, 'NJ', 2135);
  insert into sales values ('Helen', 'Coke', 23, 5, 2006, 'CT', 1099);
  insert into sales values ('Emily', 'Fruits', 7, 7, 2007, 'PA', 111);
  insert into sales values ('Sam', 'Butter', 20, 12, 2002, 'NY', 1234);
  insert into sales values ('Bloom', 'Cookies', 29, 11, 2006, 'CT', 796);
  insert into sales values ('Emily', 'Pepsi', 11, 5, 2005, 'NY', 4901);
  insert into sales values ('Sam', 'Soap', 29, 9, 2007, 'NY', 3260);
  insert into sales values ('Emily', 'Soap', 27, 1, 2006, 'NY', 3218);
  insert into sales values ('Knuth', 'Milk', 6, 10, 2003, 'PA', 1088);
  insert into sales values ('Bloom', 'Fruits', 31, 1, 2003, 'CT', 4085);
  insert into sales values ('Emily', 'Fruits', 22, 7, 2004, 'PA', 2243);
  insert into sales values ('Knuth', 'Coke', 30, 6, 2008, 'PA', 3166);
  insert into sales values ('Knuth', 'Cookies', 20, 2, 2000, 'NJ', 4237);
  insert into sales values ('Bloom', 'Fruits', 12, 2, 2001, 'NJ', 776);
  insert into sales values ('Sam', 'Cookies', 9, 5, 2004, 'PA', 454);
  insert into sales values ('Knuth', 'Bread', 19, 6, 2005, 'PA', 1932);
  insert into sales values ('Emily', 'Pepsi', 22, 3, 2004, 'CT', 4531);
  insert into sales values ('Sam', 'Butter', 30, 9, 2006, 'NY', 4893);
  insert into sales values ('Helen', 'Soap', 26, 8, 2005, 'CT', 1301);
  insert into sales values ('Helen', 'Milk', 21, 1, 2006, 'NJ', 1839);
  insert into sales values ('Knuth', 'Fruits', 24, 7, 2008, 'NY', 1062);
  insert into sales values ('Bloom', 'Coke', 22, 7, 2008, 'CT', 3640);
  insert into sales values ('Bloom', 'Bread', 25, 2, 2000, 'NJ', 4778);
  insert into sales values ('Sam', 'Bread', 22, 7, 2006, 'CT', 207);
  insert into sales values ('Bloom', 'Bread', 20, 4, 2006, 'CT', 417);
  insert into sales values ('Sam', 'Fruits', 23, 5, 2000, 'NJ', 3743);
  insert into sales values ('Helen', 'Butter', 28, 2, 2002, 'NJ', 2483);
  insert into sales values ('Helen', 'Cookies', 16, 11, 2006, 'CT', 1164);
  insert into sales values ('Sam', 'Soap', 9, 3, 2002, 'PA', 2994);
  insert into sales values ('Sam', 'Pepsi', 28, 5, 2002, 'NJ', 3468);
  insert into sales values ('Knuth', 'Bread', 13, 1, 2002, 'PA', 3049);
  insert into sales values ('Helen', 'Bread', 15, 11, 2008, 'PA', 1637);
  insert into sales values ('Helen', 'Coke', 4, 2, 2007, 'NJ', 755);
  insert into sales values ('Emily', 'Eggs', 20, 4, 2006, 'PA', 771);
  insert into sales values ('Knuth', 'Soap', 22, 8, 2005, 'NY', 1002);
  insert into sales values ('Knuth', 'Eggs', 12, 11, 2004, 'CT', 1950);
  insert into sales values ('Emily', 'Cookies', 30, 4, 2005, 'NY', 3669);
  insert into sales values ('Bloom', 'Eggs', 30, 11, 2004, 'CT', 1028);
  insert into sales values ('Helen', 'Coke', 31, 12, 2007, 'NJ', 3804);
  insert into sales values ('Sam', 'Cookies', 23, 6, 2003, 'PA', 362);
  insert into sales values ('Sam', 'Fruits', 21, 9, 2005, 'PA', 3800);
  insert into sales values ('Helen', 'Coke', 14, 4, 2001, 'CT', 2331);
  insert into sales values ('Bloom', 'Pepsi', 20, 9, 2000, 'PA', 2034);
  insert into sales values ('Knuth', 'Coke', 29, 1, 2005, 'PA', 4364);
  insert into sales values ('Sam', 'Fruits', 27, 7, 2007, 'PA', 2240);
  insert into sales values ('Sam', 'Fruits', 12, 10, 2005, 'NY', 2409);
  insert into sales values ('Knuth', 'Fruits', 1, 2, 2003, 'PA', 4475);
  insert into sales values ('Sam', 'Bread', 26, 9, 2001, 'NJ', 3809);
  insert into sales values ('Helen', 'Coke', 4, 12, 2003, 'CT', 2172);
  insert into sales values ('Emily', 'Cookies', 18, 12, 2007, 'PA', 4935);
  insert into sales values ('Knuth', 'Butter', 4, 3, 2008, 'CT', 2232);
  insert into sales values ('Bloom', 'Fruits', 14, 7, 2005, 'CT', 2813);
  insert into sales values ('Emily', 'Coke', 17, 1, 2006, 'NJ', 2192);
  insert into sales values ('Helen', 'Coke', 9, 10, 2008, 'NJ', 3065);
  insert into sales values ('Bloom', 'Pepsi', 20, 1, 2000, 'NJ', 526);
  insert into sales values ('Emily', 'Soap', 31, 7, 2007, 'NJ', 623);
  insert into sales values ('Bloom', 'Coke', 26, 7, 2003, 'NJ', 3058);
  insert into sales values ('Sam', 'Milk', 4, 2, 2002, 'PA', 1126);
  insert into sales values ('Sam', 'Coke', 14, 1, 2003, 'NY', 2668);
  insert into sales values ('Emily', 'Eggs', 20, 10, 2004, 'NJ', 4689);
  insert into sales values ('Bloom', 'Fruits', 29, 6, 2001, 'PA', 26);
  insert into sales values ('Helen', 'Pepsi', 25, 5, 2003, 'NY', 2590);
  insert into sales values ('Bloom', 'Eggs', 3, 1, 2004, 'NJ', 4972);
  insert into sales values ('Helen', 'Milk', 13, 4, 2000, 'NY', 888);
  insert into sales values ('Sam', 'Butter', 9, 6, 2008, 'NJ', 3659);
  insert into sales values ('Knuth', 'Yogurt', 3, 6, 2004, 'PA', 1285);
  insert into sales values ('Sam', 'Yogurt', 2, 7, 2003, 'PA', 2683);
  insert into sales values ('Knuth', 'Bread', 3, 2, 2004, 'CT', 1914);
  insert into sales values ('Helen', 'Coke', 9, 2, 2008, 'PA', 3132);
  insert into sales values ('Emily', 'Coke', 25, 8, 2002, 'CT', 4379);
  insert into sales values ('Helen', 'Butter', 7, 2, 2000, 'PA', 1025);
  insert into sales values ('Knuth', 'Coke', 3, 10, 2000, 'NJ', 4672);
  insert into sales values ('Sam', 'Cookies', 17, 11, 2002, 'PA', 3725);
  insert into sales values ('Helen', 'Yogurt', 12, 9, 2003, 'CT', 3015);
  insert into sales values ('Helen', 'Coke', 10, 7, 2000, 'NY', 2401);
  insert into sales values ('Sam', 'Eggs', 10, 5, 2008, 'NJ', 1114);
  insert into sales values ('Bloom', 'Coke', 2, 8, 2003, 'NJ', 279);
  insert into sales values ('Helen', 'Butter', 4, 6, 2001, 'NY', 4969);
  insert into sales values ('Knuth', 'Fruits', 30, 11, 2002, 'PA', 1718);
  insert into sales values ('Knuth', 'Eggs', 22, 9, 2003, 'PA', 3532);
  insert into sales values ('Sam', 'Milk', 19, 12, 2006, 'NJ', 4522);
  insert into sales values ('Bloom', 'Cookies', 20, 9, 2005, 'NJ', 4240);
  insert into sales values ('Bloom', 'Eggs', 2, 4, 2000, 'CT', 2865);
  insert into sales values ('Sam', 'Fruits', 12, 12, 2006, 'NJ', 1311);
  insert into sales values ('Bloom', 'Milk', 11, 5, 2007, 'NY', 1820);
  insert into sales values ('Knuth', 'Soap', 27, 10, 2006, 'CT', 2231);
  insert into sales values ('Sam', 'Milk', 6, 8, 2005, 'PA', 2124);
  insert into sales values ('Helen', 'Eggs', 21, 10, 2002, 'CT', 4162);
  insert into sales values ('Sam', 'Pepsi', 15, 3, 2008, 'CT', 1470);
  insert into sales values ('Emily', 'Butter', 7, 2, 2004, 'PA', 1491);
  insert into sales values ('Sam', 'Milk', 29, 1, 2005, 'CT', 879);
  insert into sales values ('Knuth', 'Bread', 7, 5, 2003, 'PA', 3664);
  insert into sales values ('Emily', 'Fruits', 24, 3, 2008, 'PA', 1469);
  insert into sales values ('Bloom', 'Butter', 9, 10, 2000, 'CT', 4279);
  insert into sales values ('Bloom', 'Bread', 13, 6, 2000, 'CT', 256);
  insert into sales values ('Knuth', 'Fruits', 25, 10, 2006, 'NY', 1181);
  insert into sales values ('Knuth', 'Cookies', 25, 10, 2004, 'NJ', 2154);
  insert into sales values ('Knuth', 'Cookies', 7, 3, 2002, 'PA', 488);
  insert into sales values ('Bloom', 'Eggs', 22, 4, 2007, 'PA', 3723);
  insert into sales values ('Helen', 'Butter', 1, 2, 2005, 'NJ', 2160);
  insert into sales values ('Helen', 'Cookies', 19, 7, 2004, 'NY', 1080);
  insert into sales values ('Knuth', 'Butter', 28, 3, 2004, 'PA', 516);
  insert into sales values ('Bloom', 'Bread', 3, 12, 2008, 'NJ', 1106);
  insert into sales values ('Knuth', 'Pepsi', 15, 6, 2001, 'NJ', 2064);
  insert into sales values ('Sam', 'Pepsi', 30, 10, 2001, 'CT', 3008);
  insert into sales values ('Helen', 'Eggs', 18, 10, 2004, 'CT', 1754);
  insert into sales values ('Helen', 'Yogurt', 18, 4, 2005, 'NY', 2516);
  insert into sales values ('Bloom', 'Eggs', 5, 7, 2000, 'NY', 1219);
  insert into sales values ('Emily', 'Eggs', 18, 8, 2007, 'NY', 4754);
  insert into sales values ('Knuth', 'Eggs', 2, 12, 2008, 'CT', 1312);
  insert into sales values ('Knuth', 'Cookies', 29, 6, 2006, 'CT', 2635);
  insert into sales values ('Emily', 'Cookies', 24, 12, 2006, 'CT', 3308);
  insert into sales values ('Knuth', 'Cookies', 3, 7, 2003, 'CT', 2423);
  insert into sales values ('Sam', 'Yogurt', 1, 5, 2005, 'NJ', 1286);
  insert into sales values ('Helen', 'Butter', 25, 11, 2000, 'CT', 306);
  insert into sales values ('Helen', 'Fruits', 19, 2, 2003, 'CT', 951);
  insert into sales values ('Helen', 'Bread', 30, 5, 2008, 'NY', 4901);
  insert into sales values ('Helen', 'Soap', 19, 8, 2005, 'NJ', 3618);
  insert into sales values ('Sam', 'Pepsi', 8, 11, 2008, 'NJ', 1097);
  insert into sales values ('Knuth', 'Bread', 14, 4, 2002, 'NY', 3370);
  insert into sales values ('Emily', 'Cookies', 17, 7, 2004, 'PA', 1477);
  insert into sales values ('Sam', 'Yogurt', 2, 3, 2001, 'NJ', 1943);
  insert into sales values ('Knuth', 'Yogurt', 29, 2, 2000, 'NY', 3445);
  insert into sales values ('Helen', 'Eggs', 5, 10, 2003, 'PA', 1045);
  insert into sales values ('Helen', 'Soap', 27, 11, 2001, 'PA', 925);
  insert into sales values ('Knuth', 'Coke', 8, 7, 2001, 'CT', 211);
  insert into sales values ('Helen', 'Coke', 15, 10, 2005, 'CT', 3840);
  insert into sales values ('Sam', 'Butter', 18, 4, 2004, 'NJ', 4453);
  insert into sales values ('Knuth', 'Bread', 16, 8, 2004, 'CT', 1095);
  insert into sales values ('Emily', 'Fruits', 29, 8, 2002, 'PA', 4731);
  insert into sales values ('Bloom', 'Butter', 17, 9, 2008, 'NJ', 3718);
  insert into sales values ('Bloom', 'Milk', 30, 3, 2001, 'CT', 2843);
  insert into sales values ('Bloom', 'Eggs', 24, 11, 2004, 'CT', 1573);
  insert into sales values ('Helen', 'Butter', 2, 7, 2003, 'NY', 4364);
  insert into sales values ('Helen', 'Cookies', 15, 7, 2005, 'NJ', 1965);
  insert into sales values ('Sam', 'Milk', 4, 2, 2008, 'CT', 3434);
  insert into sales values ('Emily', 'Butter', 13, 6, 2008, 'CT', 2869);
  insert into sales values ('Knuth', 'Butter', 9, 6, 2004, 'NY', 950);
  insert into sales values ('Bloom', 'Eggs', 13, 4, 2003, 'NY', 3621);
  insert into sales values ('Emily', 'Coke', 3, 6, 2004, 'NJ', 3314);
  insert into sales values ('Helen', 'Soap', 18, 11, 2007, 'NJ', 1991);
  insert into sales values ('Helen', 'Soap', 10, 1, 2003, 'NJ', 4702);
  insert into sales values ('Helen', 'Pepsi', 31, 1, 2008, 'NJ', 4412);
  insert into sales values ('Helen', 'Pepsi', 12, 12, 2002, 'CT', 1515);
  insert into sales values ('Bloom', 'Cookies', 19, 9, 2002, 'PA', 2504);
  insert into sales values ('Emily', 'Fruits', 6, 4, 2008, 'CT', 3055);
  insert into sales values ('Knuth', 'Fruits', 8, 4, 2005, 'CT', 973);