data.sql

--

INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (1,1,2,'1987-06-15',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (2,2,4,'1987-06-15',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (3,3,5,'1987-06-15','1998-08-31');
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (4,4,5,'1987-06-15',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (5,5,1,'1987-06-15',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (6,6,5,'1987-06-15',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (7,7,1,'1988-02-26',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (8,8,5,'1988-02-26','2003-05-31');
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (9,9,2,'1988-02-26','1998-08-31');
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (10,10,6,'1988-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (11,11,5,'1988-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (12,12,5,'1988-04-01','1998-08-31');
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (13,13,3,'1989-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (14,14,5,'1989-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (15,15,4,'1991-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (16,16,5,'1991-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (17,17,5,'1992-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (18,18,1,'1992-08-26',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (19,19,5,'1993-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (20,20,5,'1994-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (21,21,5,'1996-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (22,22,5,'1996-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (23,23,5,'1997-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (24,3,6,'1998-09-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (25,12,1,'1998-09-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (26,9,3,'1998-09-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (27,24,2,'1999-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (28,25,5,'1999-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (29,26,5,'2001-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (30,27,5,'2003-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (31,8,1,'2003-06-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (32,28,5,'2004-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (33,29,5,'2006-04-01',null);
INSERT INTO BelongTo(BelongID,EmployeeID,DepartmentID,StartDate,EndDate) VALUES (34,30,5,'2007-04-01',null);

--

INSERT INTO Categories(CategoryID,CategoryName) VALUES (1,'魚');
INSERT INTO Categories(CategoryID,CategoryName) VALUES (2,'肉');
INSERT INTO Categories(CategoryID,CategoryName) VALUES (3,'野菜');
INSERT INTO Categories(CategoryID,CategoryName) VALUES (4,'菓子');
INSERT INTO Categories(CategoryID,CategoryName) VALUES (5,'乾物');
INSERT INTO Categories(CategoryID,CategoryName) VALUES (6,'惣菜');
INSERT INTO Categories(CategoryID,CategoryName) VALUES (7,'生活用品');
INSERT INTO Categories(CategoryID,CategoryName) VALUES (8,'嗜好品');
INSERT INTO Categories(CategoryID,CategoryName) VALUES (9,'玩具');
INSERT INTO Categories(CategoryID,CategoryName) VALUES (10,'アクセサリー');

--

INSERT INTO CustomerClasses(CustomerClassID,CustomerClassName) VALUES (1,'法人');
INSERT INTO CustomerClasses(CustomerClassID,CustomerClassName) VALUES (2,'個人');

--

INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (1,2001,'タマ','江戸川区下小岩',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (2,2002,'ハナ','江戸川区北小岩',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (3,2003,'ミケ','館林市緑町',2,10);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (4,2004,'キク','江戸川区西小岩',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (5,1005,'ウメ','中野区ねこた町',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (6,1006,'トラネコ商会','札幌市南区',1,1);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (7,2007,'クロ','台東区浅草橋',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (8,2008,'トラ','川崎市多摩区',2,14);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (9,1009,'スーパーニャンコ','江戸川区南小岩',1,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (10,1010,'ぶち雑貨店','江戸川区南小岩',1,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (11,1011,'ミーストア','龍ケ崎市下町',1,8);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (12,2012,'タロ','江戸川区南小岩',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (13,1013,'雑貨サクラ','江戸川区西小岩',1,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (14,2014,'チー','江戸川区南小岩',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (15,2015,'シロ','荒川区北千住',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (16,1016,'株式会社スズナリ','松山市東山町',1,38);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (17,1017,'エリザベス商会','江戸川区東小岩',1,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (18,2018,'ポンタ','江戸川区南小岩',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (19,2019,'ジロー','江戸川区南篠崎',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (20,2020,'ニャン太','江戸川区南小岩',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (21,2021,'ミミ','さいたま市桜区',2,11);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (22,2022,'ミミミ','さいたま市桜区',2,11);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (23,1023,'有限会社チョコグリーン','大阪市中央区',1,27);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (24,2024,'チャー','水戸市大工町',2,8);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (25,2025,'みーすけ','武蔵野市吉祥寺',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (26,2026,'チロ','江戸川区南小岩',2,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (27,1027,'パーコ株式会社','取手市井野',1,8);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (28,1028,'トニー商店','江戸川区北篠崎',1,13);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (29,2029,'ギン','横浜市青葉区',2,14);
INSERT INTO Customers(CustomerID,CustomerCode,CustomerName,Address,CustomerClassID,PrefecturalID) VALUES (30,1030,'プーストア','江東区大島',1,13);

--

INSERT INTO Departments(DepartmentID,DepartmentName) VALUES (1,'営業');
INSERT INTO Departments(DepartmentID,DepartmentName) VALUES (2,'総務');
INSERT INTO Departments(DepartmentID,DepartmentName) VALUES (3,'人事');
INSERT INTO Departments(DepartmentID,DepartmentName) VALUES (4,'経理');
INSERT INTO Departments(DepartmentID,DepartmentName) VALUES (5,'販売');
INSERT INTO Departments(DepartmentID,DepartmentName) VALUES (6,'購買');

--

INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (1,'シマゴロー',168,72,'simagoro@nekoyasudo',1987,'1956-10-01','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (2,'ゴッチン',161,60,'gochin@nekoyasudo',1987,'1953-12-25','B');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (3,'マキ子',155,52,'maki@nekoyasudo',1987,'1958-08-16','O');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (4,'マル',158,45,'maru@nekoyasudo',1987,'1954-01-12','AB');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (5,'ミチロー',170,70,'michiro@nekoyasudo',1987,'1965-02-14','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (6,'チー',173,76,'coo@nekoyasudo',1987,'1964-09-15','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (7,'サラ',162,50,'sara@nekoyasudo',1988,'1960-10-28','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (8,'みなみ',153,42,'minami@nekoyasudo',1988,'1962-09-03','O');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (9,'プリン',148,48,'prin@nekoyasudo',1988,'1968-03-14','B');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (10,'ぴー子',156,52,'pko@nekoyasudo',1988,'1971-11-13','O');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (11,'ごま',180,78,'goma@nekoyasudo',1988,'1971-04-15','O');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (12,'ぱんだ',185,95,'panda@nekoyasudo',1988,'1971-06-01','B');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (13,'猫丸',172,80,'nekomaru@nekoyasudo',1989,'1972-01-15','B');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (14,'ニャン太',178,58,'nyantaro@nekoyasudo',1989,'1972-02-03','B');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (15,'モンチー',169,55,'monchi@nekoyasudo',1991,'1973-05-06','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (16,'ぴよ',155,62,'piyo@nekoyasudo',1991,'1973-07-14','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (17,'ラスカル',165,51,'rasukal@nekoyasudo',1992,'1974-04-10','AB');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (18,'くま',190,115,'kuma@nekoyasudo',1992,'1970-03-03','O');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (19,'ゴン',176,78,'gon@nekoyasudo',1993,'1975-11-16','O');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (20,'チー',169,56,'q@nekoyasudo',1994,'1976-05-25','O');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (21,'太助',164,50,'tasuke@nekoyasudo',1996,'1978-10-03','B');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (22,'トントン',155,45,'tonton@nekoyasudo',1996,'1978-12-25','B');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (23,'マー',158,44,'ma@nekoyasudo',1997,'1979-04-03','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (24,'サリー',149,38,'sary@nekoyasudo',1999,'1981-02-02','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (25,'うさぎ',161,43,'usa@nekoyasudo',1999,'1981-08-08','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (26,'うー太',170,63,'uta@nekoyasudo',2001,'1983-03-26','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (27,'ローリー',147,40,'roly@nekoyasudo',2003,'1985-05-26','A');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (28,'マイケル',160,49,'mikel@nekoyasudo',2004,'1986-06-30','AB');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (29,'スー',163,52,'su@nekoyasudo',2006,'1988-09-08','O');
INSERT INTO Employees(EmployeeID,EmployeeName,Height,Weight,Email,HireFiscalYear,Birthday,BloodType) VALUES (30,'ミーヤ',168,51,'miya@nekoyasudo',2007,'1989-07-07','B');

--

INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (1,'北海道');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (2,'青森県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (3,'岩手県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (4,'宮城県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (5,'秋田県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (6,'山形県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (7,'福島県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (8,'茨城県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (9,'栃木県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (10,'群馬県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (11,'埼玉県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (12,'千葉県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (13,'東京都');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (14,'神奈川県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (15,'新潟県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (16,'富山県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (17,'石川県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (18,'福井県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (19,'山梨県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (20,'長野県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (21,'岐阜県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (22,'静岡県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (23,'愛知県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (24,'三重県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (25,'滋賀県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (26,'京都府');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (27,'大阪府');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (28,'兵庫県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (29,'奈良県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (30,'和歌山県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (31,'鳥取県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (32,'島根県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (33,'岡山県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (34,'広島県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (35,'山口県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (36,'徳島県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (37,'香川県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (38,'愛媛県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (39,'高知県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (40,'福岡県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (41,'佐賀県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (42,'長崎県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (43,'熊本県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (44,'大分県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (45,'宮崎県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (46,'鹿児島県');
INSERT INTO Prefecturals(PrefecturalID,PrefecturalName) VALUES (47,'沖縄県 ');

--

INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (1,1001,'まぐろ',500,1);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (2,1002,'金魚',35,1);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (3,1003,'ぶり',350,1);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (4,1004,'あじ',200,1);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (5,1005,'あなご',150,1);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (6,2006,'ねずみ肉',120,2);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (7,2007,'とり肉',200,2);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (8,2008,'豚肉',300,2);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (9,2009,'バッタ肉',185,2);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (10,2010,'蜘蛛肉',98,2);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (11,3011,'ねこ草',120,3);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (12,3012,'大根',135,3);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (13,3013,'いちご',480,3);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (14,3014,'じゃがいも',300,3);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (15,3015,'しいたけ',150,3);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (16,4016,'チューチュークッキー',200,4);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (17,4017,'いなごチップス',180,4);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (18,4018,'ありせんべい',320,4);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (19,4019,'チューチューアイス',110,4);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (20,4020,'こねずみジャーキー',120,4);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (21,5021,'鰹節',200,5);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (22,5022,'ネコ缶ナンバーワン',300,5);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (23,5023,'ネコ缶ダイエット',300,5);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (24,5024,'ネコ缶ローヤル',450,5);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (25,5025,'煮干',320,5);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (26,6026,'ねこマンマ',480,6);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (27,6027,'ツナおじや',460,6);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (28,6028,'ねずみキッシュ',500,6);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (29,6029,'ねこ草のごまあえ',230,6);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (30,6030,'バッタのそぼろ煮',360,6);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (31,7031,'ネコ砂',800,7);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (32,7032,'トイレトレイ',1200,7);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (33,7033,'引っ掻き板',1500,7);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (34,7034,'上り棒',3200,7);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (35,7035,'ふかふか座布団',2800,7);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (36,8036,'またたび',980,8);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (37,8037,'またたび煙草',200,8);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (38,8038,'骨',560,8);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (39,8039,'またたびガム',120,8);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (40,8040,'マタタビドリンク',240,8);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (41,9041,'ネコジャラシ',870,9);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (42,9042,'毛糸玉',210,9);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (43,9043,'ボール',150,9);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (44,9044,'チョロチュー',300,9);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (45,9045,'フリスビー',450,9);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (46,10046,'鈴',50,10);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (47,10047,'首輪',1300,10);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (48,10048,'リボン',800,10);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (49,10049,'足輪',600,10);
INSERT INTO Products(ProductID,ProductCode,ProductName,Price,CategoryID) VALUES (50,10050,'毛止めクリップ',350,10);

--

INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (1,1,'2006-09-25',580000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (2,2,'2006-09-25',450000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (3,3,'2006-09-25',410000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (4,4,'2006-09-25',380000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (5,5,'2006-09-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (6,6,'2006-09-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (7,7,'2006-09-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (8,8,'2006-09-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (9,9,'2006-09-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (10,10,'2006-09-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (11,11,'2006-09-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (12,12,'2006-09-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (13,13,'2006-09-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (14,14,'2006-09-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (15,15,'2006-09-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (16,16,'2006-09-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (17,17,'2006-09-25',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (18,18,'2006-09-25',290000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (19,19,'2006-09-25',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (20,20,'2006-09-25',230000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (21,21,'2006-09-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (22,22,'2006-09-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (23,23,'2006-09-25',200000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (24,24,'2006-09-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (25,25,'2006-09-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (26,26,'2006-09-25',175000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (27,27,'2006-09-25',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (28,28,'2006-09-25',160000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (29,29,'2006-09-25',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (30,1,'2006-10-24',580000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (31,2,'2006-10-24',450000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (32,3,'2006-10-24',410000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (33,4,'2006-10-24',380000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (34,5,'2006-10-24',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (35,6,'2006-10-24',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (36,7,'2006-10-24',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (37,8,'2006-10-24',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (38,9,'2006-10-24',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (39,10,'2006-10-24',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (40,11,'2006-10-24',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (41,12,'2006-10-24',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (42,13,'2006-10-24',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (43,14,'2006-10-24',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (44,15,'2006-10-24',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (45,16,'2006-10-24',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (46,17,'2006-10-24',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (47,18,'2006-10-24',290000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (48,19,'2006-10-24',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (49,20,'2006-10-24',230000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (50,21,'2006-10-24',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (51,22,'2006-10-24',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (52,23,'2006-10-24',200000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (53,24,'2006-10-24',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (54,25,'2006-10-24',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (55,26,'2006-10-24',175000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (56,27,'2006-10-24',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (57,28,'2006-10-24',160000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (58,29,'2006-10-24',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (59,1,'2006-11-25',580000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (60,2,'2006-11-25',450000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (61,3,'2006-11-25',410000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (62,4,'2006-11-25',380000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (63,5,'2006-11-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (64,6,'2006-11-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (65,7,'2006-11-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (66,8,'2006-11-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (67,9,'2006-11-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (68,10,'2006-11-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (69,11,'2006-11-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (70,12,'2006-11-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (71,13,'2006-11-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (72,14,'2006-11-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (73,15,'2006-11-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (74,16,'2006-11-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (75,17,'2006-11-25',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (76,18,'2006-11-25',290000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (77,19,'2006-11-25',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (78,20,'2006-11-25',230000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (79,21,'2006-11-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (80,22,'2006-11-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (81,23,'2006-11-25',200000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (82,24,'2006-11-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (83,25,'2006-11-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (84,26,'2006-11-25',175000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (85,27,'2006-11-25',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (86,28,'2006-11-25',160000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (87,29,'2006-11-25',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (88,1,'2006-12-25',580000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (89,2,'2006-12-25',450000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (90,3,'2006-12-25',410000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (91,4,'2006-12-25',380000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (92,5,'2006-12-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (93,6,'2006-12-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (94,7,'2006-12-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (95,8,'2006-12-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (96,9,'2006-12-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (97,10,'2006-12-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (98,11,'2006-12-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (99,12,'2006-12-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (100,13,'2006-12-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (101,14,'2006-12-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (102,15,'2006-12-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (103,16,'2006-12-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (104,17,'2006-12-25',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (105,18,'2006-12-25',290000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (106,19,'2006-12-25',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (107,20,'2006-12-25',230000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (108,21,'2006-12-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (109,22,'2006-12-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (110,23,'2006-12-25',200000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (111,24,'2006-12-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (112,25,'2006-12-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (113,26,'2006-12-25',175000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (114,27,'2006-12-25',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (115,28,'2006-12-25',160000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (116,29,'2006-12-25',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (117,1,'2007-01-23',580000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (118,2,'2007-01-23',450000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (119,3,'2007-01-23',410000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (120,4,'2007-01-23',380000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (121,5,'2007-01-23',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (122,6,'2007-01-23',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (123,7,'2007-01-23',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (124,8,'2007-01-23',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (125,9,'2007-01-23',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (126,10,'2007-01-23',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (127,11,'2007-01-23',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (128,12,'2007-01-23',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (129,13,'2007-01-23',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (130,14,'2007-01-23',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (131,15,'2007-01-23',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (132,16,'2007-01-23',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (133,17,'2007-01-23',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (134,18,'2007-01-23',290000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (135,19,'2007-01-23',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (136,20,'2007-01-23',230000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (137,21,'2007-01-23',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (138,22,'2007-01-23',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (139,23,'2007-01-23',200000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (140,24,'2007-01-23',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (141,25,'2007-01-23',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (142,26,'2007-01-23',175000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (143,27,'2007-01-23',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (144,28,'2007-01-23',160000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (145,29,'2007-01-23',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (146,1,'2007-02-25',580000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (147,2,'2007-02-25',450000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (148,3,'2007-02-25',410000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (149,4,'2007-02-25',380000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (150,5,'2007-02-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (151,6,'2007-02-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (152,7,'2007-02-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (153,8,'2007-02-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (154,9,'2007-02-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (155,10,'2007-02-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (156,11,'2007-02-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (157,12,'2007-02-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (158,13,'2007-02-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (159,14,'2007-02-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (160,15,'2007-02-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (161,16,'2007-02-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (162,17,'2007-02-25',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (163,18,'2007-02-25',290000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (164,19,'2007-02-25',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (165,20,'2007-02-25',230000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (166,21,'2007-02-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (167,22,'2007-02-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (168,23,'2007-02-25',200000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (169,24,'2007-02-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (170,25,'2007-02-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (171,26,'2007-02-25',175000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (172,27,'2007-02-25',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (173,28,'2007-02-25',160000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (174,29,'2007-02-25',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (175,1,'2007-03-25',580000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (176,2,'2007-03-25',450000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (177,3,'2007-03-25',410000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (178,4,'2007-03-25',380000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (179,5,'2007-03-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (180,6,'2007-03-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (181,7,'2007-03-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (182,8,'2007-03-25',330000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (183,9,'2007-03-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (184,10,'2007-03-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (185,11,'2007-03-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (186,12,'2007-03-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (187,13,'2007-03-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (188,14,'2007-03-25',280000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (189,15,'2007-03-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (190,16,'2007-03-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (191,17,'2007-03-25',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (192,18,'2007-03-25',290000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (193,19,'2007-03-25',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (194,20,'2007-03-25',230000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (195,21,'2007-03-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (196,22,'2007-03-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (197,23,'2007-03-25',200000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (198,24,'2007-03-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (199,25,'2007-03-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (200,26,'2007-03-25',175000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (201,27,'2007-03-25',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (202,28,'2007-03-25',160000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (203,29,'2007-03-25',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (204,1,'2007-04-23',600000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (205,2,'2007-04-23',470000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (206,3,'2007-04-23',430000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (207,4,'2007-04-23',400000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (208,5,'2007-04-23',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (209,6,'2007-04-23',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (210,7,'2007-04-23',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (211,8,'2007-04-23',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (212,9,'2007-04-23',340000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (213,10,'2007-04-23',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (214,11,'2007-04-23',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (215,12,'2007-04-23',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (216,13,'2007-04-23',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (217,14,'2007-04-23',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (218,15,'2007-04-23',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (219,16,'2007-04-23',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (220,17,'2007-04-23',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (221,18,'2007-04-23',310000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (222,19,'2007-04-23',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (223,20,'2007-04-23',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (224,21,'2007-04-23',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (225,22,'2007-04-23',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (226,23,'2007-04-23',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (227,24,'2007-04-23',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (228,25,'2007-04-23',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (229,26,'2007-04-23',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (230,27,'2007-04-23',170000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (231,28,'2007-04-23',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (232,29,'2007-04-23',155000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (233,30,'2007-04-23',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (234,1,'2007-05-25',600000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (235,2,'2007-05-25',470000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (236,3,'2007-05-25',430000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (237,4,'2007-05-25',400000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (238,5,'2007-05-25',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (239,6,'2007-05-25',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (240,7,'2007-05-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (241,8,'2007-05-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (242,9,'2007-05-25',340000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (243,10,'2007-05-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (244,11,'2007-05-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (245,12,'2007-05-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (246,13,'2007-05-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (247,14,'2007-05-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (248,15,'2007-05-25',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (249,16,'2007-05-25',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (250,17,'2007-05-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (251,18,'2007-05-25',310000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (252,19,'2007-05-25',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (253,20,'2007-05-25',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (254,21,'2007-05-25',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (255,22,'2007-05-25',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (256,23,'2007-05-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (257,24,'2007-05-25',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (258,25,'2007-05-25',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (259,26,'2007-05-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (260,27,'2007-05-25',170000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (261,28,'2007-05-25',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (262,29,'2007-05-25',155000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (263,30,'2007-05-25',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (264,1,'2007-06-25',600000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (265,2,'2007-06-25',470000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (266,3,'2007-06-25',430000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (267,4,'2007-06-25',400000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (268,5,'2007-06-25',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (269,6,'2007-06-25',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (270,7,'2007-06-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (271,8,'2007-06-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (272,9,'2007-06-25',340000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (273,10,'2007-06-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (274,11,'2007-06-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (275,12,'2007-06-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (276,13,'2007-06-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (277,14,'2007-06-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (278,15,'2007-06-25',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (279,16,'2007-06-25',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (280,17,'2007-06-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (281,18,'2007-06-25',310000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (282,19,'2007-06-25',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (283,20,'2007-06-25',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (284,21,'2007-06-25',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (285,22,'2007-06-25',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (286,23,'2007-06-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (287,24,'2007-06-25',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (288,25,'2007-06-25',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (289,26,'2007-06-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (290,27,'2007-06-25',170000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (291,28,'2007-06-25',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (292,29,'2007-06-25',155000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (293,30,'2007-06-25',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (294,1,'2007-07-23',600000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (295,2,'2007-07-23',470000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (296,3,'2007-07-23',430000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (297,4,'2007-07-23',400000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (298,5,'2007-07-23',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (299,6,'2007-07-23',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (300,7,'2007-07-23',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (301,8,'2007-07-23',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (302,9,'2007-07-23',340000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (303,10,'2007-07-23',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (304,11,'2007-07-23',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (305,12,'2007-07-23',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (306,13,'2007-07-23',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (307,14,'2007-07-23',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (308,15,'2007-07-23',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (309,16,'2007-07-23',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (310,17,'2007-07-23',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (311,18,'2007-07-23',310000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (312,19,'2007-07-23',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (313,20,'2007-07-23',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (314,21,'2007-07-23',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (315,22,'2007-07-23',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (316,23,'2007-07-23',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (317,24,'2007-07-23',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (318,25,'2007-07-23',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (319,26,'2007-07-23',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (320,27,'2007-07-23',170000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (321,28,'2007-07-23',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (322,29,'2007-07-23',155000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (323,30,'2007-07-23',150000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (324,1,'2007-08-25',600000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (325,2,'2007-08-25',470000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (326,3,'2007-08-25',430000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (327,4,'2007-08-25',400000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (328,5,'2007-08-25',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (329,6,'2007-08-25',370000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (330,7,'2007-08-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (331,8,'2007-08-25',350000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (332,9,'2007-08-25',340000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (333,10,'2007-08-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (334,11,'2007-08-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (335,12,'2007-08-25',320000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (336,13,'2007-08-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (337,14,'2007-08-25',300000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (338,15,'2007-08-25',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (339,16,'2007-08-25',270000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (340,17,'2007-08-25',260000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (341,18,'2007-08-25',310000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (342,19,'2007-08-25',250000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (343,20,'2007-08-25',240000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (344,21,'2007-08-25',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (345,22,'2007-08-25',220000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (346,23,'2007-08-25',210000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (347,24,'2007-08-25',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (348,25,'2007-08-25',190000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (349,26,'2007-08-25',180000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (350,27,'2007-08-25',170000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (351,28,'2007-08-25',165000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (352,29,'2007-08-25',155000);
INSERT INTO Salary(SalaryID,EmployeeID,PayDate,Amount) VALUES (353,30,'2007-08-25',150000);

--

INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (1,5,3,21,19,'2006-09-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (2,1,20,14,4,'2006-09-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (3,1,20,9,4,'2006-09-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (4,6,15,22,6,'2006-09-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (5,2,21,20,22,'2006-09-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (6,3,22,17,25,'2006-09-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (7,24,17,40,5,'2006-09-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (8,12,17,20,5,'2006-09-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (9,10,1,2,17,'2006-09-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (10,1,5,6,19,'2006-09-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (11,1,19,26,16,'2006-09-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (12,3,19,28,16,'2006-09-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (13,1,18,35,17,'2006-09-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (14,4,18,44,17,'2006-09-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (15,1,18,49,17,'2006-09-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (16,30,13,16,12,'2006-09-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (17,30,13,17,12,'2006-09-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (18,20,13,19,12,'2006-09-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (19,15,11,9,7,'2006-09-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (20,1,14,13,20,'2006-09-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (21,1,14,15,20,'2006-09-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (22,2,25,25,16,'2006-09-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (23,1,7,30,28,'2006-09-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (24,3,8,27,29,'2006-09-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (25,5,12,23,27,'2006-09-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (26,1,12,29,27,'2006-09-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (27,100,6,21,18,'2006-09-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (28,1,2,1,11,'2006-09-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (29,2,2,7,11,'2006-09-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (30,1,2,12,11,'2006-09-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (31,1,26,31,20,'2006-09-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (32,10,30,31,8,'2006-09-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (33,24,30,17,8,'2006-09-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (34,2,4,3,17,'2006-09-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (35,1,4,12,17,'2006-09-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (36,1,4,14,17,'2006-09-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (37,3,9,19,26,'2006-09-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (38,36,27,39,7,'2006-09-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (39,12,27,44,7,'2006-09-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (40,30,28,22,5,'2006-09-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (41,48,10,36,5,'2006-09-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (42,12,10,39,5,'2006-09-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (43,50,16,16,7,'2006-09-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (44,50,16,17,7,'2006-09-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (45,50,16,18,7,'2006-09-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (46,1,29,42,19,'2006-09-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (47,3,29,46,19,'2006-09-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (48,20,23,18,8,'2006-09-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (49,1,3,4,21,'2006-09-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (50,1,3,5,21,'2006-09-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (51,3,3,32,21,'2006-09-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (52,1,15,31,4,'2006-09-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (53,1,15,9,4,'2006-09-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (54,1,15,20,4,'2006-09-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (55,5,12,6,17,'2006-09-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (56,3,2,21,27,'2006-09-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (57,1,2,34,27,'2006-09-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (58,1,8,24,27,'2006-09-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (59,1,8,30,27,'2006-09-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (60,10,8,37,27,'2006-09-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (61,5,19,19,21,'2006-09-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (62,2,1,39,29,'2006-09-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (63,10,1,40,29,'2006-09-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (64,2,21,43,14,'2006-09-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (65,1,21,11,14,'2006-09-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (66,4,21,13,14,'2006-09-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (67,1,29,21,16,'2006-09-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (68,1,29,2,16,'2006-09-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (69,1,29,13,16,'2006-09-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (70,20,11,9,5,'2006-09-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (71,20,11,10,5,'2006-09-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (72,20,11,11,5,'2006-09-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (73,1,5,18,19,'2006-09-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (74,8,5,20,19,'2006-09-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (75,1,5,25,19,'2006-09-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (76,1,26,30,28,'2006-09-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (77,1,20,33,6,'2006-09-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (78,3,20,37,6,'2006-09-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (79,1,15,26,21,'2006-09-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (80,1,15,37,21,'2006-09-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (81,1,15,40,21,'2006-09-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (82,25,1,2,28,'2006-10-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (83,1,1,10,28,'2006-10-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (84,10,11,11,25,'2006-10-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (85,1,19,47,22,'2006-10-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (86,1,19,48,22,'2006-10-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (87,1,19,39,22,'2006-10-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (88,3,25,10,20,'2006-10-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (89,1,25,13,20,'2006-10-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (90,1,25,20,20,'2006-10-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (91,36,28,22,18,'2006-10-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (92,36,28,23,18,'2006-10-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (93,36,28,24,18,'2006-10-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (94,3,14,19,11,'2006-10-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (95,1,14,42,11,'2006-10-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (96,50,16,18,7,'2006-10-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (97,5,3,1,29,'2006-10-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (98,5,3,8,29,'2006-10-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (99,100,6,21,5,'2006-10-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (100,10,8,20,21,'2006-10-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (101,10,8,24,21,'2006-10-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (102,1,8,10,21,'2006-10-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (103,20,9,6,7,'2006-10-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (104,30,9,9,7,'2006-10-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (105,10,20,31,17,'2006-10-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (106,2,2,11,14,'2006-10-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (107,1,2,12,14,'2006-10-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (108,1,2,13,14,'2006-10-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (109,1,22,22,25,'2006-10-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (110,1,22,20,25,'2006-10-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (111,30,23,17,18,'2006-10-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (112,1,29,40,20,'2006-10-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (113,1,29,20,20,'2006-10-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (114,1,29,2,20,'2006-10-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (115,20,30,31,8,'2006-10-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (116,20,30,17,8,'2006-10-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (117,20,30,41,8,'2006-10-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (118,30,13,16,7,'2006-10-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (119,1,26,44,22,'2006-10-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (120,1,26,49,22,'2006-10-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (121,50,27,39,12,'2006-10-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (122,12,27,50,12,'2006-10-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (123,1,12,19,20,'2006-10-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (124,7,18,9,4,'2006-10-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (125,1,18,13,4,'2006-10-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (126,1,18,15,4,'2006-10-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (127,6,21,25,6,'2006-10-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (128,1,21,30,6,'2006-10-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (129,1,21,27,6,'2006-10-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (130,40,17,40,5,'2006-10-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (131,20,10,36,18,'2006-10-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (132,50,10,39,18,'2006-10-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (133,1,15,1,14,'2006-10-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (134,1,15,7,14,'2006-10-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (135,1,15,12,14,'2006-10-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (136,2,5,31,17,'2006-10-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (137,1,5,31,17,'2006-10-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (138,1,7,17,23,'2006-10-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (139,1,4,3,26,'2006-10-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (140,3,4,12,26,'2006-10-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (141,5,4,14,26,'2006-10-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (142,1,18,19,21,'2006-10-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (143,1,19,39,22,'2006-10-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (144,1,19,44,22,'2006-10-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (145,1,26,22,27,'2006-10-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (146,1,26,36,27,'2006-10-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (147,1,26,39,27,'2006-10-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (148,2,8,16,14,'2006-10-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (149,1,8,17,14,'2006-10-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (150,1,1,18,11,'2006-10-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (151,1,14,42,6,'2006-10-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (152,1,14,46,6,'2006-10-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (153,1,14,18,6,'2006-10-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (154,1,21,4,19,'2006-10-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (155,6,21,5,19,'2006-10-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (156,1,3,32,19,'2006-10-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (157,1,2,31,21,'2006-10-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (158,1,2,9,21,'2006-10-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (159,1,2,20,21,'2006-10-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (160,1,25,6,17,'2006-10-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (161,1,25,21,17,'2006-10-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (162,1,25,34,17,'2006-10-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (163,8,18,24,4,'2006-10-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (164,1,18,30,4,'2006-10-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (165,1,18,37,4,'2006-10-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (166,30,30,17,5,'2006-11-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (167,10,30,41,5,'2006-11-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (168,1,5,40,25,'2006-11-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (169,1,7,43,4,'2006-11-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (170,1,7,11,4,'2006-11-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (171,1,7,13,4,'2006-11-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (172,1,2,21,17,'2006-11-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (173,1,2,2,17,'2006-11-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (174,2,1,13,17,'2006-11-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (175,10,10,36,12,'2006-11-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (176,20,10,39,12,'2006-11-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (177,100,10,21,12,'2006-11-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (178,30,13,17,7,'2006-11-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (179,1,19,20,6,'2006-11-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (180,1,19,25,6,'2006-11-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (181,1,14,30,4,'2006-11-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (182,1,15,33,19,'2006-11-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (183,1,15,37,19,'2006-11-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (184,30,23,16,7,'2006-11-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (185,30,23,17,7,'2006-11-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (186,25,23,18,7,'2006-11-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (187,20,11,10,8,'2006-11-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (188,1,8,10,23,'2006-11-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (189,1,8,11,23,'2006-11-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (190,1,3,47,11,'2006-11-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (191,1,3,48,11,'2006-11-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (192,1,4,39,4,'2006-11-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (193,120,6,21,5,'2006-11-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (194,80,6,22,5,'2006-11-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (195,60,6,24,5,'2006-11-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (196,50,16,18,18,'2006-11-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (197,1,20,23,20,'2006-11-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (198,1,20,24,20,'2006-11-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (199,3,15,19,25,'2006-11-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (200,1,15,42,25,'2006-11-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (201,1,15,18,25,'2006-11-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (202,5,12,1,14,'2006-11-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (203,1,12,8,14,'2006-11-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (204,1,12,21,14,'2006-11-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (205,1,18,20,19,'2006-11-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (206,1,18,24,19,'2006-11-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (207,35,17,20,12,'2006-11-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (208,1,21,6,23,'2006-11-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (209,1,21,9,23,'2006-11-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (210,1,21,31,23,'2006-11-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (211,30,27,39,8,'2006-11-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (212,20,27,44,8,'2006-11-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (213,10,27,50,8,'2006-11-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (214,1,29,4,29,'2006-11-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (215,1,29,5,29,'2006-11-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (216,3,29,32,29,'2006-11-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (217,1,2,31,4,'2006-11-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (218,1,2,9,4,'2006-11-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (219,1,1,20,6,'2006-11-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (220,10,9,6,7,'2006-11-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (221,10,9,9,7,'2006-11-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (222,5,9,31,7,'2006-11-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (223,2,22,24,17,'2006-11-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (224,2,7,30,11,'2006-11-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (225,1,7,37,11,'2006-11-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (226,1,26,19,26,'2006-11-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (227,1,26,39,26,'2006-11-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (228,4,26,40,26,'2006-11-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (229,50,28,22,18,'2006-11-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (230,20,28,23,18,'2006-11-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (231,30,28,24,18,'2006-11-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (232,1,3,21,11,'2006-11-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (233,1,3,2,11,'2006-11-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (234,1,3,13,11,'2006-11-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (235,1,14,9,17,'2006-11-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (236,5,18,10,4,'2006-11-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (237,1,18,11,4,'2006-11-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (238,1,25,18,23,'2006-11-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (239,1,25,20,23,'2006-11-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (240,2,25,25,23,'2006-11-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (241,3,12,30,21,'2006-11-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (242,1,12,33,21,'2006-11-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (243,1,12,37,21,'2006-11-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (244,4,19,26,19,'2006-11-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (245,1,20,37,28,'2006-11-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (246,1,20,40,28,'2006-11-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (247,30,6,24,5,'2006-12-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (248,10,10,36,5,'2006-12-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (249,50,10,37,5,'2006-12-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (250,30,17,20,12,'2006-12-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (251,30,17,40,12,'2006-12-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (252,10,17,46,12,'2006-12-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (253,1,20,10,19,'2006-12-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (254,1,21,13,29,'2006-12-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (255,1,21,20,29,'2006-12-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (256,30,13,16,8,'2006-12-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (257,30,13,17,8,'2006-12-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (258,100,13,19,8,'2006-12-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (259,1,15,19,16,'2006-12-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (260,1,15,42,16,'2006-12-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (261,1,15,18,16,'2006-12-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (262,1,1,1,11,'2006-12-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (263,1,1,8,11,'2006-12-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (264,1,9,21,22,'2006-12-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (265,100,16,18,18,'2006-12-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (266,1,12,24,23,'2006-12-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (267,1,12,10,23,'2006-12-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (268,1,18,6,25,'2006-12-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (269,1,18,9,25,'2006-12-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (270,1,18,31,25,'2006-12-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (271,50,27,39,7,'2006-12-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (272,20,27,44,7,'2006-12-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (273,1,26,13,14,'2006-12-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (274,10,30,31,8,'2006-12-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (275,1,25,20,21,'2006-12-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (276,1,25,17,21,'2006-12-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (277,30,23,40,12,'2006-12-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (278,1,7,20,17,'2006-12-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (279,1,7,2,17,'2006-12-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (280,1,8,6,23,'2006-12-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (281,2,8,26,23,'2006-12-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (282,1,8,28,23,'2006-12-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (283,1,3,35,28,'2006-12-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (284,1,3,44,28,'2006-12-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (285,2,2,49,29,'2006-12-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (286,2,14,16,20,'2006-12-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (287,2,14,17,20,'2006-12-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (288,1,14,19,20,'2006-12-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (289,1,20,9,11,'2006-12-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (290,1,20,13,11,'2006-12-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (291,3,20,15,11,'2006-12-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (292,1,19,25,4,'2006-12-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (293,1,19,30,4,'2006-12-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (294,1,19,27,4,'2006-12-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (295,50,28,23,5,'2006-12-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (296,1,4,29,6,'2006-12-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (297,1,4,21,6,'2006-12-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (298,30,11,11,18,'2006-12-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (299,1,5,7,20,'2006-12-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (300,1,5,12,20,'2006-12-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (301,2,18,31,11,'2006-12-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (302,1,18,31,11,'2006-12-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (303,1,18,17,11,'2006-12-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (304,1,22,3,19,'2006-12-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (305,1,22,12,19,'2006-12-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (306,2,22,14,19,'2006-12-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (307,1,21,19,25,'2006-12-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (308,1,21,39,25,'2006-12-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (309,3,21,44,25,'2006-12-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (310,1,29,22,11,'2006-12-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (311,1,29,36,11,'2006-12-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (312,1,29,39,11,'2006-12-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (313,1,12,16,23,'2006-12-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (314,4,12,17,23,'2006-12-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (315,1,20,18,25,'2006-12-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (316,1,1,42,11,'2006-12-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (317,1,1,46,11,'2006-12-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (318,2,1,18,11,'2006-12-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (319,1,5,4,29,'2006-12-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (320,1,5,5,29,'2006-12-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (321,1,5,32,29,'2006-12-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (322,1,8,31,28,'2006-12-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (323,1,8,9,28,'2006-12-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (324,1,8,20,28,'2006-12-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (325,2,15,6,19,'2006-12-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (326,2,15,21,19,'2006-12-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (327,1,21,34,21,'2006-12-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (328,1,14,24,4,'2006-12-30');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (329,1,14,30,4,'2006-12-30');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (330,1,14,37,4,'2006-12-30');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (331,1,29,19,17,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (332,1,29,39,17,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (333,1,29,40,17,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (334,1,29,43,17,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (335,2,29,11,17,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (336,1,8,13,16,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (337,1,8,21,16,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (338,1,8,2,16,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (339,2,8,13,16,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (340,1,4,9,11,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (341,1,4,10,11,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (342,1,4,12,11,'2006-12-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (343,1,4,14,11,'2007-01-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (344,2,7,19,16,'2007-01-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (345,1,7,39,16,'2007-01-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (346,15,10,44,18,'2007-01-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (347,30,10,22,18,'2007-01-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (348,30,10,36,18,'2007-01-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (349,1,1,39,20,'2007-01-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (350,1,1,16,20,'2007-01-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (351,20,17,17,7,'2007-01-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (352,1,20,18,21,'2007-01-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (353,1,21,42,25,'2007-01-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (354,1,21,46,25,'2007-01-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (355,2,8,18,6,'2007-01-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (356,1,8,4,6,'2007-01-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (357,1,8,5,6,'2007-01-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (358,10,16,32,8,'2007-01-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (359,30,16,31,8,'2007-01-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (360,1,26,9,25,'2007-01-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (361,24,9,20,7,'2007-01-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (362,1,2,6,21,'2007-01-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (363,1,2,21,21,'2007-01-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (364,5,6,34,7,'2007-01-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (365,30,23,16,12,'2007-01-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (366,30,23,17,12,'2007-01-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (367,2,29,18,21,'2007-01-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (368,1,29,19,21,'2007-01-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (369,1,29,39,21,'2007-01-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (370,120,27,40,18,'2007-01-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (371,1,8,43,19,'2007-01-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (372,1,8,11,19,'2007-01-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (373,30,11,9,5,'2007-01-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (374,30,11,10,5,'2007-01-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (375,50,11,11,5,'2007-01-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (376,1,15,13,23,'2007-01-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (377,1,15,9,23,'2007-01-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (378,1,15,10,23,'2007-01-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (379,1,18,11,22,'2007-01-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (380,2,18,18,22,'2007-01-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (381,1,18,20,22,'2007-01-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (382,1,7,25,17,'2007-01-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (383,1,7,30,17,'2007-01-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (384,1,7,33,17,'2007-01-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (385,3,12,37,25,'2007-01-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (386,1,12,26,25,'2007-01-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (387,60,13,37,8,'2007-01-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (388,1,22,40,4,'2007-01-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (389,1,22,2,4,'2007-01-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (390,1,19,10,25,'2007-01-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (391,3,28,11,21,'2007-01-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (392,1,8,47,21,'2007-01-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (393,1,8,48,21,'2007-01-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (394,1,25,39,19,'2007-01-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (395,1,25,10,19,'2007-01-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (396,1,25,13,19,'2007-01-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (397,30,30,20,5,'2007-01-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (398,80,30,22,5,'2007-01-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (399,60,30,23,5,'2007-01-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (400,1,3,24,17,'2007-01-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (401,2,3,19,17,'2007-01-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (402,1,3,42,17,'2007-01-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (403,1,14,18,21,'2007-01-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (404,1,14,1,21,'2007-01-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (405,3,14,8,21,'2007-01-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (406,1,4,21,29,'2007-01-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (407,1,4,20,29,'2007-01-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (408,1,4,24,29,'2007-01-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (409,1,5,10,27,'2007-01-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (410,1,5,6,27,'2007-01-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (411,2,5,9,27,'2007-01-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (412,1,20,31,4,'2007-01-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (413,1,20,11,4,'2007-01-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (414,1,20,12,4,'2007-01-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (415,5,21,13,11,'2007-01-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (416,1,21,22,11,'2007-01-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (417,1,21,20,11,'2007-01-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (418,1,2,17,27,'2007-02-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (419,1,2,40,27,'2007-02-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (420,1,2,20,27,'2007-02-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (421,1,8,2,6,'2007-02-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (422,8,8,6,6,'2007-02-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (423,1,8,26,6,'2007-02-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (424,50,16,19,7,'2007-02-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (425,1,22,35,21,'2007-02-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (426,1,22,44,21,'2007-02-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (427,1,3,49,4,'2007-02-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (428,1,3,16,4,'2007-02-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (429,1,3,17,4,'2007-02-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (430,1,18,19,16,'2007-02-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (431,1,19,9,16,'2007-02-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (432,1,19,13,16,'2007-02-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (433,20,17,20,12,'2007-02-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (434,50,17,39,12,'2007-02-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (435,30,17,40,12,'2007-02-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (436,1,8,27,17,'2007-02-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (437,1,8,23,17,'2007-02-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (438,1,8,29,17,'2007-02-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (439,1,12,21,21,'2007-02-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (440,1,12,1,21,'2007-02-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (441,180,6,21,8,'2007-02-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (442,20,11,10,7,'2007-02-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (443,1,1,31,11,'2007-02-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (444,1,1,31,11,'2007-02-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (445,20,9,6,7,'2007-02-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (446,30,9,9,7,'2007-02-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (447,30,9,31,7,'2007-02-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (448,1,4,14,6,'2007-02-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (449,1,4,19,6,'2007-02-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (450,1,4,39,6,'2007-02-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (451,1,8,44,22,'2007-02-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (452,1,8,22,22,'2007-02-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (453,1,8,36,22,'2007-02-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (454,1,20,39,29,'2007-02-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (455,1,20,16,29,'2007-02-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (456,1,20,17,29,'2007-02-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (457,50,28,22,12,'2007-02-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (458,50,28,23,12,'2007-02-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (459,50,28,24,12,'2007-02-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (460,30,23,18,7,'2007-02-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (461,20,23,19,7,'2007-02-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (462,1,8,5,22,'2007-02-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (463,1,21,32,11,'2007-02-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (464,1,21,31,11,'2007-02-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (465,2,21,9,11,'2007-02-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (466,1,15,20,6,'2007-02-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (467,1,14,6,4,'2007-02-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (468,1,14,21,4,'2007-02-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (469,1,4,34,19,'2007-02-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (470,1,4,24,19,'2007-02-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (471,1,7,30,27,'2007-02-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (472,20,10,36,5,'2007-02-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (473,80,10,37,5,'2007-02-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (474,100,10,39,5,'2007-02-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (475,1,5,40,29,'2007-02-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (476,1,5,43,29,'2007-02-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (477,1,5,11,29,'2007-02-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (478,1,26,13,21,'2007-02-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (479,1,29,21,23,'2007-02-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (480,1,29,2,23,'2007-02-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (481,50,13,16,18,'2007-02-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (482,1,25,9,19,'2007-02-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (483,1,25,10,19,'2007-02-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (484,1,8,11,25,'2007-02-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (485,1,8,18,25,'2007-02-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (486,1,8,20,25,'2007-02-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (487,20,30,17,8,'2007-02-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (488,20,30,31,8,'2007-02-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (489,10,30,41,8,'2007-02-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (490,60,27,50,7,'2007-02-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (491,1,25,26,17,'2007-02-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (492,1,25,37,17,'2007-02-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (493,1,12,40,6,'2007-02-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (494,1,12,2,6,'2007-02-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (495,1,12,10,6,'2007-02-28');
/*
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (496,3,21,11,22,'2007-02-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (497,1,21,47,22,'2007-02-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (498,5,21,48,22,'2007-02-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (499,1,21,39,22,'2007-02-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (500,1,21,10,22,'2007-02-29');
*/
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (501,1,4,13,26,'2007-03-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (502,1,4,20,26,'2007-03-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (503,1,4,22,26,'2007-03-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (504,35,13,23,12,'2007-03-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (505,1,21,24,28,'2007-03-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (506,1,21,19,28,'2007-03-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (507,1,21,42,28,'2007-03-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (508,1,12,18,11,'2007-03-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (509,1,12,1,11,'2007-03-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (510,1,12,8,11,'2007-03-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (511,100,6,21,18,'2007-03-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (512,40,6,20,18,'2007-03-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (513,60,6,24,18,'2007-03-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (514,1,8,10,6,'2007-03-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (515,1,8,6,6,'2007-03-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (516,2,8,9,6,'2007-03-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (517,1,1,31,17,'2007-03-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (518,1,1,11,17,'2007-03-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (519,1,1,12,17,'2007-03-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (520,1,3,13,27,'2007-03-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (521,3,2,4,27,'2007-03-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (522,1,2,5,27,'2007-03-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (523,1,19,32,16,'2007-03-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (524,1,19,31,16,'2007-03-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (525,2,19,9,16,'2007-03-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (526,1,26,20,20,'2007-03-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (527,1,26,6,20,'2007-03-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (528,80,10,21,5,'2007-03-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (529,5,16,34,5,'2007-03-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (530,20,16,24,5,'2007-03-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (531,50,16,31,5,'2007-03-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (532,1,29,37,21,'2007-03-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (533,1,29,19,21,'2007-03-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (534,1,28,39,27,'2007-03-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (535,5,8,40,29,'2007-03-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (536,1,7,43,29,'2007-03-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (537,1,7,11,29,'2007-03-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (538,20,23,16,8,'2007-03-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (539,20,23,17,8,'2007-03-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (540,20,23,18,8,'2007-03-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (541,1,20,22,11,'2007-03-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (542,4,20,20,11,'2007-03-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (543,1,20,17,11,'2007-03-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (544,3,14,40,20,'2007-03-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (545,1,14,20,20,'2007-03-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (546,1,14,2,20,'2007-03-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (547,100,11,6,7,'2007-03-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (548,1,22,26,23,'2007-03-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (549,1,22,28,23,'2007-03-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (550,1,4,35,4,'2007-03-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (551,1,4,44,4,'2007-03-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (552,1,4,49,4,'2007-03-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (553,300,17,16,8,'2007-03-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (554,1,25,17,6,'2007-03-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (555,1,25,19,6,'2007-03-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (556,1,12,9,16,'2007-03-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (557,1,12,13,16,'2007-03-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (558,1,12,15,16,'2007-03-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (559,30,9,6,18,'2007-03-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (560,80,9,9,18,'2007-03-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (561,20,9,31,18,'2007-03-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (562,1,15,23,17,'2007-03-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (563,1,15,29,17,'2007-03-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (564,1,15,21,17,'2007-03-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (565,120,27,40,7,'2007-03-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (566,1,18,7,29,'2007-03-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (567,1,18,12,29,'2007-03-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (568,2,8,31,27,'2007-03-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (569,2,8,31,27,'2007-03-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (570,2,8,17,27,'2007-03-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (571,2,5,3,14,'2007-03-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (572,1,5,12,14,'2007-03-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (573,1,5,14,14,'2007-03-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (574,1,25,19,6,'2007-03-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (575,1,25,39,6,'2007-03-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (576,1,25,44,6,'2007-03-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (577,50,30,22,8,'2007-03-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (578,50,30,23,8,'2007-03-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (579,70,30,24,8,'2007-03-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (580,1,12,16,22,'2007-03-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (581,1,12,17,22,'2007-03-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (582,3,8,18,4,'2007-03-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (583,3,4,42,14,'2007-03-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (584,1,1,46,4,'2007-03-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (585,2,1,18,4,'2007-03-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (586,2,2,4,17,'2007-04-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (587,2,2,5,17,'2007-04-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (588,2,2,32,17,'2007-04-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (589,1,12,31,21,'2007-04-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (590,1,12,9,21,'2007-04-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (591,1,12,20,21,'2007-04-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (592,50,17,40,12,'2007-04-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (593,1,25,21,30,'2007-04-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (594,1,25,34,30,'2007-04-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (595,30,28,24,5,'2007-04-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (596,10,28,31,5,'2007-04-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (597,50,28,37,5,'2007-04-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (598,1,15,19,14,'2007-04-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (599,1,15,39,14,'2007-04-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (600,1,15,40,14,'2007-04-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (601,320,10,43,12,'2007-04-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (602,1,8,11,30,'2007-04-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (603,1,8,13,30,'2007-04-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (604,1,3,21,4,'2007-04-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (605,1,3,2,4,'2007-04-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (606,1,3,13,4,'2007-04-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (607,50,9,9,7,'2007-04-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (608,50,9,10,7,'2007-04-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (609,50,9,11,7,'2007-04-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (610,1,14,18,19,'2007-04-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (611,1,14,20,19,'2007-04-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (612,1,14,25,19,'2007-04-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (613,1,20,30,30,'2007-04-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (614,1,21,33,14,'2007-04-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (615,1,21,37,14,'2007-04-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (616,1,29,26,30,'2007-04-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (617,1,29,37,30,'2007-04-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (618,1,29,40,30,'2007-04-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (619,1,4,2,29,'2007-04-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (620,1,4,10,29,'2007-04-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (621,1,4,11,29,'2007-04-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (622,1,1,47,30,'2007-04-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (623,1,1,48,30,'2007-04-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (624,1,1,39,30,'2007-04-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (625,1,15,10,14,'2007-04-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (626,1,15,13,14,'2007-04-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (627,1,15,20,14,'2007-04-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (628,1,5,22,30,'2007-04-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (629,1,5,23,30,'2007-04-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (630,1,5,24,30,'2007-04-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (631,200,16,19,7,'2007-04-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (632,1,7,42,26,'2007-04-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (633,1,7,18,26,'2007-04-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (634,1,22,1,14,'2007-04-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (635,1,22,8,14,'2007-04-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (636,1,22,21,14,'2007-04-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (637,80,23,20,5,'2007-04-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (638,50,23,24,5,'2007-04-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (639,50,23,10,5,'2007-04-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (640,20,11,6,18,'2007-04-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (641,20,11,9,18,'2007-04-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (642,30,11,31,18,'2007-04-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (643,100,6,11,7,'2007-04-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (644,100,6,16,7,'2007-04-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (645,100,6,17,7,'2007-04-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (646,1,19,22,30,'2007-04-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (647,1,19,20,30,'2007-04-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (648,50,27,17,8,'2007-04-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (649,1,8,40,29,'2007-04-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (650,1,8,20,29,'2007-04-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (651,4,8,2,29,'2007-04-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (652,5,12,6,30,'2007-04-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (653,1,12,26,30,'2007-04-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (654,1,12,28,30,'2007-04-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (655,1,18,35,16,'2007-04-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (656,1,18,44,16,'2007-04-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (657,10,26,49,27,'2007-04-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (658,1,26,16,27,'2007-04-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (659,1,26,17,27,'2007-04-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (660,1,26,19,27,'2007-04-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (661,50,30,17,18,'2007-04-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (662,30,30,31,18,'2007-04-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (663,50,30,41,18,'2007-04-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (664,1,1,25,11,'2007-04-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (665,1,1,30,11,'2007-04-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (666,1,1,27,11,'2007-04-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (667,1,4,23,28,'2007-04-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (668,30,13,11,5,'2007-04-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (669,1,5,21,19,'2007-05-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (670,1,5,1,19,'2007-05-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (671,1,5,7,19,'2007-05-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (672,1,15,12,30,'2007-05-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (673,1,15,31,30,'2007-05-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (674,30,23,31,12,'2007-05-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (675,50,11,17,5,'2007-05-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (676,1,29,3,28,'2007-05-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (677,1,29,12,28,'2007-05-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (678,1,2,14,20,'2007-05-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (679,1,2,19,20,'2007-05-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (680,1,2,39,20,'2007-05-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (681,30,10,44,12,'2007-05-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (682,50,10,22,12,'2007-05-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (683,60,10,36,12,'2007-05-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (684,1,19,39,11,'2007-05-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (685,1,19,16,11,'2007-05-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (686,2,19,17,11,'2007-05-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (687,1,12,18,30,'2007-05-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (688,1,12,42,30,'2007-05-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (689,1,12,46,30,'2007-05-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (690,25,17,18,8,'2007-05-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (691,1,25,4,17,'2007-05-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (692,1,25,5,17,'2007-05-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (693,1,8,32,19,'2007-05-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (694,1,8,31,21,'2007-05-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (695,1,8,9,21,'2007-05-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (696,20,27,20,7,'2007-05-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (697,30,27,6,7,'2007-05-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (698,90,27,21,7,'2007-05-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (699,1,14,34,11,'2007-05-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (700,1,7,24,14,'2007-05-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (701,1,7,30,14,'2007-05-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (702,45,13,16,8,'2007-05-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (703,1,4,19,30,'2007-05-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (704,1,4,39,30,'2007-05-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (705,1,4,40,30,'2007-05-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (706,1,18,43,25,'2007-05-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (707,1,18,11,25,'2007-05-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (708,35,28,22,12,'2007-05-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (709,20,9,6,18,'2007-05-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (710,20,9,9,18,'2007-05-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (711,30,9,31,18,'2007-05-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (712,1,1,9,28,'2007-05-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (713,1,1,10,28,'2007-05-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (714,1,1,11,28,'2007-05-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (715,60,6,21,5,'2007-05-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (716,30,16,17,12,'2007-05-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (717,30,16,18,12,'2007-05-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (718,30,16,19,12,'2007-05-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (719,1,21,33,21,'2007-05-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (720,1,21,37,21,'2007-05-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (721,3,29,26,17,'2007-05-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (722,10,20,37,27,'2007-05-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (723,1,20,40,27,'2007-05-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (724,1,12,2,28,'2007-05-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (725,1,12,10,28,'2007-05-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (726,8,12,11,28,'2007-05-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (727,1,3,47,30,'2007-05-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (728,1,3,48,30,'2007-05-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (729,1,3,39,30,'2007-05-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (730,1,26,10,16,'2007-05-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (731,6,29,13,16,'2007-05-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (732,1,29,20,16,'2007-05-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (733,1,8,22,25,'2007-05-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (734,1,8,23,25,'2007-05-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (735,1,22,24,30,'2007-05-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (736,1,5,19,29,'2007-05-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (737,2,5,42,29,'2007-05-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (738,1,5,18,29,'2007-05-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (739,1,4,1,30,'2007-05-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (740,1,4,8,30,'2007-05-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (741,1,4,21,30,'2007-05-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (742,20,30,31,8,'2007-05-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (743,50,30,17,8,'2007-05-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (744,50,30,18,8,'2007-05-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (745,1,21,6,25,'2007-05-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (746,1,21,9,25,'2007-05-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (747,1,22,31,30,'2007-05-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (748,30,11,11,7,'2007-05-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (749,20,11,9,7,'2007-05-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (750,20,11,10,7,'2007-05-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (751,1,22,4,28,'2007-05-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (752,1,22,5,28,'2007-05-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (753,1,22,32,28,'2007-05-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (754,1,15,31,30,'2007-06-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (755,1,15,9,30,'2007-06-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (756,1,15,20,30,'2007-06-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (757,50,6,24,18,'2007-06-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (758,50,6,21,18,'2007-06-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (759,50,6,22,18,'2007-06-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (760,60,28,22,12,'2007-06-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (761,30,28,23,12,'2007-06-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (762,45,28,24,12,'2007-06-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (763,1,8,19,11,'2007-06-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (764,1,8,39,11,'2007-06-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (765,1,8,40,11,'2007-06-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (766,1,12,43,16,'2007-06-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (767,1,12,11,16,'2007-06-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (768,1,12,13,16,'2007-06-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (769,50,17,20,5,'2007-06-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (770,1,20,2,30,'2007-06-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (771,1,20,13,30,'2007-06-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (772,20,10,36,7,'2007-06-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (773,50,10,37,7,'2007-06-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (774,30,10,39,7,'2007-06-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (775,1,14,18,29,'2007-06-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (776,1,14,20,29,'2007-06-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (777,3,19,25,30,'2007-06-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (778,5,1,30,28,'2007-06-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (779,1,1,33,28,'2007-06-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (780,1,1,37,28,'2007-06-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (781,1,4,26,16,'2007-06-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (782,1,4,37,16,'2007-06-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (783,1,4,40,16,'2007-06-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (784,30,27,39,8,'2007-06-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (785,20,27,44,8,'2007-06-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (786,1,29,11,30,'2007-06-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (787,35,13,16,5,'2007-06-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (788,1,5,48,6,'2007-06-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (789,1,5,39,6,'2007-06-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (790,1,2,10,30,'2007-06-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (791,1,2,13,30,'2007-06-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (792,1,2,20,30,'2007-06-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (793,50,11,22,5,'2007-06-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (794,50,11,23,5,'2007-06-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (795,50,11,24,5,'2007-06-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (796,50,23,19,12,'2007-06-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (797,30,9,31,7,'2007-06-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (798,15,9,32,7,'2007-06-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (799,1,8,1,30,'2007-06-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (800,1,8,8,30,'2007-06-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (801,1,8,21,30,'2007-06-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (802,80,16,19,7,'2007-06-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (803,1,19,24,29,'2007-06-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (804,1,19,10,29,'2007-06-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (805,5,18,6,28,'2007-06-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (806,1,18,9,28,'2007-06-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (807,1,18,31,28,'2007-06-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (808,8,26,11,27,'2007-06-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (809,1,21,12,25,'2007-06-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (810,1,21,13,25,'2007-06-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (811,1,4,22,11,'2007-06-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (812,1,26,20,6,'2007-06-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (813,3,26,17,6,'2007-06-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (814,2,7,40,14,'2007-06-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (815,1,7,20,14,'2007-06-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (816,1,7,2,14,'2007-06-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (817,1,22,6,16,'2007-06-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (818,1,3,26,27,'2007-06-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (819,3,3,28,27,'2007-06-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (820,1,25,35,30,'2007-06-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (821,1,25,44,30,'2007-06-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (822,2,25,49,30,'2007-06-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (823,2,12,16,28,'2007-06-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (824,1,12,17,28,'2007-06-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (825,1,12,19,28,'2007-06-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (826,1,4,9,4,'2007-06-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (827,1,4,13,4,'2007-06-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (828,1,4,15,4,'2007-06-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (829,50,30,31,18,'2007-06-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (830,20,30,32,18,'2007-06-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (831,30,30,11,18,'2007-06-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (832,1,1,23,11,'2007-06-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (833,1,1,29,11,'2007-06-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (834,10,12,21,16,'2007-06-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (835,1,22,1,28,'2007-06-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (836,1,22,7,28,'2007-06-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (837,1,22,12,28,'2007-06-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (838,8,3,31,30,'2007-07-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (839,1,3,31,30,'2007-07-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (840,1,3,17,30,'2007-07-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (841,15,10,31,12,'2007-07-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (842,30,10,9,12,'2007-07-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (843,10,10,10,12,'2007-07-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (844,1,4,19,23,'2007-07-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (845,25,27,39,7,'2007-07-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (846,10,27,44,7,'2007-07-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (847,1,12,22,25,'2007-07-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (848,1,12,36,25,'2007-07-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (849,1,12,39,25,'2007-07-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (850,30,6,25,8,'2007-07-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (851,1,20,17,30,'2007-07-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (852,1,20,18,30,'2007-07-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (853,20,13,18,7,'2007-07-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (854,50,23,19,8,'2007-07-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (855,10,23,18,8,'2007-07-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (856,1,15,4,30,'2007-07-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (857,3,8,5,23,'2007-07-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (858,1,8,32,23,'2007-07-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (859,1,1,24,14,'2007-07-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (860,1,1,10,14,'2007-07-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (861,1,1,6,14,'2007-07-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (862,20,17,9,7,'2007-07-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (863,20,16,31,12,'2007-07-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (864,30,16,11,12,'2007-07-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (865,1,25,12,6,'2007-07-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (866,1,26,13,30,'2007-07-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (867,2,26,22,30,'2007-07-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (868,2,14,20,22,'2007-07-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (869,1,14,17,22,'2007-07-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (870,1,15,40,6,'2007-07-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (871,1,15,20,6,'2007-07-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (872,3,15,2,6,'2007-07-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (873,3,19,6,30,'2007-07-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (874,1,22,26,17,'2007-07-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (875,1,22,28,17,'2007-07-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (876,1,22,35,17,'2007-07-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (877,30,28,22,8,'2007-07-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (878,15,28,23,8,'2007-07-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (879,30,28,24,8,'2007-07-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (880,1,7,17,30,'2007-07-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (881,1,18,19,22,'2007-07-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (882,5,8,9,11,'2007-07-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (883,1,8,13,11,'2007-07-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (884,6,4,15,6,'2007-07-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (885,1,4,25,6,'2007-07-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (886,1,5,30,30,'2007-07-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (887,2,5,27,30,'2007-07-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (888,1,3,23,19,'2007-07-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (889,2,2,29,23,'2007-07-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (890,1,2,21,23,'2007-07-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (891,120,23,2,5,'2007-07-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (892,1,21,7,11,'2007-07-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (893,4,21,12,11,'2007-07-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (894,1,21,31,11,'2007-07-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (895,1,29,31,4,'2007-07-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (896,2,1,17,30,'2007-07-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (897,1,1,3,30,'2007-07-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (898,3,12,12,29,'2007-07-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (899,1,12,14,29,'2007-07-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (900,1,12,19,29,'2007-07-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (901,30,23,16,18,'2007-07-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (902,30,23,17,18,'2007-07-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (903,60,23,19,18,'2007-07-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (904,1,20,36,25,'2007-07-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (905,1,20,39,25,'2007-07-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (906,1,9,16,30,'2007-07-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (907,30,30,31,5,'2007-07-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (908,50,30,11,5,'2007-07-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (909,10,30,41,5,'2007-07-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (910,20,11,9,7,'2007-07-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (911,20,11,10,7,'2007-07-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (912,50,11,11,7,'2007-07-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (913,1,22,5,30,'2007-07-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (914,1,22,32,30,'2007-07-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (915,5,22,31,30,'2007-07-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (916,8,8,9,11,'2007-07-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (917,1,8,20,11,'2007-07-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (918,1,8,6,11,'2007-07-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (919,1,15,21,16,'2007-07-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (920,1,12,34,19,'2007-07-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (921,1,12,24,19,'2007-07-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (922,30,13,16,12,'2007-08-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (923,50,13,19,12,'2007-08-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (924,1,1,19,11,'2007-08-01');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (925,1,18,39,30,'2007-08-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (926,1,21,40,16,'2007-08-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (927,1,21,43,16,'2007-08-02');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (928,1,4,11,4,'2007-08-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (929,1,4,13,4,'2007-08-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (930,1,4,21,4,'2007-08-03');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (931,80,23,19,18,'2007-08-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (932,50,28,22,18,'2007-08-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (933,50,28,24,18,'2007-08-04');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (934,1,19,10,4,'2007-08-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (935,1,19,12,4,'2007-08-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (936,6,19,14,4,'2007-08-05');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (937,1,8,19,30,'2007-08-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (938,1,8,39,30,'2007-08-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (939,2,8,44,30,'2007-08-06');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (940,1,2,22,28,'2007-08-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (941,1,5,36,25,'2007-08-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (942,1,5,39,25,'2007-08-07');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (943,1,20,16,23,'2007-08-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (944,3,20,17,23,'2007-08-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (945,1,3,18,19,'2007-08-08');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (946,1,21,42,11,'2007-08-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (947,1,21,46,11,'2007-08-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (948,1,21,18,11,'2007-08-09');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (949,1,26,4,30,'2007-08-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (950,50,27,39,12,'2007-08-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (951,100,27,40,12,'2007-08-11');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (952,80,11,31,7,'2007-08-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (953,1,4,9,30,'2007-08-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (954,1,4,20,30,'2007-08-12');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (955,50,16,19,8,'2007-08-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (956,1,14,21,25,'2007-08-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (957,1,14,34,25,'2007-08-13');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (958,1,15,24,28,'2007-08-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (959,1,15,30,28,'2007-08-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (960,1,15,37,28,'2007-08-14');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (961,4,22,19,30,'2007-08-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (962,1,12,39,11,'2007-08-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (963,1,12,40,11,'2007-08-15');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (964,1,7,43,6,'2007-08-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (965,1,7,11,6,'2007-08-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (966,1,7,13,6,'2007-08-16');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (967,1,29,21,30,'2007-08-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (968,80,6,21,7,'2007-08-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (969,80,6,25,7,'2007-08-17');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (970,20,10,36,8,'2007-08-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (971,50,10,37,8,'2007-08-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (972,30,10,39,8,'2007-08-18');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (973,50,17,20,5,'2007-08-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (974,1,8,20,30,'2007-08-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (975,1,8,25,30,'2007-08-19');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (976,1,25,30,16,'2007-08-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (977,1,25,33,16,'2007-08-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (978,1,4,37,19,'2007-08-21');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (979,30,9,6,5,'2007-08-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (980,30,9,9,5,'2007-08-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (981,30,9,10,5,'2007-08-22');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (982,1,5,2,30,'2007-08-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (983,1,5,10,30,'2007-08-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (984,1,5,11,30,'2007-08-23');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (985,2,8,47,25,'2007-08-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (986,1,8,48,25,'2007-08-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (987,1,8,39,25,'2007-08-24');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (988,3,1,10,4,'2007-08-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (989,3,1,13,4,'2007-08-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (990,3,1,20,4,'2007-08-25');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (991,40,30,22,12,'2007-08-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (992,20,30,23,12,'2007-08-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (993,35,30,24,12,'2007-08-26');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (994,1,7,19,30,'2007-08-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (995,1,7,42,30,'2007-08-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (996,10,20,18,11,'2007-08-27');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (997,1,25,1,14,'2007-08-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (998,1,14,8,23,'2007-08-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (999,1,12,21,14,'2007-08-28');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (1000,8,12,20,25,'2007-08-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (1001,1,12,24,25,'2007-08-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (1002,1,12,10,25,'2007-08-29');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (1003,3,3,6,30,'2007-08-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (1004,1,3,9,30,'2007-08-31');
INSERT INTO Sales(SaleID,Quantity,CustomerID,ProductID,EmployeeID,SaleDate) VALUES (1005,1,3,31,30,'2007-08-31');