Guest User

Untitled

a guest
Dec 23rd, 2020
471
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE Customer (
  2. Id INTEGER PRIMARY KEY NOT NULL,
  3. FirstName VARCHAR(40),
  4. LastName VARCHAR(40) ,
  5. City VARCHAR(40) ,
  6. Country VARCHAR(40) ,
  7. Phone VARCHAR(20) );
  8.  
  9. Create TABLE Orders (
  10. Id INTEGER PRIMARY KEY NOT NULL,
  11. OrderDate DATE,
  12. OrderNumber VARCHAR(10),
  13. CustomerID INTEGER REFERENCES Customer(Id),
  14. TotalAmount DECIMAL(12,2));
  15.  
  16. CREATE TABLE Supplier (
  17. Id INTEGER PRIMARY KEY NOT NULL,
  18. CompanyName VARCHAR(40),
  19. ContactName VARCHAR(40) ,
  20. ContactTitle VARCHAR(40) ,
  21. City VARCHAR(40) ,
  22. Country VARCHAR(40) ,
  23. Phone VARCHAR(30),
  24. Fax VARCHAR(30) );
  25.  
  26. CREATE TABLE Product (
  27. Id INTEGER PRIMARY KEY NOT NULL,
  28. ProductName VARCHAR(40),
  29. SupplierID INTEGER REFERENCES Supplier(Id),
  30. UnitPrice DECIMAL (12,2),
  31. Package VARCHAR(40) );
  32.  
  33. CREATE TABLE OrderItem(
  34. Id INTEGER PRIMARY KEY NOT NULL,
  35. OrderID INTEGER REFERENCES Orders(Id),
  36. ProductID INTEGER REFERENCES Product(Id),
  37. Quantity INTEGER);
  38.  
  39.  
  40.  
  41. INSERT INTO Customer VALUES(1,'Maria','Anders','Berlin','Germany','030-0074321');
  42. INSERT INTO Customer VALUES(2,'Ana','Trujillo','M�xico D.F.','Mexico','(5) 555-4729');
  43. INSERT INTO Customer VALUES(3,'Antonio','Moreno','M�xico D.F.','Mexico','(5) 555-3932');
  44. INSERT INTO Customer VALUES(4,'Thomas','Hardy','London','UK','(171) 555-7788');
  45. INSERT INTO Customer VALUES(5,'Christina','Berglund','Lule�','Sweden','0921-12 34 65');
  46. INSERT INTO Customer VALUES(6,'Hanna','Moos','Mannheim','Germany','0621-08460');
  47. INSERT INTO Customer VALUES(7,'Fr�d�rique','Citeaux','Strasbourg','France','88.60.15.31');
  48. INSERT INTO Customer VALUES(8,'Mart�n','Sommer','Madrid','Spain','(91) 555 22 82');
  49. INSERT INTO Customer VALUES(9,'Laurence','Lebihan','Marseille','France','91.24.45.40');
  50. INSERT INTO Customer VALUES(10,'Elizabeth','Lincoln','Tsawassen','Canada','(604) 555-4729');
  51. INSERT INTO Customer VALUES(11,'Victoria','Ashworth','London','UK','(171) 555-1212');
  52. INSERT INTO Customer VALUES(12,'Patricio','Simpson','Buenos Aires','Argentina','(1) 135-5555');
  53. INSERT INTO Customer VALUES(13,'Francisco','Chang','M�xico D.F.','Mexico','(5) 555-3392');
  54. INSERT INTO Customer VALUES(14,'Yang','Wang','Bern','Switzerland','0452-076545');
  55. INSERT INTO Customer VALUES(15,'Pedro','Afonso','Sao Paulo','Brazil','(11) 555-7647');
  56. INSERT INTO Customer VALUES(16,'Elizabeth','Brown','London','UK','(171) 555-2282');
  57. INSERT INTO Customer VALUES(17,'Sven','Ottlieb','Aachen','Germany','0241-039123');
  58. INSERT INTO Customer VALUES(18,'Janine','Labrune','Nantes','France','40.67.88.88');
  59. INSERT INTO Customer VALUES(19,'Ann','Devon','London','UK','(171) 555-0297');
  60. INSERT INTO Customer VALUES(20,'Roland','Mendel','Graz','Austria','7675-3425');
  61. INSERT INTO Customer VALUES(21,'Aria','Cruz','Sao Paulo','Brazil','(11) 555-9857');
  62. INSERT INTO Customer VALUES(22,'Diego','Roel','Madrid','Spain','(91) 555 94 44');
  63. INSERT INTO Customer VALUES(23,'Martine','Ranc�','Lille','France','20.16.10.16');
  64. INSERT INTO Customer VALUES(24,'Maria','Larsson','Br�cke','Sweden','0695-34 67 21');
  65. INSERT INTO Customer VALUES(25,'Peter','Franken','M�nchen','Germany','089-0877310');
  66. INSERT INTO Customer VALUES(26,'Carine','Schmitt','Nantes','France','40.32.21.21');
  67. INSERT INTO Customer VALUES(27,'Paolo','Accorti','Torino','Italy','011-4988260');
  68. INSERT INTO Customer VALUES(28,'Lino','Rodriguez','Lisboa','Portugal','(1) 354-2534');
  69. INSERT INTO Customer VALUES(29,'Eduardo','Saavedra','Barcelona','Spain','(93) 203 4560');
  70. INSERT INTO Customer VALUES(30,'Jos�','Pedro Freyre','Sevilla','Spain','(95) 555 82 82');
  71. INSERT INTO Customer VALUES(31,'Andr�','Fonseca','Campinas','Brazil','(11) 555-9482');
  72. INSERT INTO Customer VALUES(32,'Howard','Snyder','Eugene','USA','(503) 555-7555');
  73. INSERT INTO Customer VALUES(33,'Manuel','Pereira','Caracas','Venezuela','(2) 283-2951');
  74. INSERT INTO Customer VALUES(34,'Mario','Pontes','Rio de Janeiro','Brazil','(21) 555-0091');
  75. INSERT INTO Customer VALUES(35,'Carlos','Hern�ndez','San Crist�bal','Venezuela','(5) 555-1340');
  76. INSERT INTO Customer VALUES(36,'Yoshi','Latimer','Elgin','USA','(503) 555-6874');
  77. INSERT INTO Customer VALUES(37,'Patricia','McKenna','Cork','Ireland','2967 542');
  78. INSERT INTO Customer VALUES(38,'Helen','Bennett','Cowes','UK','(198) 555-8888');
  79. INSERT INTO Customer VALUES(39,'Philip','Cramer','Brandenburg','Germany','0555-09876');
  80. INSERT INTO Customer VALUES(40,'Daniel','Tonini','Versailles','France','30.59.84.10');
  81. INSERT INTO Customer VALUES(41,'Annette','Roulet','Toulouse','France','61.77.61.10');
  82. INSERT INTO Customer VALUES(42,'Yoshi','Tannamuri','Vancouver','Canada','(604) 555-3392');
  83. INSERT INTO Customer VALUES(43,'John','Steel','Walla Walla','USA','(509) 555-7969');
  84. INSERT INTO Customer VALUES(44,'Renate','Messner','Frankfurt a.M.','Germany','069-0245984');
  85. INSERT INTO Customer VALUES(45,'Jaime','Yorres','San Francisco','USA','(415) 555-5938');
  86. INSERT INTO Customer VALUES(46,'Carlos','Gonz�lez','Barquisimeto','Venezuela','(9) 331-6954');
  87. INSERT INTO Customer VALUES(47,'Felipe','Izquierdo','I. de Margarita','Venezuela','(8) 34-56-12');
  88. INSERT INTO Customer VALUES(48,'Fran','Wilson','Portland','USA','(503) 555-9573');
  89. INSERT INTO Customer VALUES(49,'Giovanni','Rovelli','Bergamo','Italy','035-640230');
  90. INSERT INTO Customer VALUES(50,'Catherine','Dewey','Bruxelles','Belgium','(02) 201 24 67');
  91. INSERT INTO Customer VALUES(51,'Jean','Fresni�re','Montr�al','Canada','(514) 555-8054');
  92. INSERT INTO Customer VALUES(52,'Alexander','Feuer','Leipzig','Germany','0342-023176');
  93. INSERT INTO Customer VALUES(53,'Simon','Crowther','London','UK','(171) 555-7733');
  94. INSERT INTO Customer VALUES(54,'Yvonne','Moncada','Buenos Aires','Argentina','(1) 135-5333');
  95. INSERT INTO Customer VALUES(55,'Rene','Phillips','Anchorage','USA','(907) 555-7584');
  96. INSERT INTO Customer VALUES(56,'Henriette','Pfalzheim','K�ln','Germany','0221-0644327');
  97. INSERT INTO Customer VALUES(57,'Marie','Bertrand','Paris','France','(1) 42.34.22.66');
  98. INSERT INTO Customer VALUES(58,'Guillermo','Fern�ndez','M�xico D.F.','Mexico','(5) 552-3745');
  99. INSERT INTO Customer VALUES(59,'Georg','Pipps','Salzburg','Austria','6562-9722');
  100. INSERT INTO Customer VALUES(60,'Isabel','de Castro','Lisboa','Portugal','(1) 356-5634');
  101. INSERT INTO Customer VALUES(61,'Bernardo','Batista','Rio de Janeiro','Brazil','(21) 555-4252');
  102. INSERT INTO Customer VALUES(62,'L�cia','Carvalho','Sao Paulo','Brazil','(11) 555-1189');
  103. INSERT INTO Customer VALUES(63,'Horst','Kloss','Cunewalde','Germany','0372-035188');
  104. INSERT INTO Customer VALUES(64,'Sergio','Guti�rrez','Buenos Aires','Argentina','(1) 123-5555');
  105. INSERT INTO Customer VALUES(65,'Paula','Wilson','Albuquerque','USA','(505) 555-5939');
  106. INSERT INTO Customer VALUES(66,'Maurizio','Moroni','Reggio Emilia','Italy','0522-556721');
  107. INSERT INTO Customer VALUES(67,'Janete','Limeira','Rio de Janeiro','Brazil','(21) 555-3412');
  108. INSERT INTO Customer VALUES(68,'Michael','Holz','Gen�ve','Switzerland','0897-034214');
  109. INSERT INTO Customer VALUES(69,'Alejandra','Camino','Madrid','Spain','(91) 745 6200');
  110. INSERT INTO Customer VALUES(70,'Jonas','Bergulfsen','Stavern','Norway','07-98 92 35');
  111. INSERT INTO Customer VALUES(71,'Jose','Pavarotti','Boise','USA','(208) 555-8097');
  112. INSERT INTO Customer VALUES(72,'Hari','Kumar','London','UK','(171) 555-1717');
  113. INSERT INTO Customer VALUES(73,'Jytte','Petersen','Kobenhavn','Denmark','31 12 34 56');
  114. INSERT INTO Customer VALUES(74,'Dominique','Perrier','Paris','France','(1) 47.55.60.10');
  115. INSERT INTO Customer VALUES(75,'Art','Braunschweiger','Lander','USA','(307) 555-4680');
  116. INSERT INTO Customer VALUES(76,'Pascale','Cartrain','Charleroi','Belgium','(071) 23 67 22 20');
  117. INSERT INTO Customer VALUES(77,'Liz','Nixon','Portland','USA','(503) 555-3612');
  118. INSERT INTO Customer VALUES(78,'Liu','Wong','Butte','USA','(406) 555-5834');
  119. INSERT INTO Customer VALUES(79,'Karin','Josephs','M�nster','Germany','0251-031259');
  120. INSERT INTO Customer VALUES(80,'Miguel','Angel Paolino','M�xico D.F.','Mexico','(5) 555-2933');
  121. INSERT INTO Customer VALUES(81,'Anabela','Domingues','Sao Paulo','Brazil','(11) 555-2167');
  122. INSERT INTO Customer VALUES(82,'Helvetius','Nagy','Kirkland','USA','(206) 555-8257');
  123. INSERT INTO Customer VALUES(83,'Palle','Ibsen','�rhus','Denmark','86 21 32 43');
  124. INSERT INTO Customer VALUES(84,'Mary','Saveley','Lyon','France','78.32.54.86');
  125. INSERT INTO Customer VALUES(85,'Paul','Henriot','Reims','France','26.47.15.10');
  126. INSERT INTO Customer VALUES(86,'Rita','M�ller','Stuttgart','Germany','0711-020361');
  127. INSERT INTO Customer VALUES(87,'Pirkko','Koskitalo','Oulu','Finland','981-443655');
  128. INSERT INTO Customer VALUES(88,'Paula','Parente','Resende','Brazil','(14) 555-8122');
  129. INSERT INTO Customer VALUES(89,'Karl','Jablonski','Seattle','USA','(206) 555-4112');
  130. INSERT INTO Customer VALUES(90,'Matti','Karttunen','Helsinki','Finland','90-224 8858');
  131. INSERT INTO Customer VALUES(91,'Zbyszek','Piestrzeniewicz','Warszawa','Poland','(26) 642-7012');
  132.  
  133.  
  134.  
  135.  
  136. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(1,'Exotic Liquids','Charlotte Cooper','London','UK','(171) 555-2222',NULL);
  137. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(2,'New Orleans Cajun Delights','Shelley Burke','New Orleans','USA','(100) 555-4822',NULL);
  138. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(3,'Grandma Kelly''s Homestead','Regina Murphy','Ann Arbor','USA','(313) 555-5735','(313) 555-3349');
  139. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(4,'Tokyo Traders','Yoshi Nagase','Tokyo','Japan','(03) 3555-5011',NULL);
  140. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(5,'Cooperativa de Quesos ''Las Cabras''','Antonio del Valle Saavedra','Oviedo','Spain','(98) 598 76 54',NULL);
  141. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(6,'Mayumi''s','Mayumi Ohno','Osaka','Japan','(06) 431-7877',NULL);
  142. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(7,'Pavlova, Ltd.','Ian Devling','Melbourne','Australia','(03) 444-2343','(03) 444-6588');
  143. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(8,'Specialty Biscuits, Ltd.','Peter Wilson','Manchester','UK','(161) 555-4448',NULL);
  144. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(9,'PB Kn�ckebr�d AB','Lars Peterson','G�teborg','Sweden','031-987 65 43','031-987 65 91');
  145. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(10,'Refrescos Americanas LTDA','Carlos Diaz','Sao Paulo','Brazil','(11) 555 4640',NULL);
  146. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(11,'Heli S��waren GmbH & Co. KG','Petra Winkler','Berlin','Germany','(010) 9984510',NULL);
  147. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(12,'Plutzer Lebensmittelgro�m�rkte AG','Martin Bein','Frankfurt','Germany','(069) 992755',NULL);
  148. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(13,'Nord-Ost-Fisch Handelsgesellschaft mbH','Sven Petersen','Cuxhaven','Germany','(04721) 8713','(04721) 8714');
  149. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(14,'Formaggi Fortini s.r.l.','Elio Rossi','Ravenna','Italy','(0544) 60323','(0544) 60603');
  150. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(15,'Norske Meierier','Beate Vileid','Sandvika','Norway','(0)2-953010',NULL);
  151. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(16,'Bigfoot Breweries','Cheryl Saylor','Bend','USA','(503) 555-9931',NULL);
  152. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(17,'Svensk Sj�f�da AB','Michael Bj�rn','Stockholm','Sweden','08-123 45 67',NULL);
  153. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(18,'Aux joyeux eccl�siastiques','Guyl�ne Nodier','Paris','France','(1) 03.83.00.68','(1) 03.83.00.62');
  154. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(19,'New England Seafood Cannery','Robb Merchant','Boston','USA','(617) 555-3267','(617) 555-3389');
  155. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(20,'Leka Trading','Chandra Leka','Singapore','Singapore','555-8787',NULL);
  156. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(21,'Lyngbysild','Niels Petersen','Lyngby','Denmark','43844108','43844115');
  157. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(22,'Zaanse Snoepfabriek','Dirk Luchte','Zaandam','Netherlands','(12345) 1212','(12345) 1210');
  158. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(23,'Karkki Oy','Anne Heikkonen','Lappeenranta','Finland','(953) 10956',NULL);
  159. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(24,'G''day, Mate','Wendy Mackenzie','Sydney','Australia','(02) 555-5914','(02) 555-4873');
  160. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(25,'Ma Maison','Jean-Guy Lauzon','Montr�al','Canada','(514) 555-9022',NULL);
  161. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(26,'Pasta Buttini s.r.l.','Giovanni Giudici','Salerno','Italy','(089) 6547665','(089) 6547667');
  162. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(27,'Escargots Nouveaux','Marie Delamare','Montceau','France','85.57.00.07',NULL);
  163. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(28,'Gai p�turage','Eliane Noz','Annecy','France','38.76.98.06','38.76.98.58');
  164. INSERT INTO Supplier (Id,CompanyName,ContactName,City,Country,Phone,Fax)VALUES(29,'For�ts d''�rables','Chantal Goulet','Ste-Hyacinthe','Canada','(514) 555-2955','(514) 555-2921');
  165.  
  166.  
  167.  
  168.  
  169. INSERT INTO Product VALUES(1,'Chai',1,18.00,'10 boxes x 20 bags');
  170. INSERT INTO Product VALUES(2,'Chang',1,19.00,'24 - 12 oz bottles' );
  171. INSERT INTO Product VALUES(3,'Aniseed Syrup',1,10.00,'12 - 550 ml bottles' );
  172. INSERT INTO Product VALUES(4,'Chef Anton''s Cajun Seasoning',2,22.00,'48 - 6 oz jars' );
  173. INSERT INTO Product VALUES(5,'Chef Anton''s Gumbo Mix',2,21.35,'36 boxes');
  174. INSERT INTO Product VALUES(6,'Grandma''s Boysenberry Spread',3,25.00,'12 - 8 oz jars' );
  175. INSERT INTO Product VALUES(7,'Uncle Bob''s Organic Dried Pears',3,30.00,'12 - 1 lb pkgs.' );
  176. INSERT INTO Product VALUES(8,'Northwoods Cranberry Sauce',3,40.00,'12 - 12 oz jars' );
  177. INSERT INTO Product VALUES(9,'Mishi Kobe Niku',4,97.00,'18 - 500 g pkgs.');
  178. INSERT INTO Product VALUES(10,'Ikura',4,31.00,'12 - 200 ml jars' );
  179. INSERT INTO Product VALUES(11,'Queso Cabrales',5,21.00,'1 kg pkg.' );
  180. INSERT INTO Product VALUES(12,'Queso Manchego La Pastora',5,38.00,'10 - 500 g pkgs.' );
  181. INSERT INTO Product VALUES(13,'Konbu',6,6.00,'2 kg box' );
  182. INSERT INTO Product VALUES(14,'Tofu',6,23.25,'40 - 100 g pkgs.' );
  183. INSERT INTO Product VALUES(15,'Genen Shouyu',6,15.50,'24 - 250 ml bottles' );
  184. INSERT INTO Product VALUES(16,'Pavlova',7,17.45,'32 - 500 g boxes' );
  185. INSERT INTO Product VALUES(17,'Alice Mutton',7,39.00,'20 - 1 kg tins');
  186. INSERT INTO Product VALUES(18,'Carnarvon Tigers',7,62.50,'16 kg pkg.' );
  187. INSERT INTO Product VALUES(19,'Teatime Chocolate Biscuits',8,9.20,'10 boxes x 12 pieces' );
  188. INSERT INTO Product VALUES(20,'Sir Rodney''s Marmalade',8,81.00,'30 gift boxes' );
  189. INSERT INTO Product VALUES(21,'Sir Rodney''s Scones',8,10.00,'24 pkgs. x 4 pieces' );
  190. INSERT INTO Product VALUES(22,'Gustaf''s Kn�ckebr�d',9,21.00,'24 - 500 g pkgs.' );
  191. INSERT INTO Product VALUES(23,'Tunnbr�d',9,9.00,'12 - 250 g pkgs.' );
  192. INSERT INTO Product VALUES(24,'Guaran� Fant�stica',10,4.50,'12 - 355 ml cans');
  193. INSERT INTO Product VALUES(25,'NuNuCa Nu�-Nougat-Creme',11,14.00,'20 - 450 g glasses' );
  194. INSERT INTO Product VALUES(26,'Gumb�r Gummib�rchen',11,31.23,'100 - 250 g bags' );
  195. INSERT INTO Product VALUES(27,'Schoggi Schokolade',11,43.90,'100 - 100 g pieces' );
  196. INSERT INTO Product VALUES(28,'R�ssle Sauerkraut',12,45.60,'25 - 825 g cans');
  197. INSERT INTO Product VALUES(29,'Th�ringer Rostbratwurst',12,123.79,'50 bags x 30 sausgs.');
  198. INSERT INTO Product VALUES(30,'Nord-Ost Matjeshering',13,25.89,'10 - 200 g glasses' );
  199. INSERT INTO Product VALUES(31,'Gorgonzola Telino',14,12.50,'12 - 100 g pkgs' );
  200. INSERT INTO Product VALUES(32,'Mascarpone Fabioli',14,32.00,'24 - 200 g pkgs.' );
  201. INSERT INTO Product VALUES(33,'Geitost',15,2.50,'500 g' );
  202. INSERT INTO Product VALUES(34,'Sasquatch Ale',16,14.00,'24 - 12 oz bottles' );
  203. INSERT INTO Product VALUES(35,'Steeleye Stout',16,18.00,'24 - 12 oz bottles' );
  204. INSERT INTO Product VALUES(36,'Inlagd Sill',17,19.00,'24 - 250 g jars' );
  205. INSERT INTO Product VALUES(37,'Gravad lax',17,26.00,'12 - 500 g pkgs.' );
  206. INSERT INTO Product VALUES(38,'C�te de Blaye',18,263.50,'12 - 75 cl bottles' );
  207. INSERT INTO Product VALUES(39,'Chartreuse verte',18,18.00,'750 cc per bottle' );
  208. INSERT INTO Product VALUES(40,'Boston Crab Meat',19,18.40,'24 - 4 oz tins' );
  209. INSERT INTO Product VALUES(41,'Jack''s New England Clam Chowder',19,9.65,'12 - 12 oz cans' );
  210. INSERT INTO Product VALUES(42,'Singaporean Hokkien Fried Mee',20,14.00,'32 - 1 kg pkgs.');
  211. INSERT INTO Product VALUES(43,'Ipoh Coffee',20,46.00,'16 - 500 g tins' );
  212. INSERT INTO Product VALUES(44,'Gula Malacca',20,19.45,'20 - 2 kg bags' );
  213. INSERT INTO Product VALUES(45,'Rogede sild',21,9.50,'1k pkg.' );
  214. INSERT INTO Product VALUES(46,'Spegesild',21,12.00,'4 - 450 g glasses' );
  215. INSERT INTO Product VALUES(47,'Zaanse koeken',22,9.50,'10 - 4 oz boxes' );
  216. INSERT INTO Product VALUES(48,'Chocolade',22,12.75,'10 pkgs.' );
  217. INSERT INTO Product VALUES(49,'Maxilaku',23,20.00,'24 - 50 g pkgs.' );
  218. INSERT INTO Product VALUES(50,'Valkoinen suklaa',23,16.25,'12 - 100 g bars' );
  219. INSERT INTO Product VALUES(51,'Manjimup Dried Apples',24,53.00,'50 - 300 g pkgs.' );
  220. INSERT INTO Product VALUES(52,'Filo Mix',24,7.00,'16 - 2 kg boxes' );
  221. INSERT INTO Product VALUES(53,'Perth Pasties',24,32.80,'48 pieces');
  222. INSERT INTO Product VALUES(54,'Tourti�re',25,7.45,'16 pies' );
  223. INSERT INTO Product VALUES(55,'P�t� chinois',25,24.00,'24 boxes x 2 pies' );
  224. INSERT INTO Product VALUES(56,'Gnocchi di nonna Alice',26,38.00,'24 - 250 g pkgs.' );
  225. INSERT INTO Product VALUES(57,'Ravioli Angelo',26,19.50,'24 - 250 g pkgs.' );
  226. INSERT INTO Product VALUES(58,'Escargots de Bourgogne',27,13.25,'24 pieces' );
  227. INSERT INTO Product VALUES(59,'Raclette Courdavault',28,55.00,'5 kg pkg.' );
  228. INSERT INTO Product VALUES(60,'Camembert Pierrot',28,34.00,'15 - 300 g rounds' );
  229. INSERT INTO Product VALUES(61,'Sirop d''�rable',29,28.50,'24 - 500 ml bottles' );
  230. INSERT INTO Product VALUES(62,'Tarte au sucre',29,49.30,'48 pies' );
  231. INSERT INTO Product VALUES(63,'Vegie-spread',7,43.90,'15 - 625 g jars' );
  232. INSERT INTO Product VALUES(64,'Wimmers gute Semmelkn�del',12,33.25,'20 bags x 4 pieces' );
  233. INSERT INTO Product VALUES(65,'Louisiana Fiery Hot Pepper Sauce',2,21.05,'32 - 8 oz bottles' );
  234. INSERT INTO Product VALUES(66,'Louisiana Hot Spiced Okra',2,17.00,'24 - 8 oz jars' );
  235. INSERT INTO Product VALUES(67,'Laughing Lumberjack Lager',16,14.00,'24 - 12 oz bottles' );
  236. INSERT INTO Product VALUES(68,'Scottish Longbreads',8,12.50,'10 boxes x 8 pieces' );
  237. INSERT INTO Product VALUES(69,'Gudbrandsdalsost',15,36.00,'10 kg pkg.' );
  238. INSERT INTO Product VALUES(70,'Outback Lager',7,15.00,'24 - 355 ml bottles' );
  239. INSERT INTO Product VALUES(71,'Flotemysost',15,21.50,'10 - 500 g pkgs.' );
  240. INSERT INTO Product VALUES(72,'Mozzarella di Giovanni',14,34.80,'24 - 200 g pkgs.' );
  241. INSERT INTO Product VALUES(73,'R�d Kaviar',17,15.00,'24 - 150 g jars' );
  242. INSERT INTO Product VALUES(74,'Longlife Tofu',4,10.00,'5 kg pkg.' );
  243. INSERT INTO Product VALUES(75,'Rh�nbr�u Klosterbier',12,7.75,'24 - 0.5 l bottles' );
  244. INSERT INTO Product VALUES(76,'Lakkalik��ri',23,18.00,'500 ml' );
  245. INSERT INTO Product VALUES(77,'Original Frankfurter gr�ne So�e',12,13.00,'12 boxes' );
  246. INSERT INTO Product VALUES(78,'Stroopwafels',22,9.75,'24 pieces' );
  247.  
  248.  
  249.  
  250.  
  251. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(1,'Jul 4 2012 ',85,440.00,'542378');
  252. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(2,'Jul 5 2012 ',79,1863.40,'542379');
  253. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(3,'Jul 8 2012 ',34,1813.00,'542380');
  254. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(4,'Jul 8 2012 ',84,670.80,'542381');
  255. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(5,'Jul 9 2012 ',76,3730.00,'542382');
  256. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(6,'Jul 10 2012 ',34,1444.80,'542383');
  257. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(7,'Jul 11 2012 ',14,625.20,'542384');
  258. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(8,'Jul 12 2012 ',68,2490.50,'542385');
  259. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(9,'Jul 15 2012 ',88,517.80,'542386');
  260. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(10,'Jul 16 2012 ',35,1119.90,'542387');
  261. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(11,'Jul 17 2012 ',20,2018.60,'542388');
  262. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(12,'Jul 18 2012 ',13,100.80,'542389');
  263. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(13,'Jul 19 2012 ',56,1746.20,'542390');
  264. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(14,'Jul 19 2012 ',61,448.00,'542391');
  265. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(15,'Jul 22 2012 ',65,624.80,'542392');
  266. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(16,'Jul 23 2012 ',20,2464.80,'542393');
  267. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(17,'Jul 24 2012 ',24,724.50,'542394');
  268. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(19,'Jul 26 2012 ',87,364.80,'542396');
  269. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(20,'Jul 29 2012 ',25,4031.00,'542397');
  270. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(21,'Jul 30 2012 ',33,1101.20,'542398');
  271. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(22,'Jul 31 2012 ',89,676.00,'542399');
  272. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(23,'Aug 1 2012 ',87,1376.00,'542400');
  273. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(24,'Aug 1 2012 ',75,48.00,'542401');
  274. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(25,'Aug 2 2012 ',65,1456.00,'542402');
  275. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(26,'Aug 5 2012 ',63,2142.40,'542403');
  276. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(27,'Aug 6 2012 ',85,538.60,'542404');
  277. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(28,'Aug 7 2012 ',49,307.20,'542405');
  278. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(29,'Aug 8 2012 ',80,420.00,'542406');
  279. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(30,'Aug 9 2012 ',52,1200.80,'542407');
  280. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(31,'Aug 12 2012 ',5,1488.80,'542408');
  281. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(32,'Aug 13 2012 ',44,468.00,'542409');
  282. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(33,'Aug 14 2012 ',5,613.20,'542410');
  283. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(34,'Aug 14 2012 ',69,86.50,'542411');
  284. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(35,'Aug 15 2012 ',69,155.40,'542412');
  285. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(36,'Aug 16 2012 ',46,1414.80,'542413');
  286. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(37,'Aug 19 2012 ',44,1452.00,'542414');
  287. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(38,'Aug 20 2012 ',63,2179.20,'542415');
  288. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(39,'Aug 21 2012 ',63,3016.00,'542416');
  289. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(40,'Aug 22 2012 ',67,924.00,'542417');
  290. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(41,'Aug 23 2012 ',66,89.00,'542418');
  291. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(42,'Aug 26 2012 ',11,479.40,'542419');
  292. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(43,'Aug 27 2012 ',15,2169.00,'542420');
  293. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(44,'Aug 27 2012 ',61,552.80,'542421');
  294. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(45,'Aug 28 2012 ',81,1296.00,'542422');
  295. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(46,'Aug 29 2012 ',80,848.70,'542423');
  296. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(47,'Aug 30 2012 ',65,1887.60,'542424');
  297. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(48,'Sep 2 2012 ',85,121.60,'542425');
  298. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(49,'Sep 3 2012 ',46,1050.60,'542426');
  299. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(51,'Sep 5 2012 ',37,3127.00,'542428');
  300. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(52,'Sep 6 2012 ',67,349.50,'542429');
  301. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(53,'Sep 9 2012 ',49,608.00,'542430');
  302. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(54,'Sep 9 2012 ',86,755.00,'542431');
  303. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(55,'Sep 10 2012 ',76,2708.80,'542432');
  304. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(56,'Sep 11 2012 ',30,1242.00,'542433');
  305. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(57,'Sep 12 2012 ',80,954.40,'542434');
  306. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(58,'Sep 13 2012 ',55,4157.00,'542435');
  307. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(59,'Sep 16 2012 ',69,498.50,'542436');
  308. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(60,'Sep 17 2012 ',48,424.00,'542437');
  309. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(61,'Sep 18 2012 ',2,88.80,'542438');
  310. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(62,'Sep 19 2012 ',37,1762.00,'542439');
  311. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(63,'Sep 20 2012 ',77,336.00,'542440');
  312. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(64,'Sep 20 2012 ',18,268.80,'542441');
  313. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(65,'Sep 23 2012 ',86,1614.80,'542442');
  314. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(66,'Sep 24 2012 ',63,182.40,'542443');
  315. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(67,'Sep 25 2012 ',65,2327.00,'542444');
  316. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(68,'Sep 26 2012 ',38,516.80,'542445');
  317. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(69,'Sep 27 2012 ',65,2835.00,'542446');
  318. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(70,'Sep 30 2012 ',48,288.00,'542447');
  319. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(71,'Oct 1 2012 ',38,240.40,'542448');
  320. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(72,'Oct 2 2012 ',80,1191.20,'542449');
  321. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(73,'Oct 3 2012 ',87,516.00,'542450');
  322. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(74,'Oct 3 2012 ',38,144.00,'542451');
  323. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(75,'Oct 4 2012 ',58,112.00,'542452');
  324. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(76,'Oct 7 2012 ',39,164.40,'542453');
  325. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(77,'Oct 8 2012 ',71,6155.90,'542454');
  326. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(78,'Oct 9 2012 ',39,1497.00,'542455');
  327. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(79,'Oct 10 2012 ',8,982.00,'542456');
  328. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(80,'Oct 11 2012 ',24,2262.50,'542457');
  329. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(81,'Oct 14 2012 ',28,1168.00,'542458');
  330. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(82,'Oct 15 2012 ',75,4819.40,'542459');
  331. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(83,'Oct 16 2012 ',46,1940.00,'542460');
  332. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(84,'Oct 16 2012 ',9,88.50,'542461');
  333. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(85,'Oct 17 2012 ',51,2233.60,'542462');
  334. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(86,'Oct 18 2012 ',87,954.00,'542463');
  335. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(87,'Oct 21 2012 ',84,144.80,'542464');
  336. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(88,'Oct 22 2012 ',37,2545.20,'542465');
  337. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(89,'Oct 23 2012 ',60,316.80,'542466');
  338. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(90,'Oct 24 2012 ',25,2467.00,'542467');
  339. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(91,'Oct 25 2012 ',55,934.50,'542468');
  340. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(92,'Oct 28 2012 ',51,3463.20,'542469');
  341. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(93,'Oct 29 2012 ',9,2564.40,'542470');
  342. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(94,'Oct 29 2012 ',73,412.00,'542471');
  343. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(95,'Oct 30 2012 ',25,2300.80,'542472');
  344. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(96,'Oct 31 2012 ',44,1586.00,'542473');
  345. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(97,'Nov 1 2012 ',89,2856.00,'542474');
  346. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(98,'Nov 4 2012 ',63,2924.80,'542475');
  347. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(99,'Nov 5 2012 ',65,1731.20,'542476');
  348. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(100,'Nov 6 2012 ',21,928.00,'542477');
  349. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(101,'Nov 7 2012 ',86,396.00,'542478');
  350. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(102,'Nov 8 2012 ',75,141.60,'542479');
  351. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(103,'Nov 11 2012 ',41,713.40,'542480');
  352. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(104,'Nov 11 2012 ',20,5677.60,'542481');
  353. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(105,'Nov 12 2012 ',28,154.00,'542482');
  354. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(106,'Nov 13 2012 ',59,10741.60,'542483');
  355. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(107,'Nov 14 2012 ',58,568.80,'542484');
  356. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(108,'Nov 15 2012 ',4,480.00,'542485');
  357. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(109,'Nov 18 2012 ',86,1106.40,'542486');
  358. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(110,'Nov 19 2012 ',46,1360.00,'542487');
  359. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(111,'Nov 20 2012 ',41,452.00,'542488');
  360. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(112,'Nov 21 2012 ',72,3654.40,'542489');
  361. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(113,'Nov 22 2012 ',7,7390.20,'542490');
  362. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(114,'Nov 22 2012 ',63,2273.60,'542491');
  363. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(115,'Nov 25 2012 ',9,1549.60,'542492');
  364. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(116,'Nov 26 2012 ',17,447.20,'542493');
  365. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(117,'Nov 26 2012 ',19,950.00,'542494');
  366. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(118,'Nov 27 2012 ',3,403.20,'542495');
  367. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(119,'Nov 28 2012 ',29,136.00,'542496');
  368. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(120,'Nov 28 2012 ',83,834.20,'542497');
  369. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(121,'Nov 29 2012 ',20,1834.20,'542498');
  370. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(122,'Dec 2 2012 ',75,2527.20,'542499');
  371. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(123,'Dec 3 2012 ',14,1174.00,'542500');
  372. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(124,'Dec 3 2012 ',41,91.20,'542501');
  373. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(125,'Dec 4 2012 ',62,12281.20,'542502');
  374. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(126,'Dec 5 2012 ',37,1708.00,'542503');
  375. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(127,'Dec 5 2012 ',91,459.00,'542504');
  376. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(128,'Dec 6 2012 ',36,338.00,'542505');
  377. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(129,'Dec 9 2012 ',51,420.00,'542506');
  378. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(130,'Dec 9 2012 ',72,1016.00,'542507');
  379. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(131,'Dec 10 2012 ',24,103.20,'542508');
  380. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(132,'Dec 11 2012 ',61,959.20,'542509');
  381. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(133,'Dec 12 2012 ',37,1419.80,'542510');
  382. INSERT INTO Orders (Id,OrderDate,CustomerId,TotalAmount,OrderNumber)VALUES(134,'Dec 12 2012 ',46,112.00,'542511');
  383.  
  384.  
  385.  
  386.  
  387. INSERT INTO OrderItem VALUES(1,1,3,12);
  388. INSERT INTO OrderItem VALUES(2,1,42,10);
  389. INSERT INTO OrderItem VALUES(3,1,72,5);
  390. INSERT INTO OrderItem VALUES(4,2,14,9);
  391. INSERT INTO OrderItem VALUES(5,2,51,40);
  392. INSERT INTO OrderItem VALUES(6,3,41,10);
  393. INSERT INTO OrderItem VALUES(7,3,4,35);
  394. INSERT INTO OrderItem VALUES(8,3,65,15);
  395. INSERT INTO OrderItem VALUES(9,4,22,6);
  396. INSERT INTO OrderItem VALUES(10,4,57,15);
  397. INSERT INTO OrderItem VALUES(11,4,65,20);
  398. INSERT INTO OrderItem VALUES(12,5,20,40);
  399. INSERT INTO OrderItem VALUES(13,5,33,25);
  400. INSERT INTO OrderItem VALUES(14,5,60,40);
  401. INSERT INTO OrderItem VALUES(15,6,31,20);
  402. INSERT INTO OrderItem VALUES(16,6,39,42);
  403. INSERT INTO OrderItem VALUES(17,6,49,40);
  404. INSERT INTO OrderItem VALUES(18,7,24,15);
  405. INSERT INTO OrderItem VALUES(19,7,55,21);
  406. INSERT INTO OrderItem VALUES(20,7,74,21);
  407. INSERT INTO OrderItem VALUES(21,8,2,20);
  408. INSERT INTO OrderItem VALUES(22,8,16,35);
  409. INSERT INTO OrderItem VALUES(23,8,36,25);
  410. INSERT INTO OrderItem VALUES(24,8,59,30);
  411. INSERT INTO OrderItem VALUES(25,9,53,15);
  412. INSERT INTO OrderItem VALUES(26,9,77,12);
  413. INSERT INTO OrderItem VALUES(27,10,27,25);
  414. INSERT INTO OrderItem VALUES(28,10,39,6);
  415. INSERT INTO OrderItem VALUES(29,10,77,15);
  416. INSERT INTO OrderItem VALUES(30,11,2,50);
  417. INSERT INTO OrderItem VALUES(31,11,5,65);
  418. INSERT INTO OrderItem VALUES(32,11,32,6);
  419. INSERT INTO OrderItem VALUES(33,12,21,10);
  420. INSERT INTO OrderItem VALUES(34,12,37,1);
  421. INSERT INTO OrderItem VALUES(35,13,41,16);
  422. INSERT INTO OrderItem VALUES(36,13,57,50);
  423. INSERT INTO OrderItem VALUES(37,13,62,15);
  424. INSERT INTO OrderItem VALUES(38,13,70,21);
  425. INSERT INTO OrderItem VALUES(39,14,21,20);
  426. INSERT INTO OrderItem VALUES(40,14,35,20);
  427. INSERT INTO OrderItem VALUES(41,15,5,12);
  428. INSERT INTO OrderItem VALUES(42,15,7,15);
  429. INSERT INTO OrderItem VALUES(43,15,56,2);
  430. INSERT INTO OrderItem VALUES(44,16,16,60);
  431. INSERT INTO OrderItem VALUES(45,16,24,28);
  432. INSERT INTO OrderItem VALUES(46,16,30,60);
  433. INSERT INTO OrderItem VALUES(47,16,74,36);
  434. INSERT INTO OrderItem VALUES(48,17,2,35);
  435. INSERT INTO OrderItem VALUES(49,17,41,25);
  436. INSERT INTO OrderItem VALUES(52,19,12,12);
  437. INSERT INTO OrderItem VALUES(53,20,40,50);
  438. INSERT INTO OrderItem VALUES(54,20,59,70);
  439. INSERT INTO OrderItem VALUES(55,20,76,15);
  440. INSERT INTO OrderItem VALUES(56,21,29,10);
  441. INSERT INTO OrderItem VALUES(57,21,72,4);
  442. INSERT INTO OrderItem VALUES(58,22,33,60);
  443. INSERT INTO OrderItem VALUES(59,22,72,20);
  444. INSERT INTO OrderItem VALUES(60,23,36,30);
  445. INSERT INTO OrderItem VALUES(61,23,43,25);
  446. INSERT INTO OrderItem VALUES(62,24,33,24);
  447. INSERT INTO OrderItem VALUES(63,25,20,6);
  448. INSERT INTO OrderItem VALUES(64,25,31,40);
  449. INSERT INTO OrderItem VALUES(65,25,72,24);
  450. INSERT INTO OrderItem VALUES(66,26,10,24);
  451. INSERT INTO OrderItem VALUES(67,26,31,15);
  452. INSERT INTO OrderItem VALUES(68,26,33,20);
  453. INSERT INTO OrderItem VALUES(69,26,40,60);
  454. INSERT INTO OrderItem VALUES(70,26,76,33);
  455. INSERT INTO OrderItem VALUES(71,27,71,20);
  456. INSERT INTO OrderItem VALUES(72,27,72,7);
  457. INSERT INTO OrderItem VALUES(73,28,24,12);
  458. INSERT INTO OrderItem VALUES(74,28,59,6);
  459. INSERT INTO OrderItem VALUES(75,29,10,15);
  460. INSERT INTO OrderItem VALUES(76,29,13,10);
  461. INSERT INTO OrderItem VALUES(77,30,28,20);
  462. INSERT INTO OrderItem VALUES(78,30,62,12);
  463. INSERT INTO OrderItem VALUES(79,31,44,16);
  464. INSERT INTO OrderItem VALUES(80,31,59,15);
  465. INSERT INTO OrderItem VALUES(81,31,63,8);
  466. INSERT INTO OrderItem VALUES(82,31,73,25);
  467. INSERT INTO OrderItem VALUES(83,32,17,15);
  468. INSERT INTO OrderItem VALUES(84,33,24,12);
  469. INSERT INTO OrderItem VALUES(85,33,55,20);
  470. INSERT INTO OrderItem VALUES(86,33,75,30);
  471. INSERT INTO OrderItem VALUES(87,34,19,1);
  472. INSERT INTO OrderItem VALUES(88,34,24,6);
  473. INSERT INTO OrderItem VALUES(89,34,35,4);
  474. INSERT INTO OrderItem VALUES(90,35,30,6);
  475. INSERT INTO OrderItem VALUES(91,35,57,2);
  476. INSERT INTO OrderItem VALUES(92,36,15,20);
  477. INSERT INTO OrderItem VALUES(93,36,19,18);
  478. INSERT INTO OrderItem VALUES(94,36,60,35);
  479. INSERT INTO OrderItem VALUES(95,36,72,3);
  480. INSERT INTO OrderItem VALUES(96,37,27,15);
  481. INSERT INTO OrderItem VALUES(97,37,44,21);
  482. INSERT INTO OrderItem VALUES(98,37,60,20);
  483. INSERT INTO OrderItem VALUES(99,37,67,5);
  484. INSERT INTO OrderItem VALUES(100,38,1,45);
  485. INSERT INTO OrderItem VALUES(101,38,40,40);
  486. INSERT INTO OrderItem VALUES(102,38,53,36);
  487. INSERT INTO OrderItem VALUES(103,39,35,100);
  488. INSERT INTO OrderItem VALUES(104,39,62,40);
  489. INSERT INTO OrderItem VALUES(105,40,16,40);
  490. INSERT INTO OrderItem VALUES(106,40,34,20);
  491. INSERT INTO OrderItem VALUES(107,40,46,15);
  492. INSERT INTO OrderItem VALUES(108,41,54,10);
  493. INSERT INTO OrderItem VALUES(109,41,68,3);
  494. INSERT INTO OrderItem VALUES(110,42,3,30);
  495. INSERT INTO OrderItem VALUES(111,42,64,9);
  496. INSERT INTO OrderItem VALUES(112,43,5,20);
  497. INSERT INTO OrderItem VALUES(113,43,29,15);
  498. INSERT INTO OrderItem VALUES(114,43,49,15);
  499. INSERT INTO OrderItem VALUES(115,43,77,10);
  500. INSERT INTO OrderItem VALUES(116,44,13,20);
  501. INSERT INTO OrderItem VALUES(117,44,44,24);
  502. INSERT INTO OrderItem VALUES(118,44,51,2);
  503. INSERT INTO OrderItem VALUES(119,45,20,20);
  504. INSERT INTO OrderItem VALUES(120,46,18,12);
  505. INSERT INTO OrderItem VALUES(121,46,24,10);
  506. INSERT INTO OrderItem VALUES(122,46,63,5);
  507. INSERT INTO OrderItem VALUES(123,46,75,6);
  508. INSERT INTO OrderItem VALUES(124,47,1,18);
  509. INSERT INTO OrderItem VALUES(125,47,17,15);
  510. INSERT INTO OrderItem VALUES(126,47,43,15);
  511. INSERT INTO OrderItem VALUES(127,47,60,21);
  512. INSERT INTO OrderItem VALUES(128,47,75,6);
  513. INSERT INTO OrderItem VALUES(129,48,56,4);
  514. INSERT INTO OrderItem VALUES(130,49,11,12);
  515. INSERT INTO OrderItem VALUES(131,49,16,30);
  516. INSERT INTO OrderItem VALUES(132,49,69,15);
  517. INSERT INTO OrderItem VALUES(135,51,2,40);
  518. INSERT INTO OrderItem VALUES(136,51,36,40);
  519. INSERT INTO OrderItem VALUES(137,51,59,30);
  520. INSERT INTO OrderItem VALUES(138,51,62,15);
  521. INSERT INTO OrderItem VALUES(139,52,19,15);
  522. INSERT INTO OrderItem VALUES(140,52,70,20);
  523. INSERT INTO OrderItem VALUES(141,53,66,30);
  524. INSERT INTO OrderItem VALUES(142,53,68,20);
  525. INSERT INTO OrderItem VALUES(143,54,40,10);
  526. INSERT INTO OrderItem VALUES(144,54,56,20);
  527. INSERT INTO OrderItem VALUES(145,55,17,40);
  528. INSERT INTO OrderItem VALUES(146,55,28,28);
  529. INSERT INTO OrderItem VALUES(147,55,43,12);
  530. INSERT INTO OrderItem VALUES(148,56,40,40);
  531. INSERT INTO OrderItem VALUES(149,56,65,30);
  532. INSERT INTO OrderItem VALUES(150,56,68,15);
  533. INSERT INTO OrderItem VALUES(151,57,49,30);
  534. INSERT INTO OrderItem VALUES(152,57,59,10);
  535. INSERT INTO OrderItem VALUES(153,57,71,2);
  536. INSERT INTO OrderItem VALUES(154,58,18,25);
  537. INSERT INTO OrderItem VALUES(155,58,29,25);
  538. INSERT INTO OrderItem VALUES(156,58,39,30);
  539. INSERT INTO OrderItem VALUES(157,59,30,10);
  540. INSERT INTO OrderItem VALUES(158,59,53,10);
  541. INSERT INTO OrderItem VALUES(159,59,54,5);
  542. INSERT INTO OrderItem VALUES(160,60,62,10);
  543. INSERT INTO OrderItem VALUES(161,60,68,3);
  544. INSERT INTO OrderItem VALUES(162,61,69,1);
  545. INSERT INTO OrderItem VALUES(163,61,70,5);
  546. INSERT INTO OrderItem VALUES(164,62,4,20);
  547. INSERT INTO OrderItem VALUES(165,62,6,30);
  548. INSERT INTO OrderItem VALUES(166,62,42,2);
  549. INSERT INTO OrderItem VALUES(167,62,43,20);
  550. INSERT INTO OrderItem VALUES(168,62,71,3);
  551. INSERT INTO OrderItem VALUES(169,63,16,10);
  552. INSERT INTO OrderItem VALUES(170,63,62,5);
  553. INSERT INTO OrderItem VALUES(171,64,42,6);
  554. INSERT INTO OrderItem VALUES(172,64,69,7);
  555. INSERT INTO OrderItem VALUES(173,65,28,4);
  556. INSERT INTO OrderItem VALUES(174,65,43,24);
  557. INSERT INTO OrderItem VALUES(175,65,53,20);
  558. INSERT INTO OrderItem VALUES(176,65,75,10);
  559. INSERT INTO OrderItem VALUES(177,66,36,12);
  560. INSERT INTO OrderItem VALUES(178,67,32,40);
  561. INSERT INTO OrderItem VALUES(179,67,58,30);
  562. INSERT INTO OrderItem VALUES(180,67,62,25);
  563. INSERT INTO OrderItem VALUES(181,68,34,14);
  564. INSERT INTO OrderItem VALUES(182,68,70,30);
  565. INSERT INTO OrderItem VALUES(183,69,41,10);
  566. INSERT INTO OrderItem VALUES(184,69,62,70);
  567. INSERT INTO OrderItem VALUES(185,70,1,20);
  568. INSERT INTO OrderItem VALUES(186,71,41,20);
  569. INSERT INTO OrderItem VALUES(187,71,76,6);
  570. INSERT INTO OrderItem VALUES(188,72,17,8);
  571. INSERT INTO OrderItem VALUES(189,72,28,14);
  572. INSERT INTO OrderItem VALUES(190,72,76,30);
  573. INSERT INTO OrderItem VALUES(191,73,71,30);
  574. INSERT INTO OrderItem VALUES(192,74,35,10);
  575. INSERT INTO OrderItem VALUES(193,75,52,20);
  576. INSERT INTO OrderItem VALUES(194,76,15,5);
  577. INSERT INTO OrderItem VALUES(195,76,25,4);
  578. INSERT INTO OrderItem VALUES(196,76,39,4);
  579. INSERT INTO OrderItem VALUES(197,77,16,21);
  580. INSERT INTO OrderItem VALUES(198,77,35,70);
  581. INSERT INTO OrderItem VALUES(199,77,46,30);
  582. INSERT INTO OrderItem VALUES(200,77,59,40);
  583. INSERT INTO OrderItem VALUES(201,77,63,80);
  584. INSERT INTO OrderItem VALUES(202,78,6,6);
  585. INSERT INTO OrderItem VALUES(203,78,13,12);
  586. INSERT INTO OrderItem VALUES(204,78,14,9);
  587. INSERT INTO OrderItem VALUES(205,78,31,4);
  588. INSERT INTO OrderItem VALUES(206,78,72,40);
  589. INSERT INTO OrderItem VALUES(207,79,4,24);
  590. INSERT INTO OrderItem VALUES(208,79,57,16);
  591. INSERT INTO OrderItem VALUES(209,79,75,50);
  592. INSERT INTO OrderItem VALUES(210,80,2,25);
  593. INSERT INTO OrderItem VALUES(211,80,11,50);
  594. INSERT INTO OrderItem VALUES(212,80,30,35);
  595. INSERT INTO OrderItem VALUES(213,80,58,30);
  596. INSERT INTO OrderItem VALUES(214,81,59,9);
  597. INSERT INTO OrderItem VALUES(215,81,65,40);
  598. INSERT INTO OrderItem VALUES(216,81,68,10);
  599. INSERT INTO OrderItem VALUES(217,82,19,10);
  600. INSERT INTO OrderItem VALUES(218,82,30,8);
  601. INSERT INTO OrderItem VALUES(219,82,38,20);
  602. INSERT INTO OrderItem VALUES(220,82,56,12);
  603. INSERT INTO OrderItem VALUES(221,83,26,50);
  604. INSERT INTO OrderItem VALUES(222,83,72,25);
  605. INSERT INTO OrderItem VALUES(223,84,54,15);
  606. INSERT INTO OrderItem VALUES(224,85,18,40);
  607. INSERT INTO OrderItem VALUES(225,85,42,10);
  608. INSERT INTO OrderItem VALUES(226,85,47,16);
  609. INSERT INTO OrderItem VALUES(227,86,14,10);
  610. INSERT INTO OrderItem VALUES(228,86,21,10);
  611. INSERT INTO OrderItem VALUES(229,86,71,40);
  612. INSERT INTO OrderItem VALUES(230,87,52,8);
  613. INSERT INTO OrderItem VALUES(231,87,68,10);
  614. INSERT INTO OrderItem VALUES(232,88,2,7);
  615. INSERT INTO OrderItem VALUES(233,88,31,25);
  616. INSERT INTO OrderItem VALUES(234,88,32,6);
  617. INSERT INTO OrderItem VALUES(235,88,51,48);
  618. INSERT INTO OrderItem VALUES(236,89,4,18);
  619. INSERT INTO OrderItem VALUES(237,90,23,40);
  620. INSERT INTO OrderItem VALUES(238,90,26,24);
  621. INSERT INTO OrderItem VALUES(239,90,36,20);
  622. INSERT INTO OrderItem VALUES(240,90,37,28);
  623. INSERT INTO OrderItem VALUES(241,90,72,25);
  624. INSERT INTO OrderItem VALUES(242,91,17,20);
  625. INSERT INTO OrderItem VALUES(243,91,30,15);
  626. INSERT INTO OrderItem VALUES(244,92,4,10);
  627. INSERT INTO OrderItem VALUES(245,92,17,70);
  628. INSERT INTO OrderItem VALUES(246,92,62,28);
  629. INSERT INTO OrderItem VALUES(247,93,18,20);
  630. INSERT INTO OrderItem VALUES(248,93,41,12);
  631. INSERT INTO OrderItem VALUES(249,93,43,40);
  632. INSERT INTO OrderItem VALUES(250,94,33,8);
  633. INSERT INTO OrderItem VALUES(251,94,59,9);
  634. INSERT INTO OrderItem VALUES(252,95,2,24);
  635. INSERT INTO OrderItem VALUES(253,95,31,56);
  636. INSERT INTO OrderItem VALUES(254,95,36,40);
  637. INSERT INTO OrderItem VALUES(255,95,55,40);
  638. INSERT INTO OrderItem VALUES(256,96,64,50);
  639. INSERT INTO OrderItem VALUES(257,96,68,4);
  640. INSERT INTO OrderItem VALUES(258,96,76,15);
  641. INSERT INTO OrderItem VALUES(259,97,4,35);
  642. INSERT INTO OrderItem VALUES(260,97,8,70);
  643. INSERT INTO OrderItem VALUES(261,98,8,70);
  644. INSERT INTO OrderItem VALUES(262,98,19,80);
  645. INSERT INTO OrderItem VALUES(263,98,42,9);
  646. INSERT INTO OrderItem VALUES(264,99,17,36);
  647.  
RAW Paste Data