API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 23rd, 2020
588
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.30 KB | None | 0 0
raw download clone embed print report
  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.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!