DROP TABLE Sales; CREATE TABLE Sales ( salesmanID int, productID int, day char(10) ); INSERT INTO Sales VALUES (1,6,'2002-10-21'); INSERT INTO Sales VALUES (1,11,'2002-07-12'); INSERT INTO Sales VALUES (1,2,'2003-04-30'); INSERT INTO Sales VALUES (1,23,'2003-02-11'); INSERT INTO Sales VALUES (2,15,'2004-09-05'); INSERT INTO Sales VALUES (2,11,'2002-08-07'); INSERT INTO Sales VALUES (2,9,'2002-12-14'); INSERT INTO Sales VALUES (2,27,'2003-11-15'); INSERT INTO Sales VALUES (3,13,'2004-01-25'); INSERT INTO Sales VALUES (3,4,'2003-03-05'); INSERT INTO Sales VALUES (3,22,'2002-09-17'); INSERT INTO Sales VALUES (3,30,'2004-04-01'); INSERT INTO Sales VALUES (3,22,'2004-09-02'); INSERT INTO Sales VALUES (3,23,'2003-04-07'); INSERT INTO Sales VALUES (3,2,'2002-03-14'); INSERT INTO Sales VALUES (4,23,'2001-02-25'); INSERT INTO Sales VALUES (4,1,'2002-10-32'); INSERT INTO Sales VALUES (4,5,'2003-11-17'); INSERT INTO Sales VALUES (1,2,'2002-10-21'); INSERT INTO Sales VALUES (1,21,'2002-07-12'); INSERT INTO Sales VALUES (1,20,'2003-04-30'); INSERT INTO Sales VALUES (1,19,'2003-02-11'); INSERT INTO Sales VALUES (2,28,'2004-09-05'); INSERT INTO Sales VALUES (2,27,'2002-08-07'); INSERT INTO Sales VALUES (2,29,'2002-12-14'); INSERT INTO Sales VALUES (2,10,'2003-11-15'); INSERT INTO Sales VALUES (3,3,'2004-01-25'); INSERT INTO Sales VALUES (3,2,'2003-03-05'); INSERT INTO Sales VALUES (3,1,'2002-09-17'); INSERT INTO Sales VALUES (3,23,'2004-04-01'); INSERT INTO Sales VALUES (3,17,'2004-09-02'); INSERT INTO Sales VALUES (3,24,'2003-04-07'); INSERT INTO Sales VALUES (3,9,'2002-03-14'); INSERT INTO Sales VALUES (4,23,'2001-02-25'); INSERT INTO Sales VALUES (4,11,'2002-10-32'); INSERT INTO Sales VALUES (4,4,'2003-11-17');