show databases;

create database emp_info;

use emp_info;

DROP TABLE IF EXISTS `offices`;

CREATE TABLE `offices` (

`officeCode` int(11) NOT NULL,
`office_city` varchar(25) DEFAULT NULL,
`phone` varchar(25) DEFAULT NULL,
`addressLine1` varchar(25) DEFAULT NULL,
`addressLine2` varchar(12) DEFAULT NULL,
`state` varchar(12) DEFAULT NULL,
`country` varchar(12) DEFAULT NULL,
`postalCode` varchar(12) DEFAULT NULL,
`territory` varchar(5) DEFAULT NULL,
PRIMARY KEY (`officeCode`)
);

-- Dump the data into "offices" table.

INSERT INTO `offices` VALUES (1,'San Francisco','+1 650 219 4782','100 Market
Street','Suite 300','CA','USA','94080','NA'),(2,'Boston','+1 215 837 0825','1550
Court Place','Suite 102','MA','USA','2107','NA'),(3,'NYC','+1 212 555 3000','523
East 53rd Street','apt. 5A','NY','USA','10022','NA'),(4,'Paris','+33 14 723
4404','43 Rue Jouffroy D\'abbans','NULL','NULL','France','75017','EMEA'),
(5,'Tokyo','+81 33 224 5000','4-1 Kioicho','NULL','Chiyoda-Ku','Japan','102-
8578','Japan'),(6,'Sydney','+61 2 9264 2451','5-11 Wentworth Avenue','Floor
#2','NULL','Australia','NSW 2010','APAC'),(7,'London','+44 20 7877 2041','25 Old
Broad Street','Level 7','NULL','UK','EC2N 1HN','EMEA');

-- create 'employees' table.

DROP TABLE IF EXISTS `employees`;

CREATE TABLE `employees` (

`employeeNumber` varchar(5) NOT NULL,
`lastName` varchar(12) DEFAULT NULL,
`firstName` varchar(12) DEFAULT NULL,
`extension` varchar(5) DEFAULT NULL,
`email` varchar(45) DEFAULT NULL,
`officeCode` int(11) NOT NULL,
`reportsTo` varchar(5) DEFAULT NULL,
`jobTitle` varchar(25) DEFAULT NULL,
PRIMARY KEY (`employeeNumber`),
CONSTRAINT `officecode` FOREIGN KEY (`officeCode`) REFERENCES `offices`
(`officeCode`)
);

-- Dump the data into "employees" table.

INSERT INTO `employees` VALUES

(1002,'Murphy','Diane','x5800','dmurphy@[Link]',1,'NULL','President')
,(1056,'Patterson','Mary','x4611','mpatterso@[Link]',1,'1002','VP
Sales'),
(1076,'Firrelli','Jeff','x9273','jfirrelli@[Link]',1,'1002','VP
Marketing'),
(1088,'Patterson','William','x4871','wpatterson@[Link]',6,'1056','Sal
es Manager (APAC)'),
(1143,'Bow','Anthony','x5428','abow@[Link]',1,'1056','Sales Manager
(NA)'),
(1165,'Jennings','Leslie','x3291','ljennings@[Link]',1,'1143','Sales
Rep'),
(1166,'Thompson','Leslie','x4065','lthompson@[Link]',1,'1143','Sales
Rep'),
(1188,'Firrelli','Julie','x2173','jfirrelli@[Link]',2,'1143','Sales
Rep'),
(1216,'Patterson','Steve','x4334','spatterson@[Link]',2,'1143','Sales
Rep'),(1286,'Tseng','Foon
Yue','x2248','ftseng@[Link]',3,'1143','Sales Rep'),
(1323,'Vanauf','George','x4102','gvanauf@[Link]',3,'1143','Sales
Rep'),(1337,'Bondur','Loui','x6493','lbondur@[Link]',4,'1102','Sales
Rep'),
(1370,'Hernandez','Gerard','x2028','ghernande@[Link]',4,'1102','Sales
Rep'),
(1401,'Castillo','Pamela','x2759','pcastillo@[Link]',4,'1102','Sales
Rep'),(1501,'Bott','Larry','x2311','lbott@[Link]',7,'1102','Sales
Rep'),(1504,'Jones','Barry','x102','bjones@[Link]',7,'1102','Sales
Rep'),(1611,'Fixter','Andy','x101','afixter@[Link]',6,'1088','Sales
Rep'),(1612,'Marsh','Peter','x102','pmarsh@[Link]',6,'1088','Sales
Rep'),(1619,'King','Tom','x103','tking@[Link]',6,'1088','Sales Rep'),
(1621,'Nishi','Mami','x101','mnishi@[Link]',5,'1056','Sales Rep'),
(1625,'Kato','Yoshimi','x102','ykato@[Link]',5,'1621','Sales Rep'),
(1702,'Gerard','Martin','x2312','mgerard@[Link]',4,'1102','Sales
Rep');

-- create 'customers' table.

DROP TABLE IF EXISTS `customers`;
SET FOREIGN_KEY_CHECKS = 0;
CREATE TABLE `customers` (
`customerNumber` int(11) NOT NULL,
`customerName` varchar(45) DEFAULT NULL,
`contactLastName` varchar(25) DEFAULT NULL,
`contactFirstName` varchar(25) DEFAULT NULL,
`city` varchar(25) DEFAULT NULL,
`state` varchar(25) DEFAULT NULL,
`postalCode` varchar(12) DEFAULT NULL,
`country` varchar(12) DEFAULT NULL,
`salesRepEmployeeNumber` varchar(5) DEFAULT NULL,
`creditLimit` int(11) NOT NULL,
PRIMARY KEY (`customerNumber`),
CONSTRAINT `emp_no` FOREIGN KEY (`salesRepEmployeeNumber`) REFERENCES `employees`
(`employeeNumber`)
);

-- Dump the data into "customer" table.

INSERT INTO `customers` VALUES (103,'Atelier graphique','Schmitt','Carine

','Nantes','NULL','44000','France','1370',21000),(112,'Signal Gift
Stores','King','Jean','Las Vegas','NV','83030','USA','1166',71800),(114,'Australian
Collectors,
Co.','Ferguson','Peter','Melbourne','Victoria','3004','Australia','1611',117300),
(119,'La Rochelle Gifts','Labrune','Janine
','Nantes','NULL','44000','France','1370',118200),(121,'Baane Mini
Imports','Bergulfsen','Jonas ','Stavern','NULL','4110','Norway','1504',81700),
(124,'Mini Gifts Distributors Ltd.','Nelson','Susan','San
Rafael','CA','97562','USA','1165',210500),(125,'Havel & Zbyszek
Co','Piestrzeniewicz','Zbyszek ','Warszawa','NULL','01-012','Poland','NULL',0),
(128,'Blauer See Auto,
Co.','Keitel','Roland','Frankfurt','NULL','60528','Germany','1504',59700),
(129,'Mini Wheels Co.','Murphy','Julie','San
Francisco','CA','94217','USA','1165',64600),(131,'Land of Toys
Inc.','Lee','Kwai','NYC','NY','10022','USA','1323',114900),(141,'Euro+ Shopping
Channel','Freyre','Diego ','Madrid','NULL','28034','Spain','1370',227600),
(144,'Volvo Model Replicas, Co','Berglund','Christina ','Luleå','NULL','S-958
22','Sweden','1504',53100),(145,'Danish Wholesale Imports','Petersen','Jytte
','Kobenhavn','NULL','1734','Denmark','1401',83400),(146,'Saveley & Henriot,
Co.','Saveley','Mary ','Lyon','NULL','69004','France','1337',123900),(148,'Dragon
Souveniers,
Ltd.','Natividad','Eric','Singapore','NULL','79903','Singapore','1621',103800),
(151,'Muscle Machine Inc','Young','Jeff','NYC','NY','10022','USA','1286',138500),
(157,'Diecast Classics
Inc.','Leong','Kelvin','Allentown','PA','70267','USA','1216',100600),(161,'Technics
Stores Inc.','Hashimoto','Juri','Burlingame','CA','94217','USA','1165',84600),
(166,'Handji Gifts&
Co','Victorino','Wendy','Singapore','NULL','69045','Singapore','1612',97900),
(167,'Herkku Gifts','Oeztan','Veysel','Bergen','NULL','N 5804','Norway
','1504',96800),(168,'American Souvenirs Inc','Franco','Keith','New
Haven','CT','97823','USA','1286',0),(169,'Porto Imports Co.','de Castro','Isabel
','Lisboa','NULL','1756','Portugal','NULL',0),(171,'Daedalus Designs
Imports','Rancé','Martine ','Lille','NULL','59000','France','1370',82900),(172,'La
Corne D\'abondance,
Co.','Bertrand','Marie','Paris','NULL','75012','France','1337',84300),
(173,'Cambridge Collectables
Co.','Tseng','Jerry','Cambridge','MA','51247','USA','1188',43400),(175,'Gift Depot
Inc.','King','Julie','Bridgewater','CT','97562','USA','1323',84300),(177,'Osaka
Souveniers Co.','Kentary','Mory','Kita-ku','Osaka',' 530-
0003','Japan','1621',81200),(181,'Vitachrome
Inc.','Frick','Michael','NYC','NY','10022','USA','1286',76400),(186,'Toys of
Finland,
Co.','Karttunen','Matti','Helsinki','NULL','21240','Finland','1501',96500),(187,'AV
Stores, Co.','Ashworth','Rachel','Manchester','NULL','EC2 5NT','UK','1501',136800),
(189,'Clover Collections,
Co.','Cassidy','Dean','Dublin','NULL','2','Ireland','1504',69400),(198,'Auto-Moto
Classics Inc.','Taylor','Leslie','Brickhaven','MA','58339','USA','1216',23000),
(201,'UK Collectables, Ltd.','Devon','Elizabeth','Liverpool','NULL','WX1
6LT','UK','1501',92700),(202,'Canadian Gift Exchange Network','Tamuri','Yoshi
','Vancouver','BC','V3F 2K1','Canada','1323',90300),(204,'Online Mini
Collectables','Barajas','Miguel','Brickhaven','MA','58339','USA','1188',68700),
(205,'[Link]','Young','Julie','Pasadena','CA','90003','USA','1166',90700
),(206,'Asian Shopping Network,
Co','Walker','Brydey','Singapore','NULL','38988','Singapore','NULL',0),(209,'Mini
Caravy','Citeaux','Frédérique
','Strasbourg','NULL','67000','France','1370',53800),(211,'King Kong Collectables,
Co.','Gao','Mike','Central Hong Kong','NULL','NULL','Hong Kong','1621',58600),
(216,'Enaco Distributors','Saavedra','Eduardo
','Barcelona','NULL','8022','Spain','1702',60300),(219,'Boards & Toys
Co.','Young','Mary','Glendale','CA','92561','USA','1166',11000),(223,'Natürlich
Autos','Kloss','Horst ','Cunewalde','NULL','1307','Germany','NULL',0),(227,'Heintze
Collectables','Ibsen','Palle','Ã…rhus','NULL','8200','Denmark','1401',120800),
(233,'Québec Home Shopping Network','Fresnière','Jean
','Montréal','Québec','H1J 1C3','Canada','1286',48700),(237,'ANG
Resellers','Camino','Alejandra ','Madrid','NULL','28001','Spain','NULL',0),
(239,'Collectable Mini Designs Co.','Thompson','Valarie','San
Diego','CA','91217','USA','1166',105000),(240,'[Link]','Bennett','Helen
','Cowes','Isle of Wight','PO31 7PJ','UK','1501',93900),(242,'Alpha
Cognac','Roulet','Annette ','Toulouse','NULL','31000','France','1370',61100),
(247,'Messner Shopping Network','Messner','Renate
','Frankfurt','NULL','60528','Germany','NULL',0),(249,'Amica Models &
Co.','Accorti','Paolo ','Torino','NULL','10100','Italy','1401',113000),(250,'Lyon
Souveniers','Da Silva','Daniel','Paris','NULL','75508','France','1337',68100),
(256,'Auto Associés & Cie.','Tonini','Daniel
','Versailles','NULL','78000','France','1370',77900),(259,'Toms Spezialitäten,
Ltd','Pfalzheim','Henriette ','Köln','NULL','50739','Germany','1504',120400),
(260,'Royal Canadian Collectables, Ltd.','Lincoln','Elizabeth
','Tsawassen','BC','T2F 8M4','Canada','1323',89600),(273,'Franken Gifts,
Co','Franken','Peter ','München','NULL','80805','Germany','NULL',0),(276,'Anna\'s
Decorations, Ltd','O\'Hara','Anna','North
Sydney','NSW','2060','Australia','1611',107800),(278,'Rovelli
Gifts','Rovelli','Giovanni ','Bergamo','NULL','24100','Italy','1401',119600),
(282,'Souveniers And Things
Co.','Huxley','Adrian','Chatswood','NSW','2067','Australia','1611',93300),
(286,'Marta\'s Replicas
Co.','Hernandez','Marta','Cambridge','MA','51247','USA','1216',123700),(293,'BG&E
Collectables','Harrison','Ed','Fribourg','NULL','1700','Switzerland','NULL',0),
(298,'Vida Sport,
Ltd','Holz','Mihael','Genève','NULL','1203','Switzerland','1702',141300),
(299,'Norway Gifts By Mail, Co.','Klaeboe','Jan','Oslo','NULL','N 0106','Norway
','1504',95100),(303,'Schuyler
Imports','Schuyler','Bradley','Amsterdam','NULL','1043 GR','Netherlands','NULL',0),
(307,'Der Hund
Imports','Andersen','Mel','Berlin','NULL','12209','Germany','NULL',0),(311,'Oulu
Toy Supplies,
Inc.','Koskitalo','Pirkko','Oulu','NULL','90110','Finland','1501',90500),
(314,'Petit Auto','Dewey','Catherine ','Bruxelles','NULL','B-
1180','Belgium','1401',79900),(319,'Mini Classics','Frick','Steve','White
Plains','NY','24067','USA','1323',102700),(320,'Mini Creations
Ltd.','Huang','Wing','New Bedford','MA','50553','USA','1188',94500),(321,'Corporate
Gift Ideas Co.','Brown','Julie','San Francisco','CA','94217','USA','1165',105000),
(323,'Down Under Souveniers, Inc','Graham','Mike','Auckland ','NULL','NULL','New
Zealand','1612',88000),(324,'Stylish Desk Decors, Co.','Brown','Ann
','London','NULL','WX3 6FW','UK','1501',77000),(328,'Tekni Collectables
Inc.','Brown','William','Newark','NJ','94019','USA','1323',43000),(333,'Australian
Gift Network, Co','Calaghan','Ben','South
Brisbane','Queensland','4101','Australia','1611',51600),(334,'Suominen
Souveniers','Suominen','Kalle','Espoo','NULL','FIN-02271','Finland','1501',98800),
(335,'Cramer Spezialitäten, Ltd','Cramer','Philip
','Brandenburg','NULL','14776','Germany','NULL',0),(339,'Classic Gift Ideas,
Inc','Cervantes','Francisca','Philadelphia','PA','71270','USA','1188',81100),
(344,'CAF
Imports','Fernandez','Jesus','Madrid','NULL','28023','Spain','1702',59600),
(347,'Men \'R\' US Retailers, Ltd.','Chandler','Brian','Los
Angeles','CA','91003','USA','1166',57700),(348,'Asian Treasures,
Inc.','McKenna','Patricia ','Cork','Co. Cork','NULL','Ireland','NULL',0),
(350,'Marseille Mini Autos','Lebihan','Laurence
','Marseille','NULL','13008','France','1337',65000),(353,'Reims
Collectables','Henriot','Paul ','Reims','NULL','51100','France','1337',81100),
(356,'SAR Distributors, Co','Kuger','Armand','Hatfield','Pretoria','28','South
Africa','NULL',0),
(357,'[Link]','MacKinlay','Wales','Auckland','NULL','NULL','New
Zealand','1612',77700),(361,'Kommission
Auto','Josephs','Karin','Münster','NULL','44087','Germany','NULL',0),
(362,'[Link]','Yoshido','Juri','Boston','MA','51003','USA','1216',41900)
,(363,'Online Diecast Creations
Co.','Young','Dorothy','Nashua','NH','62005','USA','1216',114200),(369,'Lisboa
Souveniers, Inc','Rodriguez','Lino ','Lisboa','NULL','1675','Portugal','NULL',0),
(376,'Precious
Collectables','Urs','Braun','Bern','NULL','3012','Switzerland','1702',0),
(379,'Collectables For Less
Inc.','Nelson','Allen','Brickhaven','MA','58339','USA','1188',70700),(381,'Royale
Belge','Cartrain','Pascale ','Charleroi','NULL','B-6000','Belgium','1401',23500),
(382,'Salzburg Collectables','Pipps','Georg
','Salzburg','NULL','5020','Austria','1401',71700),(385,'Cruz & Sons
Co.','Cruz','Arnold','Makati City','NULL','1227 MM','Philippines','1621',81500),
(386,'L\'ordine Souveniers','Moroni','Maurizio ','Reggio
Emilia','NULL','42100','Italy','1401',121400),(398,'Tokyo Collectables,
Ltd','Shimamura','Akiko','Minato-ku','Tokyo','106-0032','Japan','1621',94400),
(406,'Auto Canal+
Petit','Perrier','Dominique','Paris','NULL','75016','France','1337',95000),
(409,'Stuttgart Collectable Exchange','Müller','Rita
','Stuttgart','NULL','70563','Germany','NULL',0),(412,'Extreme Desk Decorations,
Ltd','McRoy','Sarah','Wellington','NULL','NULL','New Zealand','1612',86800),
(415,'Bavarian Collectables Imports,
Co.','Donnermeyer','Michael','Munich','NULL','80686','Germany','1504',77000),
(424,'Classic Legends
Inc.','Hernandez','Maria','NYC','NY','10022','USA','1286',67500),(443,'Feuer Online
Stores, Inc','Feuer','Alexander ','Leipzig','NULL','4179','Germany','NULL',0),
(447,'Gift Ideas Corp.','Lewis','Dan','Glendale','CT','97561','USA','1323',49700),
(448,'Scandinavian Gift Ideas','Larsson','Martha','Bräcke','NULL','S-844
67','Sweden','1504',116400),(450,'The Sharp Gifts Warehouse','Frick','Sue','San
Jose','CA','94217','USA','1165',77600),(452,'Mini Auto Werke','Mendel','Roland
','Graz','NULL','8010','Austria','1401',45300),(455,'Super Scale
Inc.','Murphy','Leslie','New Haven','CT','97823','USA','1286',95400),
(456,'Microscale Inc.','Choi','Yu','NYC','NY','10022','USA','1286',39800),
(458,'Corrida Auto Replicas, Ltd','Sommer','MartÃn
','Madrid','NULL','28023','Spain','1702',104600),(459,'Warburg
Exchange','Ottlieb','Sven ','Aachen','NULL','52066','Germany','NULL',0),
(462,'[Link]','Benitez','Violeta','New
Bedford','MA','50553','USA','1216',85800),(465,'Anton Designs,
Ltd.','Anton','Carmen','Madrid','NULL','28023','Spain','NULL',0),(471,'Australian
Collectables, Ltd','Clenahan','Sean','Glen
Waverly','Victoria','3150','Australia','1611',60300),(473,'Frau da
Collezione','Ricotti','Franco','Milan','NULL','NULL','Italy','1401',34800),
(475,'West Coast Collectables
Co.','Thompson','Steve','Burbank','CA','94019','USA','1166',55400),(477,'Mit
Vergnügen & Co.','Moos','Hanna ','Mannheim','NULL','68306','Germany','NULL',0),
(480,'Kremlin Collectables, Co.','Semenov','Alexander ','Saint
Petersburg','NULL','196143','Russia','NULL',0),(481,'Raanan Stores, Inc','Altagar,G
M','Raanan','Herzlia','NULL','47625','Israel','NULL',0),(484,'Iberia Gift Imports,
Corp.','Roel','José Pedro ','Sevilla','NULL','41101','Spain','1702',65700),
(486,'Motor Mint Distributors
Inc.','Salazar','Rosa','Philadelphia','PA','71270','USA','1323',72600),(487,'Signal
Collectibles Ltd.','Taylor','Sue','Brisbane','CA','94217','USA','1165',60300),
(489,'Double Decker Gift Stores, Ltd','Smith','Thomas ','London','NULL','WA1
1DP','UK','1501',43300);

-- Create `orders` table

DROP TABLE IF EXISTS `orders`;

CREATE TABLE `orders` (

`orderNumber` int(11) NOT NULL,
`orderDate` datetime DEFAULT NULL,
`requiredDate` datetime DEFAULT NULL,
`shippedDate` varchar(25) DEFAULT NULL,
`status` varchar(12) DEFAULT NULL,
 `comments` varchar(255) DEFAULT NULL,
`customerNumber` int(11) NOT NULL,
PRIMARY KEY (`orderNumber`),
CONSTRAINT `customer_no` FOREIGN KEY (`customerNumber`) REFERENCES `customers`
(`customerNumber`)
) ;

-- Dump the data into `orders`

INSERT INTO `orders` VALUES (10100,'2003-01-06 [Link]','2003-01-13 [Link]','10-

01-2003 [Link]','Shipped','NULL',363),(10101,'2003-01-09 [Link]','2003-01-18
[Link]','11-01-2003 [Link]','Shipped','Check on availability.',128),
(10102,'2003-01-10 [Link]','2003-01-18 [Link]','14-01-2003
[Link]','Shipped','NULL',181),(10103,'2003-01-29 [Link]','2003-02-07
[Link]','02-02-2003 [Link]','Shipped','NULL',121),(10104,'2003-01-31
[Link]','2003-02-09 [Link]','01-02-2003 [Link]','Shipped','NULL',141),
(10105,'2003-02-11 [Link]','2003-02-21 [Link]','12-02-2003
[Link]','Shipped','NULL',145),(10106,'2003-02-17 [Link]','2003-02-24
[Link]','21-02-2003 [Link]','Shipped','NULL',278),(10107,'2003-02-24
[Link]','2003-03-03 [Link]','26-02-2003 [Link]','Shipped','Difficult to
negotiate with customer. We need more marketing materials',131),(10108,'2003-03-03
[Link]','2003-03-12 [Link]','08-03-2003 [Link]','Shipped','NULL',385),
(10109,'2003-03-10 [Link]','2003-03-19 [Link]','11-03-2003
[Link]','Shipped','Customer requested that FedEx Ground is used for this
shipping',486),(10110,'2003-03-18 [Link]','2003-03-24 [Link]','20-03-2003
[Link]','Shipped','NULL',187),(10111,'2003-03-25 [Link]','2003-03-31
[Link]','30-03-2003 [Link]','Shipped','NULL',129),(10112,'2003-03-24
[Link]','2003-04-03 [Link]','29-03-2003 [Link]','Shipped','Customer requested
that ad materials (such as posters, pamphlets) be included in the shippment',144),
(10113,'2003-03-26 [Link]','2003-04-02 [Link]','27-03-2003
[Link]','Shipped','NULL',124),(10114,'2003-04-01 [Link]','2003-04-07
[Link]','02-04-2003 [Link]','Shipped','NULL',172),(10115,'2003-04-04
[Link]','2003-04-12 [Link]','07-04-2003 [Link]','Shipped','NULL',424),
(10116,'2003-04-11 [Link]','2003-04-19 [Link]','13-04-2003
[Link]','Shipped','NULL',381),(10117,'2003-04-16 [Link]','2003-04-24
[Link]','17-04-2003 [Link]','Shipped','NULL',148),(10118,'2003-04-21
[Link]','2003-04-29 [Link]','26-04-2003 [Link]','Shipped','Customer has
worked with some of our vendors in the past and is aware of their MSRP',216),
(10119,'2003-04-28 [Link]','2003-05-05 [Link]','02-05-2003
[Link]','Shipped','NULL',382),(10120,'2003-04-29 [Link]','2003-05-08
[Link]','01-05-2003 [Link]','Shipped','NULL',114),(10121,'2003-05-07
[Link]','2003-05-13 [Link]','13-05-2003 [Link]','Shipped','NULL',353),
(10122,'2003-05-08 [Link]','2003-05-16 [Link]','13-05-2003
[Link]','Shipped','NULL',350),(10123,'2003-05-20 [Link]','2003-05-29
[Link]','22-05-2003 [Link]','Shipped','NULL',103),(10124,'2003-05-21
[Link]','2003-05-29 [Link]','25-05-2003 [Link]','Shipped','Customer very
concerned about the exact color of the models.',112),(10125,'2003-05-21
[Link]','2003-05-27 [Link]','24-05-2003 [Link]','Shipped','NULL',114),
(10126,'2003-05-28 [Link]','2003-06-07 [Link]','02-06-2003
[Link]','Shipped','NULL',458),(10127,'2003-06-03 [Link]','2003-06-09
[Link]','06-06-2003 [Link]','Shipped','Customer requested special shippment.
The instructions were passed along to the warehouse',151),(10128,'2003-06-06
[Link]','2003-06-12 [Link]','11-06-2003 [Link]','Shipped','NULL',141),
(10129,'2003-06-12 [Link]','2003-06-18 [Link]','14-06-2003
[Link]','Shipped','NULL',324),(10130,'2003-06-16 [Link]','2003-06-24
[Link]','21-06-2003 [Link]','Shipped','NULL',198),(10131,'2003-06-16
[Link]','2003-06-25 [Link]','21-06-2003 [Link]','Shipped','NULL',447),
(10132,'2003-06-25 [Link]','2003-07-01 [Link]','28-06-2003
[Link]','Shipped','NULL',323),(10133,'2003-06-27 [Link]','2003-07-04
[Link]','03-07-2003 [Link]','Shipped','NULL',141),(10134,'2003-07-01
[Link]','2003-07-10 [Link]','05-07-2003 [Link]','Shipped','NULL',250),
(10135,'2003-07-02 [Link]','2003-07-12 [Link]','03-07-2003
[Link]','Shipped','NULL',124),(10136,'2003-07-04 [Link]','2003-07-14
[Link]','06-07-2003 [Link]','Shipped','Customer is interested in buying more
Ferrari models',242),(10137,'2003-07-10 [Link]','2003-07-20 [Link]','14-07-2003
[Link]','Shipped','NULL',353),(10138,'2003-07-07 [Link]','2003-07-16
[Link]','13-07-2003 [Link]','Shipped','NULL',496),(10139,'2003-07-16
[Link]','2003-07-23 [Link]','21-07-2003 [Link]','Shipped','NULL',282),
(10140,'2003-07-24 [Link]','2003-08-02 [Link]','30-07-2003
[Link]','Shipped','NULL',161),(10141,'2003-08-01 [Link]','2003-08-09
[Link]','04-08-2003 [Link]','Shipped','NULL',334),(10142,'2003-08-08
[Link]','2003-08-16 [Link]','13-08-2003 [Link]','Shipped','NULL',124),
(10143,'2003-08-10 [Link]','2003-08-18 [Link]','12-08-2003
[Link]','Shipped','Can we deliver the new Ford Mustang models by end-of-
quarter?',320),(10144,'2003-08-13 [Link]','2003-08-21 [Link]','14-08-2003
[Link]','Shipped','NULL',381),(10145,'2003-08-25 [Link]','2003-09-02
[Link]','31-08-2003 [Link]','Shipped','NULL',205),(10146,'2003-09-03
[Link]','2003-09-13 [Link]','06-09-2003 [Link]','Shipped','NULL',447),
(10147,'2003-09-05 [Link]','2003-09-12 [Link]','09-09-2003
[Link]','Shipped','NULL',379),(10148,'2003-09-11 [Link]','2003-09-21
[Link]','15-09-2003 [Link]','Shipped','They want to reevaluate their terms
agreement with Finance.',276),(10149,'2003-09-12 [Link]','2003-09-18
[Link]','17-09-2003 [Link]','Shipped','NULL',487),(10150,'2003-09-19
[Link]','2003-09-27 [Link]','21-09-2003 [Link]','Shipped','They want to
reevaluate their terms agreement with Finance.',148),(10151,'2003-09-21
[Link]','2003-09-30 [Link]','24-09-2003 [Link]','Shipped','NULL',311),
(10152,'2003-09-25 [Link]','2003-10-03 [Link]','01-10-2003
[Link]','Shipped','NULL',333),(10153,'2003-09-28 [Link]','2003-10-05
[Link]','03-10-2003 [Link]','Shipped','NULL',141),(10154,'2003-10-02
[Link]','2003-10-12 [Link]','08-10-2003 [Link]','Shipped','NULL',219),
(10155,'2003-10-06 [Link]','2003-10-13 [Link]','07-10-2003
[Link]','Shipped','NULL',186),(10156,'2003-10-08 [Link]','2003-10-17
[Link]','11-10-2003 [Link]','Shipped','NULL',141),(10157,'2003-10-09
[Link]','2003-10-15 [Link]','14-10-2003 [Link]','Shipped','NULL',473),
(10158,'2003-10-10 [Link]','2003-10-18 [Link]','15-10-2003
[Link]','Shipped','NULL',121),(10159,'2003-10-10 [Link]','2003-10-19
[Link]','16-10-2003 [Link]','Shipped','NULL',321),(10160,'2003-10-11
[Link]','2003-10-17 [Link]','17-10-2003 [Link]','Shipped','NULL',347),
(10161,'2003-10-17 [Link]','2003-10-25 [Link]','20-10-2003
[Link]','Shipped','NULL',227),(10162,'2003-10-18 [Link]','2003-10-26
[Link]','19-10-2003 [Link]','Shipped','NULL',321),(10163,'2003-10-20
[Link]','2003-10-27 [Link]','24-10-2003 [Link]','Shipped','NULL',424),
(10164,'2003-10-21 [Link]','2003-10-30 [Link]','23-10-2003
[Link]','Resolved','This order was disputed, but resolved on 11/1/2003; Customer
doesn\'t like the colors and precision of the models.',452),(10165,'2003-10-22
[Link]','2003-10-31 [Link]','26-12-2003 [Link]','Shipped','This order was on
hold because customers\'s credit limit had been exceeded. Order will ship when
payment is received',148),(10166,'2003-10-21 [Link]','2003-10-30 [Link]','27-
10-2003 [Link]','Shipped','NULL',462),(10167,'2003-10-23 [Link]','2003-10-30
[Link]','NULL','Cancelled','Customer called to cancel. The warehouse was notified
in time and the order didn\'t ship.',448),(10168,'2003-10-28 [Link]','2003-11-03
[Link]','01-11-2003 [Link]','Shipped','NULL',161),(10169,'2003-11-04
[Link]','2003-11-14 [Link]','09-11-2003 [Link]','Shipped','NULL',276),
(10170,'2003-11-04 [Link]','2003-11-12 [Link]','07-11-2003
[Link]','Shipped','NULL',452),(10171,'2003-11-05 [Link]','2003-11-13
[Link]','07-11-2003 [Link]','Shipped','NULL',233),(10172,'2003-11-05
[Link]','2003-11-14 [Link]','11-11-2003 [Link]','Shipped','NULL',175),
(10173,'2003-11-05 [Link]','2003-11-15 [Link]','09-11-2003
[Link]','Shipped','Cautious optimism. We have happy customers here, if we can
keep them well stocked.',278),(10174,'2003-11-06 [Link]','2003-11-15
[Link]','10-11-2003 [Link]','Shipped','NULL',333),(10175,'2003-11-06
[Link]','2003-11-14 [Link]','09-11-2003 [Link]','Shipped','NULL',324),
(10176,'2003-11-06 [Link]','2003-11-15 [Link]','12-11-2003
[Link]','Shipped','NULL',386),(10177,'2003-11-07 [Link]','2003-11-17
[Link]','12-11-2003 [Link]','Shipped','NULL',344),(10178,'2003-11-08
[Link]','2003-11-16 [Link]','10-11-2003 [Link]','Shipped','Custom shipping
instructions sent to warehouse',242),(10179,'2003-11-11 [Link]','2003-11-17
[Link]','13-11-2003 [Link]','Cancelled','Customer cancelled due to urgent
budgeting issues. Must be cautious when dealing with them in the future.',496),
(10180,'2003-11-11 [Link]','2003-11-19 [Link]','14-11-2003
[Link]','Shipped','NULL',171),(10181,'2003-11-12 [Link]','2003-11-19
[Link]','15-11-2003 [Link]','Shipped','NULL',167),(10182,'2003-11-12
[Link]','2003-11-21 [Link]','18-11-2003 [Link]','Shipped','NULL',124),
(10183,'2003-11-13 [Link]','2003-11-22 [Link]','15-11-2003
[Link]','Shipped','We need to keep in close contact with their Marketing VP. He
is the decision maker for all their purchases.',339),(10184,'2003-11-14
[Link]','2003-11-22 [Link]','20-11-2003 [Link]','Shipped','NULL',484),
(10185,'2003-11-14 [Link]','2003-11-21 [Link]','20-11-2003
[Link]','Shipped','NULL',320),(10186,'2003-11-14 [Link]','2003-11-20
[Link]','18-11-2003 [Link]','Shipped','They want to reevaluate their terms
agreement with the VP of Sales',489),(10187,'2003-11-15 [Link]','2003-11-24
[Link]','16-11-2003 [Link]','Shipped','NULL',211),(10188,'2003-11-18
[Link]','2003-11-26 [Link]','24-11-2003 [Link]','Shipped','NULL',167),
(10189,'2003-11-18 [Link]','2003-11-25 [Link]','24-11-2003
[Link]','Shipped','They
want to reevaluate their terms agreement with Finance.',205),(10190,'2003-11-19
[Link]','2003-11-29 [Link]','20-11-2003 [Link]','Shipped','NULL',141),
(10191,'2003-11-20 [Link]','2003-11-30 [Link]','24-11-2003
[Link]','Shipped','We must be cautions with this customer. Their VP of Sales
resigned. Company may be heading down.',259),(10192,'2003-11-20 [Link]','2003-11-
29 [Link]','25-11-2003 [Link]','Shipped','NULL',363),(10193,'2003-11-21
[Link]','2003-11-28 [Link]','27-11-2003 [Link]','Shipped','NULL',471),
(10194,'2003-11-25 [Link]','2003-12-02 [Link]','26-11-2003
[Link]','Shipped','NULL',146),(10195,'2003-11-25 [Link]','2003-12-01
[Link]','28-11-2003 [Link]','Shipped','NULL',319),(10196,'2003-11-26
[Link]','2003-12-03 [Link]','01-12-2003 [Link]','Shipped','NULL',455),
(10197,'2003-11-26 [Link]','2003-12-02 [Link]','01-12-2003
[Link]','Shipped','Customer inquired about remote controlled models and gold
models.',216),(10198,'2003-11-27 [Link]','2003-12-06 [Link]','03-12-2003
[Link]','Shipped','NULL',385),(10199,'2003-12-01 [Link]','2003-12-10
[Link]','06-12-2003 [Link]','Shipped','NULL',475),(10200,'2003-12-01
[Link]','2003-12-09 [Link]','06-12-2003 [Link]','Shipped','NULL',211),
(10201,'2003-12-01 [Link]','2003-12-11 [Link]','02-12-2003
[Link]','Shipped','NULL',129),(10202,'2003-12-02 [Link]','2003-12-09
[Link]','06-12-2003 [Link]','Shipped','NULL',357),(10203,'2003-12-02
[Link]','2003-12-11 [Link]','07-12-2003 [Link]','Shipped','NULL',141),
(10204,'2003-12-02 [Link]','2003-12-10 [Link]','04-12-2003
[Link]','Shipped','NULL',151),(10205,'2003-12-03 [Link]','2003-12-09
[Link]','07-12-2003 [Link]','Shipped',' I need all the information I can get on
our competitors.',141),(10206,'2003-12-05 [Link]','2003-12-13 [Link]','08-12-
2003 [Link]','Shipped','Can we renegotiate this one?',202),(10207,'2003-12-09
[Link]','2003-12-17 [Link]','11-12-2003 [Link]','Shipped','Check on
availability.',495),(10208,'2004-01-02 [Link]','2004-01-11 [Link]','04-01-2004
[Link]','Shipped','NULL',146),(10209,'2004-01-09 [Link]','2004-01-15
[Link]','12-01-2004 [Link]','Shipped','NULL',347),(10210,'2004-01-12
[Link]','2004-01-22 [Link]','20-01-2004 [Link]','Shipped','NULL',177),
(10211,'2004-01-15 [Link]','2004-01-25 [Link]','18-01-2004
[Link]','Shipped','NULL',406),(10212,'2004-01-16 [Link]','2004-01-24
[Link]','18-01-2004 [Link]','Shipped','NULL',141),(10213,'2004-01-22
[Link]','2004-01-28 [Link]','27-01-2004 [Link]','Shipped','Difficult to
negotiate with customer. We need more marketing materials',489),(10214,'2004-01-26
[Link]','2004-02-04 [Link]','29-01-2004 [Link]','Shipped','NULL',458),
(10215,'2004-01-29 [Link]','2004-02-08 [Link]','01-02-2004
[Link]','Shipped','Customer requested that FedEx Ground is used for this
shipping',475),(10216,'2004-02-02 [Link]','2004-02-10 [Link]','04-02-2004
[Link]','Shipped','NULL',256),(10217,'2004-02-04 [Link]','2004-02-14
[Link]','06-02-2004 [Link]','Shipped','NULL',166),(10218,'2004-02-09
[Link]','2004-02-16 [Link]','11-02-2004 [Link]','Shipped','Customer requested
that ad materials (such as posters, pamphlets) be included in the shipment',473),
(10219,'2004-02-10 [Link]','2004-02-17 [Link]','12-02-2004
[Link]','Shipped','NULL',487),(10220,'2004-02-12 [Link]','2004-02-19
[Link]','16-02-2004 [Link]','Shipped','NULL',189),(10221,'2004-02-18
[Link]','2004-02-26 [Link]','19-02-2004 [Link]','Shipped','NULL',314),
(10222,'2004-02-19 [Link]','2004-02-27 [Link]','20-02-2004
[Link]','Shipped','NULL',239),(10223,'2004-02-20 [Link]','2004-02-29
[Link]','24-02-2004 [Link]','Shipped','NULL',114),(10224,'2004-02-21
[Link]','2004-03-02 [Link]','26-02-2004 [Link]','Shipped','Customer has
worked with some of our vendors in the past and is aware of their MSRP',171),
(10225,'2004-02-22 [Link]','2004-03-01 [Link]','24-02-2004
[Link]','Shipped','NULL',298),(10226,'2004-02-26 [Link]','2004-03-06
[Link]','02-03-2004 [Link]','Shipped','NULL',239),(10227,'2004-03-02
[Link]','2004-03-12 [Link]','08-03-2004 [Link]','Shipped','NULL',146),
(10228,'2004-03-10 [Link]','2004-03-18 [Link]','13-03-2004
[Link]','Shipped','NULL',173),(10229,'2004-03-11 [Link]','2004-03-20
[Link]','12-03-2004 [Link]','Shipped','NULL',124),(10230,'2004-03-15
[Link]','2004-03-24 [Link]','20-03-2004 [Link]','Shipped','Customer very
concerned about the exact color of the models.',128),(10231,'2004-03-19
[Link]','2004-03-26 [Link]','25-03-2004 [Link]','Shipped','NULL',344),
(10232,'2004-03-20 [Link]','2004-03-30 [Link]','25-03-2004
[Link]','Shipped','NULL',240),(10233,'2004-03-29 [Link]','2004-04-04
[Link]','02-04-2004 [Link]','Shipped','Customer requested special shippment.
The instructions were passed along to the warehouse',328),(10234,'2004-03-30
[Link]','2004-04-05 [Link]','02-04-2004 [Link]','Shipped','NULL',412),
(10235,'2004-04-02 [Link]','2004-04-12 [Link]','06-04-2004
[Link]','Shipped','NULL',260),(10236,'2004-04-03 [Link]','2004-04-11
[Link]','08-04-2004 [Link]','Shipped','NULL',486),(10237,'2004-04-05
[Link]','2004-04-12 [Link]','10-04-2004 [Link]','Shipped','NULL',181),
(10238,'2004-04-09 [Link]','2004-04-16 [Link]','10-04-2004
[Link]','Shipped','NULL',145),(10239,'2004-04-12 [Link]','2004-04-21
[Link]','17-04-2004 [Link]','Shipped','NULL',311),(10240,'2004-04-13
[Link]','2004-04-20 [Link]','20-04-2004 [Link]','Shipped','NULL',177),
(10241,'2004-04-13 [Link]','2004-04-20 [Link]','19-04-2004
[Link]','Shipped','NULL',209),(10242,'2004-04-20 [Link]','2004-04-28
[Link]','25-04-2004 [Link]','Shipped','Customer is interested in buying more
Ferrari models',456),(10243,'2004-04-26 [Link]','2004-05-03 [Link]','28-04-2004
[Link]','Shipped','NULL',495),(10244,'2004-04-29 [Link]','2004-05-09
[Link]','04-05-2004 [Link]','Shipped','NULL',141),(10245,'2004-05-04
[Link]','2004-05-12 [Link]','09-05-2004 [Link]','Shipped','NULL',455),
(10246,'2004-05-05 [Link]','2004-05-13 [Link]','06-05-2004
[Link]','Shipped','NULL',141),(10247,'2004-05-05 [Link]','2004-05-11
[Link]','08-05-2004 [Link]','Shipped','NULL',334),(10248,'2004-05-07
[Link]','2004-05-14 [Link]','NULL','Cancelled','Order was mistakenly placed.
The warehouse noticed the lack of documentation.',131),(10249,'2004-05-08
[Link]','2004-05-17 [Link]','11-05-2004 [Link]','Shipped','Can we deliver the
new Ford Mustang models by end-of-quarter?',173),(10250,'2004-05-11
[Link]','2004-05-19 [Link]','15-05-2004 [Link]','Shipped','NULL',450),
(10251,'2004-05-18 [Link]','2004-05-24 [Link]','24-05-2004
[Link]','Shipped','NULL',328),(10252,'2004-05-26 [Link]','2004-06-04
[Link]','29-05-2004 [Link]','Shipped','NULL',406),(10253,'2004-06-01
[Link]','2004-06-09 [Link]','02-06-2004 [Link]','Cancelled','Customer
disputed the order and we agreed to cancel it.',201),(10254,'2004-06-03
[Link]','2004-06-13 [Link]','04-06-2004 [Link]','Shipped','Customer requested
that DHL is used for this shipping',323),(10255,'2004-06-04 [Link]','2004-06-12
[Link]','09-06-2004 [Link]','Shipped','NULL',209),(10256,'2004-06-08
[Link]','2004-06-16 [Link]','10-06-2004 [Link]','Shipped','NULL',145),
(10257,'2004-06-14 [Link]','2004-06-24 [Link]','15-06-2004
[Link]','Shipped','NULL',450),(10258,'2004-06-15 [Link]','2004-06-25
[Link]','23-06-2004 [Link]','Shipped','NULL',398),(10259,'2004-06-15
[Link]','2004-06-22 [Link]','17-06-2004 [Link]','Shipped','NULL',166),
(10260,'2004-06-16 [Link]','2004-06-22 [Link]','NULL','Cancelled','Customer
heard complaints from their customers and called to cancel this order. Will notify
the Sales Manager.',357),(10261,'2004-06-17 [Link]','2004-06-25 [Link]','22-06-
2004 [Link]','Shipped','NULL',233),(10262,'2004-06-24 [Link]','2004-07-01
[Link]','NULL','Cancelled','This customer found a better offer from one of our
competitors. Will call back to renegotiate.',141),(10263,'2004-06-28
[Link]','2004-07-04 [Link]','02-07-2004 [Link]','Shipped','NULL',175),
(10264,'2004-06-30 [Link]','2004-07-06 [Link]','01-07-2004
[Link]','Shipped','Customer will send a truck to our local warehouse on
7/1/2004',362),(10265,'2004-07-02 [Link]','2004-07-09 [Link]','07-07-2004
[Link]','Shipped','NULL',471),(10266,'2004-07-06 [Link]','2004-07-14
[Link]','10-07-2004 [Link]','Shipped','NULL',386),(10267,'2004-07-07
[Link]','2004-07-17 [Link]','09-07-2004 [Link]','Shipped','NULL',151),
(10268,'2004-07-12 [Link]','2004-07-18 [Link]','14-07-2004
[Link]','Shipped','NULL',412),(10269,'2004-07-16 [Link]','2004-07-22
[Link]','18-07-2004 [Link]','Shipped','NULL',382),(10270,'2004-07-19
[Link]','2004-07-27 [Link]','24-07-2004 [Link]','Shipped','Can we renegotiate
this one?',282),(10271,'2004-07-20 [Link]','2004-07-29 [Link]','23-07-2004
[Link]','Shipped','NULL',124),(10272,'2004-07-20 [Link]','2004-07-26
[Link]','22-07-2004 [Link]','Shipped','NULL',157),(10273,'2004-07-21
[Link]','2004-07-28 [Link]','22-07-2004 [Link]','Shipped','NULL',314),
(10274,'2004-07-21 [Link]','2004-07-29 [Link]','22-07-2004
[Link]','Shipped','NULL',379),(10275,'2004-07-23 [Link]','2004-08-02
[Link]','29-07-2004 [Link]','Shipped','NULL',119),(10276,'2004-08-02
[Link]','2004-08-11 [Link]','08-08-2004 [Link]','Shipped','NULL',204),
(10277,'2004-08-04 [Link]','2004-08-12 [Link]','05-08-2004
[Link]','Shipped','NULL',148),(10278,'2004-08-06 [Link]','2004-08-16
[Link]','09-08-2004 [Link]','Shipped','NULL',112),(10279,'2004-08-09
[Link]','2004-08-19 [Link]','15-08-2004 [Link]','Shipped','Cautious optimism.
We have happy customers here, if we can keep them well stocked. I need all the
information
I can get on the planned shippments of Porches',141),(10280,'2004-08-17
[Link]','2004-08-27 [Link]','19-08-2004 [Link]','Shipped','NULL',249),
(10281,'2004-08-19 [Link]','2004-08-28 [Link]','23-08-2004
[Link]','Shipped','NULL',157),(10282,'2004-08-20 [Link]','2004-08-26
[Link]','22-08-2004 [Link]','Shipped','NULL',124),(10283,'2004-08-20
[Link]','2004-08-30 [Link]','23-08-2004 [Link]','Shipped','NULL',260),
(10284,'2004-08-21 [Link]','2004-08-29 [Link]','26-08-2004
[Link]','Shipped','Custom shipping instructions sent to warehouse',299),
(10285,'2004-08-27 [Link]','2004-09-04 [Link]','31-08-2004
[Link]','Shipped','NULL',286),(10286,'2004-08-28 [Link]','2004-09-06
[Link]','01-09-2004 [Link]','Shipped','NULL',172),(10287,'2004-08-30
[Link]','2004-09-06 [Link]','01-09-2004 [Link]','Shipped','NULL',298),
(10288,'2004-09-01 [Link]','2004-09-11 [Link]','05-09-2004
[Link]','Shipped','NULL',166),(10289,'2004-09-03 [Link]','2004-09-13
[Link]','04-09-2004 [Link]','Shipped','We need to keep in close contact with
their Marketing VP. He is the decision maker for all their purchases.',167),
(10290,'2004-09-07 [Link]','2004-09-15 [Link]','13-09-2004
[Link]','Shipped','NULL',198),(10291,'2004-09-08 [Link]','2004-09-17
[Link]','14-09-2004 [Link]','Shipped','NULL',448),(10292,'2004-09-08
[Link]','2004-09-18 [Link]','11-09-2004 [Link]','Shipped','They want to
reevaluate their terms agreement with Finance.',131),(10293,'2004-09-09
[Link]','2004-09-18 [Link]','14-09-2004 [Link]','Shipped','NULL',249),
(10294,'2004-09-10 [Link]','2004-09-17 [Link]','14-09-2004
[Link]','Shipped','NULL',204),(10295,'2004-09-10 [Link]','2004-09-17
[Link]','14-09-2004 [Link]','Shipped','They want to reevaluate their terms
agreement with Finance.',362),(10296,'2004-09-15 [Link]','2004-09-22
[Link]','16-09-2004 [Link]','Shipped','NULL',415),(10297,'2004-09-16
[Link]','2004-09-22 [Link]','21-09-2004 [Link]','Shipped','We must be
cautions with this customer. Their VP of Sales resigned. Company may be heading
down.',189),(10298,'2004-09-27 [Link]','2004-10-05 [Link]','01-10-2004
[Link]','Shipped','NULL',103),(10299,'2004-09-30 [Link]','2004-10-10
[Link]','01-10-2004 [Link]','Shipped','NULL',186),(10300,'2003-10-04
[Link]','2003-10-13 [Link]','09-10-2003 [Link]','Shipped','NULL',128),
(10301,'2003-10-05 [Link]','2003-10-15 [Link]','08-10-2003
[Link]','Shipped','NULL',299),(10302,'2003-10-06 [Link]','2003-10-16
[Link]','07-10-2003 [Link]','Shipped','NULL',201),(10303,'2004-10-06
[Link]','2004-10-14 [Link]','09-10-2004 [Link]','Shipped','Customer inquired
about remote controlled models and gold models.',484),(10304,'2004-10-11
[Link]','2004-10-20 [Link]','17-10-2004 [Link]','Shipped','NULL',256),
(10305,'2004-10-13 [Link]','2004-10-22 [Link]','15-10-2004
[Link]','Shipped','Check on availability.',286),(10306,'2004-10-14
[Link]','2004-10-21 [Link]','17-10-2004 [Link]','Shipped','NULL',187),
(10307,'2004-10-14 [Link]','2004-10-23 [Link]','20-10-2004
[Link]','Shipped','NULL',339),(10308,'2004-10-15 [Link]','2004-10-24
[Link]','20-10-2004 [Link]','Shipped','Customer requested that FedEx Ground is
used for this shipping',319),(10309,'2004-10-15 [Link]','2004-10-24
[Link]','18-10-2004 [Link]','Shipped','NULL',121),(10310,'2004-10-16
[Link]','2004-10-24 [Link]','18-10-2004 [Link]','Shipped','NULL',259),
(10311,'2004-10-16 [Link]','2004-10-23 [Link]','20-10-2004
[Link]','Shipped','Difficult to negotiate with customer. We need more marketing
materials',141),(10312,'2004-10-21 [Link]','2004-10-27 [Link]','23-10-2004
[Link]','Shipped','NULL',124),(10313,'2004-10-22 [Link]','2004-10-28
[Link]','25-10-2004 [Link]','Shipped','Customer requested that FedEx Ground is
used for this shipping',202),(10314,'2004-10-22 [Link]','2004-11-01
[Link]','23-10-2004 [Link]','Shipped','NULL',227),(10315,'2004-10-29
[Link]','2004-11-08 [Link]','30-10-2004 [Link]','Shipped','NULL',119),
(10316,'2004-11-01 [Link]','2004-11-09 [Link]','07-11-2004
[Link]','Shipped','Customer requested that ad materials (such as posters,
pamphlets) be included in the shippment',240),(10317,'2004-11-02 [Link]','2004-
11-12 [Link]','08-11-2004 [Link]','Shipped','NULL',161),(10318,'2004-11-02
[Link]','2004-11-09 [Link]','07-11-2004 [Link]','Shipped','NULL',157),
(10319,'2004-11-03 [Link]','2004-11-11 [Link]','06-11-2004
[Link]','Shipped','Customer requested that DHL is used for this shipping',456),
(10320,'2004-11-03 [Link]','2004-11-13 [Link]','07-11-2004
[Link]','Shipped','NULL',144),(10321,'2004-11-04 [Link]','2004-11-12
[Link]','07-11-2004 [Link]','Shipped','NULL',462),(10322,'2004-11-04
[Link]','2004-11-12 [Link]','10-11-2004 [Link]','Shipped','Customer has
worked with some of our vendors in the past and is aware of their MSRP',363),
(10323,'2004-11-05 [Link]','2004-11-12 [Link]','09-11-2004
[Link]','Shipped','NULL',128),(10324,'2004-11-05 [Link]','2004-11-11
[Link]','08-11-2004 [Link]','Shipped','NULL',181),(10325,'2004-11-05
[Link]','2004-11-13 [Link]','08-11-2004 [Link]','Shipped','NULL',121),
(10326,'2004-11-09 [Link]','2004-11-16 [Link]','10-11-2004
[Link]','Shipped','NULL',144),(10327,'2004-11-10 [Link]','2004-11-19
[Link]','13-11-2004 [Link]','Resolved','Order was disputed and resolved on
12/1/04. The Sales Manager was involved. Customer claims the scales of the models
don\'t match what was discussed.',145),(10328,'2004-11-12 [Link]','2004-11-21
[Link]','18-11-2004 [Link]','Shipped','Customer very concerned about the exact
color of the models. There is high risk that he may dispute the order because there
is a slight color mismatch',278),(10329,'2004-11-15 [Link]','2004-11-24
[Link]','16-11-2004 [Link]','Shipped','NULL',131),(10330,'2004-11-16
[Link]','2004-11-25 [Link]','21-11-2004 [Link]','Shipped','NULL',385),
(10331,'2004-11-17 [Link]','2004-11-23 [Link]','23-11-2004
[Link]','Shipped','Customer requested special shippment. The instructions were
passed along to the warehouse',486),(10332,'2004-11-17 [Link]','2004-11-25
[Link]','18-11-2004 [Link]','Shipped','NULL',187),(10333,'2004-11-18
[Link]','2004-11-27 [Link]','20-11-2004 [Link]','Shipped','NULL',129),
(10334,'2004-11-19 [Link]','2004-11-28 [Link]','NULL','On Hold','The
outstaniding balance for this customer exceeds their credit limit. Order will be
shipped when a payment is received.',144),(10335,'2004-11-19 [Link]','2004-11-29
[Link]','23-11-2004 [Link]','Shipped','NULL',124),(10336,'2004-11-20
[Link]','2004-11-26 [Link]','24-11-2004 [Link]','Shipped','Customer requested
that DHL is used for this shipping',172),(10337,'2004-11-21 [Link]','2004-11-30
[Link]','26-11-2004 [Link]','Shipped','NULL',424),(10338,'2004-11-22
[Link]','2004-12-02 [Link]','27-11-2004 [Link]','Shipped','NULL',381),
(10339,'2004-11-23 [Link]','2004-11-30 [Link]','30-11-2004
[Link]','Shipped','NULL',398),(10340,'2004-11-24 [Link]','2004-12-01
[Link]','25-11-2004 [Link]','Shipped','Customer is interested in buying more
Ferrari models',216),(10341,'2004-11-24 [Link]','2004-12-01 [Link]','29-11-2004
[Link]','Shipped','NULL',382),(10342,'2004-11-24 [Link]','2004-12-01
[Link]','29-11-2004 [Link]','Shipped','NULL',114),(10343,'2004-11-24
[Link]','2004-12-01 [Link]','26-11-2004 [Link]','Shipped','NULL',353),
(10344,'2004-11-25 [Link]','2004-12-02 [Link]','29-11-2004
[Link]','Shipped','NULL',350),(10345,'2004-11-25 [Link]','2004-12-01
[Link]','26-11-2004 [Link]','Shipped','NULL',103),(10346,'2004-11-29
[Link]','2004-12-05 [Link]','30-11-2004 [Link]','Shipped','NULL',112),
(10347,'2004-11-29 [Link]','2004-12-07 [Link]','30-11-2004
[Link]','Shipped','Can we deliver the new Ford Mustang models by end-of-
quarter?',114),(10348,'2004-11-01 [Link]','2004-11-08 [Link]','05-11-2004
[Link]','Shipped','NULL',458),(10349,'2004-12-01 [Link]','2004-12-07
[Link]','03-12-2004 [Link]','Shipped','NULL',151),(10350,'2004-12-02
[Link]','2004-12-08 [Link]','05-12-2004 [Link]','Shipped','NULL',141),
(10351,'2004-12-03 [Link]','2004-12-11 [Link]','07-12-2004
[Link]','Shipped','NULL',324),(10352,'2004-12-03 [Link]','2004-12-12
[Link]','09-12-2004 [Link]','Shipped','NULL',198),(10353,'2004-12-04
[Link]','2004-12-11 [Link]','05-12-2004 [Link]','Shipped','NULL',447),
(10354,'2004-12-04 [Link]','2004-12-10 [Link]','05-12-2004
[Link]','Shipped','NULL',323),(10355,'2004-12-07 [Link]','2004-12-14
[Link]','13-12-2004 [Link]','Shipped','NULL',141),(10356,'2004-12-09
[Link]','2004-12-15 [Link]','12-12-2004 [Link]','Shipped','NULL',250),
(10357,'2004-12-10 [Link]','2004-12-16 [Link]','14-12-2004
[Link]','Shipped','NULL',124),(10358,'2004-12-10 [Link]','2004-12-16
[Link]','16-12-2004 [Link]','Shipped','Customer requested that DHL is used for
this shipping',141),(10359,'2004-12-15 [Link]','2004-12-23 [Link]','18-12-2004
[Link]','Shipped','NULL',353),(10360,'2004-12-16 [Link]','2004-12-22
[Link]','18-12-2004 [Link]','Shipped','NULL',496),(10361,'2004-12-17
[Link]','2004-12-24 [Link]','20-12-2004 [Link]','Shipped','NULL',282),
(10362,'2005-01-05 [Link]','2005-01-16 [Link]','10-01-2005
[Link]','Shipped','NULL',161),(10363,'2005-01-06 [Link]','2005-01-12
[Link]','10-01-2005 [Link]','Shipped','NULL',334),(10364,'2005-01-06
[Link]','2005-01-17 [Link]','09-01-2005 [Link]','Shipped','NULL',350),
(10365,'2005-01-07 [Link]','2005-01-18 [Link]','11-01-2005
[Link]','Shipped','NULL',320),(10366,'2005-01-10 [Link]','2005-01-19
[Link]','12-01-2005 [Link]','Shipped','NULL',381),(10367,'2005-01-12
[Link]','2005-01-21 [Link]','16-01-2005 [Link]','Resolved','This
order was disputed and resolved on 2/1/2005. Customer claimed that container with
shipment was damaged. FedEx\'s investigation proved this wrong.',205),(10368,'2005-
01-19 [Link]','2005-01-27 [Link]','24-01-2005 [Link]','Shipped','Can we
renegotiate this one?',124),(10369,'2005-01-20 [Link]','2005-01-28 [Link]','24-
01-2005 [Link]','Shipped','NULL',379),(10370,'2005-01-20 [Link]','2005-02-01
[Link]','25-01-2005 [Link]','Shipped','NULL',276),(10371,'2005-01-23
[Link]','2005-02-03 [Link]','25-01-2005 [Link]','Shipped','NULL',124),
(10372,'2005-01-26 [Link]','2005-02-05 [Link]','28-01-2005
[Link]','Shipped','NULL',398),(10373,'2005-01-31 [Link]','2005-02-08
[Link]','06-02-2005 [Link]','Shipped','NULL',311),(10374,'2005-02-02
[Link]','2005-02-09 [Link]','03-02-2005 [Link]','Shipped','NULL',333),
(10375,'2005-02-03 [Link]','2005-02-10 [Link]','06-02-2005
[Link]','Shipped','NULL',119),(10376,'2005-02-08 [Link]','2005-02-18
[Link]','13-02-2005 [Link]','Shipped','NULL',219),(10377,'2005-02-09
[Link]','2005-02-21 [Link]','12-02-2005 [Link]','Shipped','Cautious optimism.
We have happy customers here, if we can keep them well stocked.',186),(10378,'2005-
02-10 [Link]','2005-02-18 [Link]','11-02-2005 [Link]','Shipped','NULL',141),
(10379,'2005-02-10 [Link]','2005-02-18 [Link]','11-02-2005
[Link]','Shipped','NULL',141),(10380,'2005-02-16 [Link]','2005-02-24
[Link]','18-02-2005 [Link]','Shipped','NULL',141),(10381,'2005-02-17
[Link]','2005-02-25 [Link]','18-02-2005 [Link]','Shipped','NULL',321),
(10382,'2005-02-17 [Link]','2005-02-23 [Link]','18-02-2005
[Link]','Shipped','Custom shipping instructions sent to warehouse',124),
(10383,'2005-02-22 [Link]','2005-03-02 [Link]','25-02-2005
[Link]','Shipped','NULL',141),(10384,'2005-02-23 [Link]','2005-03-06
[Link]','27-02-2005 [Link]','Shipped','NULL',321),(10385,'2005-02-28
[Link]','2005-03-09 [Link]','01-03-2005 [Link]','Shipped','NULL',124),
(10386,'2005-03-01 [Link]','2005-03-09 [Link]','06-03-2005
[Link]','Resolved','Disputed then Resolved on 3/15/2005. Customer doesn\'t like
the craftsmaship of the models.',141),(10387,'2005-03-02 [Link]','2005-03-09
[Link]','06-03-2005 [Link]','Shipped','We need to keep in close contact with
their Marketing VP. He is the decision maker for all their purchases.',148),
(10388,'2005-03-03 [Link]','2005-03-11 [Link]','09-03-2005
[Link]','Shipped','NULL',462),(10389,'2005-03-03 [Link]','2005-03-09
[Link]','08-03-2005 [Link]','Shipped','NULL',448),(10390,'2005-03-04
[Link]','2005-03-11 [Link]','07-03-2005 [Link]','Shipped','They want to
reevaluate their terms agreement with Finance.',124),(10391,'2005-03-09
[Link]','2005-03-20 [Link]','15-03-2005 [Link]','Shipped','NULL',276),
(10392,'2005-03-10 [Link]','2005-03-18 [Link]','12-03-2005
[Link]','Shipped','NULL',452),(10393,'2005-03-11 [Link]','2005-03-22
[Link]','14-03-2005 [Link]','Shipped','They want to reevaluate their terms
agreement with Finance.',323),(10394,'2005-03-15 [Link]','2005-03-25
[Link]','19-03-2005 [Link]','Shipped','NULL',141),(10395,'2005-03-17
[Link]','2005-03-24 [Link]','23-03-2005 [Link]','Shipped','We must be
cautions with this customer. Their VP of Sales resigned. Company may be heading
down.',250),(10396,'2005-03-23 [Link]','2005-04-02 [Link]','28-03-2005
[Link]','Shipped','NULL',124),(10397,'2005-03-28 [Link]','2005-04-09
[Link]','01-04-2005 [Link]','Shipped','NULL',242),(10398,'2005-03-30
[Link]','2005-04-09 [Link]','31-03-2005 [Link]','Shipped','NULL',353),
(10399,'2005-04-01 [Link]','2005-04-12 [Link]','03-04-2005
[Link]','Shipped','NULL',496),(10400,'2005-04-01 [Link]','2005-04-11
[Link]','04-04-2005 [Link]','Shipped','Customer requested that DHL is used for
this shipping',450),(10401,'2005-04-03 [Link]','2005-04-14 [Link]','NULL','On
Hold','Customer credit limit exceeded. Will ship when a payment is received.',328),
(10402,'2005-04-07 [Link]','2005-04-14 [Link]','12-04-2005
[Link]','Shipped','NULL',406),(10403,'2005-04-08 [Link]','2005-04-18
[Link]','11-04-2005 [Link]','Shipped','NULL',201),(10404,'2005-04-08
[Link]','2005-04-14 [Link]','11-04-2005 [Link]','Shipped','NULL',323),
(10405,'2005-04-14 [Link]','2005-04-24 [Link]','20-04-2005
[Link]','Shipped','NULL',209),(10406,'2005-04-15 [Link]','2005-04-25
[Link]','21-04-2005 [Link]','Disputed','Customer claims container with shipment
was damaged during shipping and some items were missing.',145),(10407,'2005-04-22
[Link]','2005-05-04 [Link]','NULL','On Hold','Customer credit limit exceeded.
Will ship when a payment is received.',450),(10408,'2005-04-22 [Link]','2005-04-
29 [Link]','27-04-2005 [Link]','Shipped','NULL',398),(10409,'2005-04-23
[Link]','2005-05-05 [Link]','24-04-2005 [Link]','Shipped','NULL',166),
(10410,'2005-04-29 [Link]','2005-05-10 [Link]','30-04-2005
[Link]','Shipped','NULL',357),(10411,'2005-05-01 [Link]','2005-05-08
[Link]','06-05-2005 [Link]','Shipped','NULL',233),(10412,'2005-05-03
[Link]','2005-05-13 [Link]','05-05-2005 [Link]','Shipped','NULL',141),
(10413,'2005-05-05 [Link]','2005-05-14 [Link]','09-05-2005
[Link]','Shipped','Customer requested that DHL is used for this shipping',175),
(10414,'2005-05-06 [Link]','2005-05-13 [Link]','NULL','On Hold','Customer
credit limit exceeded. Will ship when a payment is received.',362),(10415,'2005-05-
09 [Link]','2005-05-20 [Link]','12-05-2005 [Link]','Disputed','Customer
claims the scales of the models don\'t match what was discussed.',471),
(10416,'2005-05-10 [Link]','2005-05-16 [Link]','14-05-2005
[Link]','Shipped','NULL',386),(10417,'2005-05-13 [Link]','2005-05-19
[Link]','19-05-2005 [Link]','Disputed','Customer doesn\'t like the colors and
precision of the models.',141),(10418,'2005-05-16 [Link]','2005-05-24
[Link]','20-05-2005 [Link]','Shipped','NULL',412),(10419,'2005-05-17
[Link]','2005-05-28 [Link]','19-05-2005 [Link]','Shipped','NULL',382),
(10420,'2005-05-29 [Link]','2005-06-07 [Link]','NULL','In Process','NULL',282),
(10421,'2005-05-29 [Link]','2005-06-06 [Link]','NULL','In Process','Custom
shipping instructions were sent to warehouse',124),(10422,'2005-05-30
[Link]','2005-06-11 [Link]','NULL','In Process','NULL',157),(10423,'2005-05-30
[Link]','2005-06-05 [Link]','NULL','In Process','NULL',314),(10424,'2005-05-31
[Link]','2005-06-08 [Link]','NULL','In Process','NULL',141),(10425,'2005-05-31
[Link]','2005-06-07 [Link]','NULL','In Process','NULL',119);

-- Create `orderdetails` table.

DROP TABLE IF EXISTS `orderdetails`;

CREATE TABLE `orderdetails` (

`orderNumber` int(11) NOT NULL,
`productCode` varchar(12) NOT NULL,
`quantityOrdered` varchar(11) NOT NULL,
`priceEach` decimal(12,2) DEFAULT NULL,
`orderLineNumber` int(11) NOT NULL,
PRIMARY KEY (`orderNumber`,`productCode`)
);

-- Dump the data in `orderdetails`

INSERT INTO `orderdetails` VALUES (10100,'S18_1749',30,136.00,3),

(10100,'S18_2248',50,55.09,2),(10100,'S18_4409',22,75.46,4),
(10100,'S24_3969',49,35.29,1),(10101,'S18_2325',25,108.06,4),
(10101,'S18_2795',26,167.06,1),(10101,'S24_1937',45,32.53,3),
(10101,'S24_2022',46,44.35,2),(10102,'S18_1342',39,95.55,2),
(10102,'S18_1367',41,43.13,1),(10103,'S10_1949',26,214.30,11),
(10103,'S10_4962',42,119.67,4),(10103,'S12_1666',27,121.64,8),
(10103,'S18_1097',35,94.50,10),(10103,'S18_2432',22,58.34,2),
(10103,'S18_2949',27,92.19,12),(10103,'S18_2957',35,61.84,14),
(10103,'S18_3136',25,86.92,13),(10103,'S18_3320',46,86.31,16),
(10103,'S18_4600',36,98.07,5),(10103,'S18_4668',41,40.75,9),
(10103,'S24_2300',36,107.34,1),(10103,'S24_4258',25,88.62,15),
(10103,'S32_1268',31,92.46,3),(10103,'S32_3522',45,63.35,7),
(10103,'S700_2824',42,94.07,6),(10104,'S12_3148',34,131.44,1),
(10104,'S12_4473',41,111.39,9),(10104,'S18_2238',24,135.90,8),
(10104,'S18_2319',29,122.73,12),(10104,'S18_3232',23,165.95,13),
(10104,'S18_4027',38,119.20,3),(10104,'S24_1444',35,52.02,6),
(10104,'S24_2840',44,30.41,10),(10104,'S24_4048',26,106.45,5),
(10104,'S32_2509',35,51.95,11),(10104,'S32_3207',49,56.55,4),
(10104,'S50_1392',33,114.59,7),(10104,'S50_1514',32,53.31,2),
(10105,'S10_4757',50,127.84,2),(10105,'S12_1108',41,205.72,15),
(10105,'S12_3891',29,141.88,14),(10105,'S18_3140',22,136.59,11),
(10105,'S18_3259',38,87.73,13),(10105,'S18_4522',41,75.48,10),
(10105,'S24_2011',43,117.97,9),(10105,'S24_3151',44,73.46,4),
(10105,'S24_3816',50,75.47,1),(10105,'S700_1138',41,54.00,5),
(10105,'S700_1938',29,86.61,12),(10105,'S700_2610',31,60.72,3),
(10105,'S700_3505',39,92.16,6),(10105,'S700_3962',22,99.31,7),
(10105,'S72_3212',25,44.77,8),(10106,'S18_1662',36,134.04,12),
(10106,'S18_2581',34,81.10,2),(10106,'S18_3029',41,80.86,18),
(10106,'S18_3856',41,94.22,17),(10106,'S24_1785',28,107.23,4),
(10106,'S24_2841',49,65.77,13),(10106,'S24_3420',31,55.89,14),
(10106,'S24_3949',50,55.96,11),(10106,'S24_4278',26,71.00,3),
(10106,'S32_4289',33,65.35,5),(10106,'S50_1341',39,35.78,6),
(10106,'S700_1691',31,91.34,7),(10106,'S700_2047',30,85.09,16),
(10106,'S700_2466',34,99.72,9),(10106,'S700_2834',32,113.90,1),
(10106,'S700_3167',44,76.00,8),(10106,'S700_4002',48,70.33,10),
(10106,'S72_1253',48,43.70,15),(10107,'S10_1678',30,81.35,2),
(10107,'S10_2016',39,105.86,5),(10107,'S10_4698',27,172.36,4),
(10107,'S12_2823',21,122.00,1),(10107,'S18_2625',29,52.70,6),
(10107,'S24_1578',25,96.92,3),(10107,'S24_2000',38,73.12,7),
(10107,'S32_1374',20,88.90,8),(10108,'S12_1099',33,165.38,6),
(10108,'S12_3380',45,96.30,4),(10108,'S12_3990',39,75.81,7),
(10108,'S12_4675',36,107.10,3),(10108,'S18_1889',38,67.76,2),
(10108,'S18_3278',26,73.17,9),(10108,'S18_3482',29,132.29,8),
(10108,'S18_3782',43,52.84,12),(10108,'S18_4721',44,139.87,11),
(10108,'S24_2360',35,64.41,15),(10108,'S24_3371',30,60.01,5),
(10108,'S24_3856',40,132.00,1),(10108,'S24_4620',31,67.10,10),
(10108,'S32_2206',27,36.21,13),(10108,'S32_4485',31,87.76,16),
(10108,'S50_4713',34,74.85,14),(10109,'S18_1129',26,117.48,4),
(10109,'S18_1984',38,137.98,3),(10109,'S18_2870',26,126.72,1),
(10109,'S18_3232',46,160.87,5),(10109,'S18_3685',47,125.74,2),
(10109,'S24_2972',29,32.10,6),(10110,'S18_1589',37,118.22,16),
(10110,'S18_1749',42,153.00,7),(10110,'S18_2248',32,51.46,6),
(10110,'S18_2325',33,115.69,4),(10110,'S18_2795',31,163.69,1),
(10110,'S18_4409',28,81.91,8),(10110,'S18_4933',42,62.00,9),
(10110,'S24_1046',36,72.02,13),(10110,'S24_1628',29,43.27,15),
(10110,'S24_1937',20,28.88,3),(10110,'S24_2022',39,40.77,2),
(10110,'S24_2766',43,82.69,11),(10110,'S24_2887',46,112.74,10),
(10110,'S24_3191',27,80.47,12),(10110,'S24_3432',37,96.37,14),
(10110,'S24_3969',48,35.29,5),(10111,'S18_1342',33,87.33,6),
(10111,'S18_1367',48,48.52,5),(10111,'S18_2957',28,53.09,2),
(10111,'S18_3136',43,94.25,1),(10111,'S18_3320',39,91.27,4),
(10111,'S24_4258',26,85.70,3),(10112,'S10_1949',29,197.16,1),
(10112,'S18_2949',23,85.10,2),(10113,'S12_1666',21,121.64,2),
(10113,'S18_1097',49,101.50,4),(10113,'S18_4668',50,43.27,3),
(10113,'S32_3522',23,58.82,1),(10114,'S10_4962',31,128.53,8),
(10114,'S18_2319',39,106.78,3),(10114,'S18_2432',45,53.48,6),
(10114,'S18_3232',48,169.34,4),(10114,'S18_4600',41,105.34,9),
(10114,'S24_2300',21,102.23,5),(10114,'S24_2840',24,28.64,1),
(10114,'S32_1268',32,88.61,7),(10114,'S32_2509',28,43.83,2),
(10114,'S700_2824',42,82.94,10),(10115,'S12_4473',46,111.39,5),
(10115,'S18_2238',46,140.81,4),(10115,'S24_1444',47,56.64,2),
(10115,'S24_4048',44,106.45,1),(10115,'S50_1392',27,100.70,3),
(10116,'S32_3207',27,60.28,1),(10117,'S12_1108',33,195.33,9),
(10117,'S12_3148',43,148.06,10),(10117,'S12_3891',39,173.02,8),
(10117,'S18_3140',26,121.57,5),(10117,'S18_3259',21,81.68,7),
(10117,'S18_4027',22,122.08,12),(10117,'S18_4522',23,73.73,4),
(10117,'S24_2011',41,119.20,3),(10117,'S50_1514',21,55.65,11),
(10117,'S700_1938',38,75.35,6),(10117,'S700_3962',45,89.38,1),
(10117,'S72_3212',50,52.42,2),(10118,'S700_3505',36,86.15,1),
(10119,'S10_4757',46,112.88,11),(10119,'S18_1662',43,151.38,3),
(10119,'S18_3029',21,74.84,9),(10119,'S18_3856',27,95.28,8),
(10119,'S24_2841',41,64.40,4),(10119,'S24_3151',35,72.58,13),
(10119,'S24_3420',20,63.12,5),(10119,'S24_3816',35,82.18,10),
(10119,'S24_3949',28,62.10,2),(10119,'S700_1138',25,57.34,14),
(10119,'S700_2047',29,74.23,7),(10119,'S700_2610',38,67.22,12),
(10119,'S700_4002',26,63.67,1),(10119,'S72_1253',28,40.22,6),
(10120,'S10_2016',29,118.94,3),(10120,'S10_4698',46,158.80,2),
(10120,'S18_2581',29,82.79,8),(10120,'S18_2625',46,57.54,4),
(10120,'S24_1578',35,110.45,1),(10120,'S24_1785',39,93.01,10),
(10120,'S24_2000',34,72.36,5),(10120,'S24_4278',29,71.73,9),
(10120,'S32_1374',22,94.90,6),(10120,'S32_4289',29,68.79,11),
(10120,'S50_1341',49,41.46,12),(10120,'S700_1691',47,91.34,13),
(10120,'S700_2466',24,81.77,15),(10120,'S700_2834',24,106.79,7),
(10120,'S700_3167',43,72.00,14),(10121,'S10_1678',34,86.13,5),
(10121,'S12_2823',50,126.52,4),(10121,'S24_2360',32,58.18,2),
(10121,'S32_4485',25,95.93,3),(10121,'S50_4713',44,72.41,1),
(10122,'S12_1099',42,155.66,10),(10122,'S12_3380',37,113.92,8),
(10122,'S12_3990',32,65.44,11),(10122,'S12_4675',20,104.80,7),
(10122,'S18_1129',34,114.65,2),(10122,'S18_1889',43,62.37,6),
(10122,'S18_1984',31,113.80,1),(10122,'S18_3232',25,137.17,3),
(10122,'S18_3278',21,69.15,13),(10122,'S18_3482',21,133.76,12),
(10122,'S18_3782',35,59.06,16),(10122,'S18_4721',28,145.82,15),
(10122,'S24_2972',39,34.74,4),(10122,'S24_3371',34,50.82,9),
(10122,'S24_3856',43,136.22,5),(10122,'S24_4620',29,67.10,14),
(10122,'S32_2206',31,33.79,17),(10123,'S18_1589',26,120.71,2),
(10123,'S18_2870',46,114.84,3),(10123,'S18_3685',34,117.26,4),
(10123,'S24_1628',50,43.27,1),(10124,'S18_1749',21,153.00,6),
(10124,'S18_2248',42,58.12,5),(10124,'S18_2325',42,111.87,3),
(10124,'S18_4409',36,75.46,7),(10124,'S18_4933',23,66.28,8),
(10124,'S24_1046',22,62.47,12),(10124,'S24_1937',45,30.53,2),
(10124,'S24_2022',22,36.29,1),(10124,'S24_2766',32,74.51,10),
(10124,'S24_2887',25,93.95,9),(10124,'S24_3191',49,76.19,11),
(10124,'S24_3432',43,101.73,13),(10124,'S24_3969',46,36.11,4),
(10125,'S18_1342',32,89.38,1),(10125,'S18_2795',34,138.38,2),
(10126,'S10_1949',38,205.73,11),(10126,'S10_4962',22,122.62,4),
(10126,'S12_1666',21,135.30,8),(10126,'S18_1097',38,116.67,10),
(10126,'S18_1367',42,51.21,17),(10126,'S18_2432',43,51.05,2),
(10126,'S18_2949',31,93.21,12),(10126,'S18_2957',46,61.84,14),
(10126,'S18_3136',30,93.20,13),(10126,'S18_3320',38,94.25,16),
(10126,'S18_4600',50,102.92,5),(10126,'S18_4668',43,47.29,9),
(10126,'S24_2300',27,122.68,1),(10126,'S24_4258',34,83.76,15),
(10126,'S32_1268',43,82.83,3),(10126,'S32_3522',26,62.05,7),
(10126,'S700_2824',45,97.10,6),(10127,'S12_1108',46,193.25,2),
(10127,'S12_3148',46,140.50,3),(10127,'S12_3891',42,169.56,1),
(10127,'S12_4473',24,100.73,11),(10127,'S18_2238',45,140.81,10),
(10127,'S18_2319',45,114.14,14),(10127,'S18_3232',22,149.02,15),
(10127,'S18_4027',25,126.39,5),(10127,'S24_1444',20,50.86,8),
(10127,'S24_2840',39,34.30,12),(10127,'S24_4048',20,107.63,7),
(10127,'S32_2509',45,46.53,13),(10127,'S32_3207',29,60.90,6),
(10127,'S50_1392',46,111.12,9),(10127,'S50_1514',46,55.65,4),
(10128,'S18_3140',41,120.20,2),(10128,'S18_3259',41,80.67,4),
(10128,'S18_4522',43,77.24,1),(10128,'S700_1938',32,72.75,3),
(10129,'S10_4757',33,123.76,2),(10129,'S24_2011',45,113.06,9),
(10129,'S24_3151',41,81.43,4),(10129,'S24_3816',50,76.31,1),
(10129,'S700_1138',31,58.67,5),(10129,'S700_2610',45,72.28,3),
(10129,'S700_3505',42,90.15,6),(10129,'S700_3962',30,94.34,7),
(10129,'S72_3212',32,44.23,8),(10130,'S18_3029',40,68.82,2),
(10130,'S18_3856',33,99.52,1),(10131,'S18_1662',21,141.92,4),
(10131,'S24_2841',35,60.97,5),(10131,'S24_3420',29,52.60,6),
(10131,'S24_3949',50,54.59,3),(10131,'S700_2047',22,76.94,8),
(10131,'S700_2466',40,86.76,1),(10131,'S700_4002',26,63.67,2),
(10131,'S72_1253',21,40.22,7),(10132,'S700_3167',36,80.00,1),
(10133,'S18_2581',49,80.26,3),(10133,'S24_1785',41,109.42,5),
(10133,'S24_4278',46,61.58,4),(10133,'S32_1374',23,80.91,1),
(10133,'S32_4289',49,67.41,6),(10133,'S50_1341',27,37.09,7),
(10133,'S700_1691',24,76.73,8),(10133,'S700_2834',27,115.09,2),
(10134,'S10_1678',41,90.92,2),(10134,'S10_2016',27,116.56,5),
(10134,'S10_4698',31,187.85,4),(10134,'S12_2823',20,131.04,1),
(10134,'S18_2625',30,51.48,6),(10134,'S24_1578',35,94.67,3),
(10134,'S24_2000',43,75.41,7),(10135,'S12_1099',42,173.17,7),
(10135,'S12_3380',48,110.39,5),(10135,'S12_3990',24,72.62,8),
(10135,'S12_4675',29,103.64,4),(10135,'S18_1889',48,66.99,3),
(10135,'S18_3278',45,65.94,10),(10135,'S18_3482',42,139.64,9),
(10135,'S18_3782',45,49.74,13),(10135,'S18_4721',31,133.92,12),
(10135,'S24_2360',29,67.18,16),(10135,'S24_2972',20,34.36,1),
(10135,'S24_3371',27,52.05,6),(10135,'S24_3856',47,139.03,2),
(10135,'S24_4620',23,76.80,11),(10135,'S32_2206',33,38.62,14),
(10135,'S32_4485',30,91.85,17),(10135,'S50_4713',44,78.92,15),
(10136,'S18_1129',25,117.48,2),(10136,'S18_1984',36,120.91,1),
(10136,'S18_3232',41,169.34,3),(10137,'S18_1589',44,115.73,2),
(10137,'S18_2870',37,110.88,3),(10137,'S18_3685',31,118.68,4),
(10137,'S24_1628',26,40.25,1),(
10138,'S18_1749',33,149.60,6),(10138,'S18_2248',22,51.46,5),
(10138,'S18_2325',38,114.42,3),(10138,'S18_4409',47,79.15,7),
(10138,'S18_4933',23,64.86,8),(10138,'S24_1046',45,59.53,12),
(10138,'S24_1937',22,33.19,2),(10138,'S24_2022',33,38.53,1),
(10138,'S24_2766',28,73.60,10),(10138,'S24_2887',30,96.30,9),
(10138,'S24_3191',49,77.05,11),(10138,'S24_3432',21,99.58,13),
(10138,'S24_3969',29,32.82,4),(10139,'S18_1342',31,89.38,7),
(10139,'S18_1367',49,52.83,6),(10139,'S18_2795',41,151.88,8),
(10139,'S18_2949',46,91.18,1),(10139,'S18_2957',20,52.47,3),
(10139,'S18_3136',20,101.58,2),(10139,'S18_3320',30,81.35,5),
(10139,'S24_4258',29,93.49,4),(10140,'S10_1949',37,186.44,11),
(10140,'S10_4962',26,131.49,4),(10140,'S12_1666',38,118.90,8),
(10140,'S18_1097',32,95.67,10),(10140,'S18_2432',46,51.05,2),
(10140,'S18_4600',40,100.50,5),(10140,'S18_4668',29,40.25,9),
(10140,'S24_2300',47,118.84,1),(10140,'S32_1268',26,87.64,3),
(10140,'S32_3522',28,62.05,7),(10140,'S700_2824',36,101.15,6),
(10141,'S12_4473',21,114.95,5),(10141,'S18_2238',39,160.46,4),
(10141,'S18_2319',47,103.09,8),(10141,'S18_3232',34,143.94,9),
(10141,'S24_1444',20,50.86,2),(10141,'S24_2840',21,32.18,6),
(10141,'S24_4048',40,104.09,1),(10141,'S32_2509',24,53.03,7),
(10141,'S50_1392',44,94.92,3),(10142,'S12_1108',33,166.24,12),
(10142,'S12_3148',33,140.50,13),(10142,'S12_3891',46,167.83,11),
(10142,'S18_3140',47,129.76,8),(10142,'S18_3259',22,95.80,10),
(10142,'S18_4027',24,122.08,15),(10142,'S18_4522',24,79.87,7),
(10142,'S24_2011',33,114.29,6),(10142,'S24_3151',49,74.35,1),
(10142,'S32_3207',42,60.90,16),(10142,'S50_1514',42,56.24,14),
(10142,'S700_1138',41,55.34,2),(10142,'S700_1938',43,77.08,9),
(10142,'S700_3505',21,92.16,3),(10142,'S700_3962',38,91.37,4),
(10142,'S72_3212',39,46.96,5),(10143,'S10_4757',49,133.28,15),
(10143,'S18_1662',32,126.15,7),(10143,'S18_3029',46,70.54,13),
(10143,'S18_3856',34,99.52,12),(10143,'S24_2841',27,63.71,8),
(10143,'S24_3420',33,59.83,9),(10143,'S24_3816',23,74.64,14),
(10143,'S24_3949',28,55.96,6),(10143,'S50_1341',34,34.91,1),
(10143,'S700_1691',36,86.77,2),(10143,'S700_2047',26,87.80,11),
(10143,'S700_2466',26,79.78,4),(10143,'S700_2610',31,69.39,16),
(10143,'S700_3167',28,70.40,3),(10143,'S700_4002',34,65.15,5),
(10143,'S72_1253',37,49.66,10),(10144,'S32_4289',20,56.41,1),
(10145,'S10_1678',45,76.56,6),(10145,'S10_2016',37,104.67,9),
(10145,'S10_4698',33,154.93,8),(10145,'S12_2823',49,146.10,5),
(10145,'S18_2581',30,71.81,14),(10145,'S18_2625',30,52.70,10),
(10145,'S24_1578',43,103.68,7),(10145,'S24_1785',40,87.54,16),
(10145,'S24_2000',47,63.98,11),(10145,'S24_2360',27,56.10,3),
(10145,'S24_4278',33,71.73,15),(10145,'S32_1374',33,99.89,12),
(10145,'S32_2206',31,39.43,1),(10145,'S32_4485',27,95.93,4),
(10145,'S50_4713',38,73.22,2),(10145,'S700_2834',20,113.90,13),
(10146,'S18_3782',47,60.30,2),(10146,'S18_4721',29,130.94,1),
(10147,'S12_1099',48,161.49,7),(10147,'S12_3380',31,110.39,5),
(10147,'S12_3990',21,74.21,8),(10147,'S12_4675',33,97.89,4),
(10147,'S18_1889',26,70.84,3),(10147,'S18_3278',36,74.78,10),
(10147,'S18_3482',37,129.35,9),(10147,'S24_2972',25,33.23,1),
(10147,'S24_3371',30,48.98,6),(10147,'S24_3856',23,123.58,2),
(10147,'S24_4620',31,72.76,11),(10148,'S18_1129',23,114.65,13),
(10148,'S18_1589',47,108.26,9),(10148,'S18_1984',25,136.56,12),
(10148,'S18_2870',27,113.52,10),(10148,'S18_3232',32,143.94,14),
(10148,'S18_3685',28,135.63,11),(10148,'S18_4409',34,83.75,1),
(10148,'S18_4933',29,66.28,2),(10148,'S24_1046',25,65.41,6),
(10148,'S24_1628',47,46.29,8),(10148,'S24_2766',21,77.24,4),
(10148,'S24_2887',34,115.09,3),(10148,'S24_3191',31,71.91,5),
(10148,'S24_3432',27,96.37,7),(10149,'S18_1342',50,87.33,4),
(10149,'S18_1367',30,48.52,3),(10149,'S18_1749',34,156.40,11),
(10149,'S18_2248',24,50.85,10),(10149,'S18_2325',33,125.86,8),
(10149,'S18_2795',23,167.06,5),(10149,'S18_3320',42,89.29,2),
(10149,'S24_1937',36,31.20,7),(10149,'S24_2022',49,39.87,6),
(10149,'S24_3969',26,38.57,9),(10149,'S24_4258',20,90.57,1),
(10150,'S10_1949',45,182.16,8),(10150,'S10_4962',20,121.15,1),
(10150,'S12_1666',30,135.30,5),(10150,'S18_1097',34,95.67,7),
(10150,'S18_2949',47,93.21,9),(10150,'S18_2957',30,56.21,11),
(10150,'S18_3136',26,97.39,10),(10150,'S18_4600',49,111.39,2),
(10150,'S18_4668',30,47.29,6),(10150,'S32_3522',49,62.05,4),
(10150,'S700_2824',20,95.08,3),(10151,'S12_4473',24,114.95,3),
(10151,'S18_2238',43,152.27,2),(10151,'S18_2319',49,106.78,6),
(10151,'S18_2432',39,58.34,9),(10151,'S18_3232',21,167.65,7),
(10151,'S24_2300',42,109.90,8),(10151,'S24_2840',30,29.35,4),
(10151,'S32_1268',27,84.75,10),(10151,'S32_2509',41,43.29,5),
(10151,'S50_1392',26,108.81,1),(10152,'S18_4027',35,117.77,1),
(10152,'S24_1444',25,49.13,4),(10152,'S24_4048',23,112.37,3),
(10152,'S32_3207',33,57.17,2),(10153,'S12_1108',20,201.57,11),
(10153,'S12_3148',42,128.42,12),(10153,'S12_3891',49,155.72,10),
(10153,'S18_3140',31,125.66,7),(10153,'S18_3259',29,82.69,9),
(10153,'S18_4522',22,82.50,6),(10153,'S24_2011',40,111.83,5),
(10153,'S50_1514',31,53.31,13),(10153,'S700_1138',43,58.00,1),
(10153,'S700_1938',31,80.55,8),(10153,'S700_3505',50,87.15,2),
(10153,'S700_3962',20,85.41,3),(10153,'S72_3212',50,51.87,4),
(10154,'S24_3151',31,75.23,2),(10154,'S700_2610',36,59.27,1),
(10155,'S10_4757',32,129.20,13),(10155,'S18_1662',38,138.77,5),
(10155,'S18_3029',44,83.44,11),(10155,'S18_3856',29,105.87,10),
(10155,'S24_2841',23,62.34,6),(10155,'S24_3420',34,56.55,7),
(10155,'S24_3816',37,76.31,12),(10155,'S24_3949',44,58.69,4),
(10155,'S700_2047',32,89.61,9),(10155,'S700_2466',20,87.75,2),
(10155,'S700_3167',43,76.80,1),(10155,'S700_4002',44,70.33,3),
(10155,'S72_1253',34,49.16,8),(10156,'S50_1341',20,43.64,1),
(10156,'S700_1691',48,77.64,2),(10157,'S18_2581',33,69.27,3),
(10157,'S24_1785',40,89.72,5),(10157,'S24_4278',33,66.65,4),
(10157,'S32_1374',34,83.91,1),(10157,'S32_4289',28,56.41,6),
(10157,'S700_2834',48,109.16,2),(10158,'S24_2000',22,67.79,1),
(10159,'S10_1678',49,81.35,14),(10159,'S10_2016',37,101.10,17),
(10159,'S10_4698',22,170.42,16),(10159,'S12_1099',41,188.73,2),
(10159,'S12_2823',38,131.04,13),(10159,'S12_3990',24,67.03,3),
(10159,'S18_2625',42,51.48,18),(10159,'S18_3278',21,66.74,5),
(10159,'S18_3482',25,129.35,4),(10159,'S18_3782',21,54.71,8),
(10159,'S18_4721',32,142.85,7),(10159,'S24_1578',44,100.30,15),
(10159,'S24_2360',27,67.18,11),(10159,'S24_3371',50,49.60,1),
(10159,'S24_4620',23,80.84,6),(10159,'S32_2206',35,39.43,9),
(10159,'S32_4485',23,86.74,12),(10159,'S50_4713',31,78.11,10),
(10160,'S12_3380',46,96.30,6),(10160,'S12_4675',50,93.28,5),
(10160,'S18_1889',38,70.84,4),(10160,'S18_3232',20,140.55,1),
(10160,'S24_2972',42,30.59,2),(10160,'S24_3856',35,130.60,3),
(10161,'S18_1129',28,121.72,12),(10161,'S18_1589',43,102.04,8),
(10161,'S18_1984',48,139.41,11),(10161,'S18_2870',23,125.40,9),
(10161,'S18_3685',36,132.80,10),(10161,'S18_4933',25,62.72,1),
(10161,'S24_1046',37,73.49,5),(10161,'S24_1628',23,47.29,7),
(10161,'S24_2766',20,82.69,3),(10161,'S24_2887',25,108.04,2),
(10161,'S24_3191',20,72.77,4),(10161,'S24_3432',30,94.23,6),
(10162,'S18_1342',48,87.33,2),(10162,'S18_1367',45,45.28,1),
(10162,'S18_1749',29,141.10,9),(10162,'S18_2248',27,53.28,8),
(10162,'S18_2325',38,113.15,6),(10162,'S18_2795',48,156.94,3),
(10162,'S18_4409',39,86.51,10),(10162,'S24_1937',37,27.55,5),
(10162,'S24_2022',43,38.98,4),(10162,'S24_3969',37,32.82,7),
(10163,'S10_1949',21,212.16,1),(10163,'S18_2949',31,101.31,2),
(10163,'S18_2957',48,59.96,4),(10163,'S18_3136',40,101.58,3),
(10163,'S18_3320',43,80.36,6),(10163,'S24_4258',42,96.42,5),
(10164,'S10_4962',21,143.31,2),(10164,'S12_1666',49,121.64,6),
(10164,'S18_1097',36,103.84,8),(10164,'S18_4600',45,107.76,3),
(10164,'S18_4668',25,46.29,7),(10164,'S32_1268',24,91.49,1),
(10164,'S32_3522',49,57.53,5),(10164,'S700_2824',39,86.99,4),
(10165,'S12_1108',44,168.32,3),(10165,'S12_3148',34,123.89,4),
(10165,'S12_3891',27,152.26,2),(10165,'S12_4473',48,109.02,12),
(10165,'S18_2238',29,134.26,11),(10165,'S18_2319',46,120.28,15),
(10165,'S18_2432',31,60.77,18),(10165,'S18_3232',47,154.10,16),
(10165,'S18_3259',50,84.71,1),(10165,'S18_4027',28,123.51,6),
(10165,'S24_1444',25,46.82,9),(10165,'S24_2300',32,117.57,17),
(10165,'S24_2840',27,31.12,13),(10165,'S24_4048',24,106.45,8),
(10165,'S32_2509',48,50.86,14),(10165,'S32_3207',44,55.30,7),
(10165,'S50_1392',48,106.49,10),(10165,'S50_1514',38,49.21,5),
(10166,'S18_3140',43,136.59,2),(10166,'S18_4522',26,72.85,1),
(10166,'S700_1938',29,76.22,3),(10167,'S10_4757',44,123.76,9),
(10167,'S18_1662',43,141.92,1),(10167,'S18_3029',46,69.68,7),
(10167,'S18_3856',34,84.70,6),(10167,'S24_2011',33,110.60,16),
(10167,'S24_2841',21,54.81,2),(10167,'S24_3151',20,77.00,11),
(10167,'S24_3420',32,64.44,3),(10167,'S24_3816',29,73.80,8),
(10167,'S700_1138',43,66.00,12),(10167,'S700_2047',29,87.80,5),
(10167,'S700_2610',46,62.16,10),(10167,'S700_3505',24,85.14,13),
(10167,'S700_3962',28,83.42,14),(10167,'S72_1253',40,42.71,4),
(10167,'S72_3212',38,43.68,15),(10168,'S10_1678',36,94.74,1),
(10168,'S10_2016',27,97.53,4),(10168,'S10_4698',20,160.74,3),
(10168,'S18_2581',21,75.19,9),(10168,'S18_2625',46,49.06,5),
(10168,'S24_1578',50,103.68,2),(10168,'S24_1785',49,93.01,11),
(10168,'S24_2000',29,72.36,6),(10168,'S24_3949',27,57.32,18),
(10168,'S24_4278',48,68.10,10),(10168,'S32_1374',28,89.90,7),
(10168,'S32_4289',31,57.78,12),(10168,'S50_1341',48,39.71,13),
(10168,'S700_1691',28,91.34,14),(10168,'S700_2466',31,87.75,16),
(10168,'S700_2834',36,94.92,8),(10168,'S700_3167',48,72.00,15),
(10168,'S700_4002',39,67.37,17),(10169,'S12_1099',30,163.44,2),
(10169,'S12_2823',35,126.52,13),(10169,'S12_3990',36,71.82,3),
(10169,'S18_3278',32,65.13,5),(10169,'S18_3482',36,136.70,4),
(10169,'S18_3782',38,52.84,8),(10169,'S18_4721',33,120.53,7),
(10169,'S24_2360',38,66.49,11),(10169,'S24_3371',34,53.27,1),
(10169,'S24_4620',24,77.61,6),(10169,'S32_2206',26,37.01,9),
(10169,'S32_4485',34,83.68,12),(10169,'S50_4713',48,75.66,10),
(10170,'S12_3380',47,116.27,4),(10170,'S12_4675',41,93.28,3),
(10170,'S18_1889',20,70.07,2),(10170,'S24_3856',34,130.60,1),
(10171,'S18_1129',35,134.46,2),(10171,'S18_1984',35,128.03,1),
(10171,'S18_3232',39,165.95,3),(10171,'S2
4_2972',36,34.74,4),(10172,'S18_1589',42,109.51,6),(10172,'S18_2870',39,117.48,7),
(10172,'S18_3685',48,139.87,8),(10172,'S24_1046',32,61.00,3),
(10172,'S24_1628',34,43.27,5),(10172,'S24_2766',22,79.97,1),
(10172,'S24_3191',24,77.91,2),(10172,'S24_3432',22,87.81,4),
(10173,'S18_1342',43,101.71,6),(10173,'S18_1367',48,51.75,5),
(10173,'S18_1749',24,168.30,13),(10173,'S18_2248',26,55.09,12),
(10173,'S18_2325',31,127.13,10),(10173,'S18_2795',22,140.06,7),
(10173,'S18_2957',28,56.84,2),(10173,'S18_3136',31,86.92,1),
(10173,'S18_3320',29,90.28,4),(10173,'S18_4409',21,77.31,14),
(10173,'S18_4933',39,58.44,15),(10173,'S24_1937',31,29.87,9),
(10173,'S24_2022',27,39.42,8),(10173,'S24_2887',23,98.65,16),
(10173,'S24_3969',35,35.70,11),(10173,'S24_4258',22,93.49,3),
(10174,'S10_1949',34,207.87,4),(10174,'S12_1666',43,113.44,1),
(10174,'S18_1097',48,108.50,3),(10174,'S18_2949',46,100.30,5),
(10174,'S18_4668',49,44.27,2),(10175,'S10_4962',33,119.67,9),
(10175,'S12_4473',26,109.02,1),(10175,'S18_2319',48,101.87,4),
(10175,'S18_2432',41,59.55,7),(10175,'S18_3232',29,150.71,5),
(10175,'S18_4600',47,102.92,10),(10175,'S24_2300',28,121.40,6),
(10175,'S24_2840',37,32.18,2),(10175,'S32_1268',22,89.57,8),
(10175,'S32_2509',50,50.86,3),(10175,'S32_3522',29,56.24,12),
(10175,'S700_2824',42,80.92,11),(10176,'S12_1108',33,166.24,2),
(10176,'S12_3148',47,145.04,3),(10176,'S12_3891',50,160.91,1),
(10176,'S18_2238',20,139.17,10),(10176,'S18_4027',36,140.75,5),
(10176,'S24_1444',27,55.49,8),(10176,'S24_4048',29,101.72,7),
(10176,'S32_3207',22,62.14,6),(10176,'S50_1392',23,109.96,9),
(10176,'S50_1514',38,52.14,4),(10177,'S18_3140',23,113.37,9),
(10177,'S18_3259',29,92.77,11),(10177,'S18_4522',35,82.50,8),
(10177,'S24_2011',50,115.52,7),(10177,'S24_3151',45,79.66,2),
(10177,'S700_1138',24,58.67,3),(10177,'S700_1938',31,77.95,10),
(10177,'S700_2610',32,64.33,1),(10177,'S700_3505',44,88.15,4),
(10177,'S700_3962',24,83.42,5),(10177,'S72_3212',40,52.96,6),
(10178,'S10_4757',24,131.92,12),(10178,'S18_1662',42,127.73,4),
(10178,'S18_3029',41,70.54,10),(10178,'S18_3856',48,104.81,9),
(10178,'S24_2841',34,67.82,5),(10178,'S24_3420',27,65.75,6),
(10178,'S24_3816',21,68.77,11),(10178,'S24_3949',30,64.15,3),
(10178,'S700_2047',34,86.90,8),(10178,'S700_2466',22,91.74,1),
(10178,'S700_4002',45,68.11,2),(10178,'S72_1253',45,41.71,7),
(10179,'S18_2581',24,82.79,3),(10179,'S24_1785',47,105.04,5),
(10179,'S24_4278',27,66.65,4),(10179,'S32_1374',45,86.90,1),
(10179,'S32_4289',24,63.97,6),(10179,'S50_1341',34,43.20,7),
(10179,'S700_1691',23,75.81,8),(10179,'S700_2834',25,98.48,2),
(10179,'S700_3167',39,80.00,9),(10180,'S10_1678',29,76.56,9),
(10180,'S10_2016',42,99.91,12),(10180,'S10_4698',41,164.61,11),
(10180,'S12_2823',40,131.04,8),(10180,'S18_2625',25,48.46,13),
(10180,'S18_3782',21,59.06,3),(10180,'S18_4721',44,147.31,2),
(10180,'S24_1578',48,98.05,10),(10180,'S24_2000',28,61.70,14),
(10180,'S24_2360',35,60.95,6),(10180,'S24_4620',28,68.71,1),
(10180,'S32_2206',34,33.39,4),(10180,'S32_4485',22,102.05,7),
(10180,'S50_4713',21,74.85,5),(10181,'S12_1099',27,155.66,14),
(10181,'S12_3380',28,113.92,12),(10181,'S12_3990',20,67.03,15),
(10181,'S12_4675',36,107.10,11),(10181,'S18_1129',44,124.56,6),
(10181,'S18_1589',42,124.44,2),(10181,'S18_1889',22,74.69,10),
(10181,'S18_1984',21,129.45,5),(10181,'S18_2870',27,130.68,3),
(10181,'S18_3232',45,147.33,7),(10181,'S18_3278',30,73.17,17),
(10181,'S18_3482',22,120.53,16),(10181,'S18_3685',39,137.04,4),
(10181,'S24_1628',34,45.28,1),(10181,'S24_2972',37,32.85,8),
(10181,'S24_3371',23,54.49,13),(10181,'S24_3856',25,122.17,9),
(10182,'S18_1342',25,83.22,3),(10182,'S18_1367',32,44.21,2),
(10182,'S18_1749',44,159.80,10),(10182,'S18_2248',38,54.49,9),
(10182,'S18_2325',20,105.52,7),(10182,'S18_2795',21,135.00,4),
(10182,'S18_3320',33,86.31,1),(10182,'S18_4409',36,88.35,11),
(10182,'S18_4933',44,61.29,12),(10182,'S24_1046',47,63.20,16),
(10182,'S24_1937',39,31.86,6),(10182,'S24_2022',31,39.87,5),
(10182,'S24_2766',36,87.24,14),(10182,'S24_2887',20,116.27,13),
(10182,'S24_3191',33,73.62,15),(10182,'S24_3432',49,95.30,17),
(10182,'S24_3969',23,34.88,8),(10183,'S10_1949',23,180.01,8),
(10183,'S10_4962',28,127.06,1),(10183,'S12_1666',41,114.80,5),
(10183,'S18_1097',21,108.50,7),(10183,'S18_2949',37,91.18,9),
(10183,'S18_2957',39,51.22,11),(10183,'S18_3136',22,90.06,10),
(10183,'S18_4600',21,118.66,2),(10183,'S18_4668',40,42.26,6),
(10183,'S24_4258',47,81.81,12),(10183,'S32_3522',49,52.36,4),
(10183,'S700_2824',23,85.98,3),(10184,'S12_4473',37,105.47,6),
(10184,'S18_2238',46,145.72,5),(10184,'S18_2319',46,119.05,9),
(10184,'S18_2432',44,60.77,12),(10184,'S18_3232',28,165.95,10),
(10184,'S24_1444',31,57.22,3),(10184,'S24_2300',24,117.57,11),
(10184,'S24_2840',42,30.06,7),(10184,'S24_4048',49,114.73,2),
(10184,'S32_1268',46,84.75,13),(10184,'S32_2509',33,52.49,8),
(10184,'S32_3207',48,59.03,1),(10184,'S50_1392',45,92.60,4),
(10185,'S12_1108',21,195.33,13),(10185,'S12_3148',33,146.55,14),
(10185,'S12_3891',43,147.07,12),(10185,'S18_3140',28,124.30,9),
(10185,'S18_3259',49,94.79,11),(10185,'S18_4027',39,127.82,16),
(10185,'S18_4522',47,87.77,8),(10185,'S24_2011',30,105.69,7),
(10185,'S24_3151',33,83.20,2),(10185,'S50_1514',20,46.86,15),
(10185,'S700_1138',21,64.67,3),(10185,'S700_1938',30,79.68,10),
(10185,'S700_2610',39,61.44,1),(10185,'S700_3505',37,99.17,4),
(10185,'S700_3962',22,93.35,5),(10185,'S72_3212',28,47.50,6),
(10186,'S10_4757',26,108.80,9),(10186,'S18_1662',32,137.19,1),
(10186,'S18_3029',32,73.12,7),(10186,'S18_3856',46,98.46,6),
(10186,'S24_2841',22,60.29,2),(10186,'S24_3420',21,59.83,3),
(10186,'S24_3816',36,68.77,8),(10186,'S700_2047',24,80.56,5),
(10186,'S72_1253',28,42.71,4),(10187,'S18_2581',45,70.12,1),
(10187,'S24_1785',46,96.29,3),(10187,'S24_3949',43,55.96,10),
(10187,'S24_4278',33,64.48,2),(10187,'S32_4289',31,61.22,4),
(10187,'S50_1341',41,39.71,5),(10187,'S700_1691',34,84.95,6),
(10187,'S700_2466',44,95.73,8),(10187,'S700_3167',34,72.00,7),
(10187,'S700_4002',44,70.33,9),(10188,'S10_1678',48,95.70,1),
(10188,'S10_2016',38,111.80,4),(10188,'S10_4698',45,182.04,3),
(10188,'S18_2625',32,52.09,5),(10188,'S24_1578',25,95.80,2),
(10188,'S24_2000',40,61.70,6),(10188,'S32_1374',44,81.91,7),
(10188,'S700_2834',29,96.11,8),(10189,'S12_2823',28,138.57,1),
(10190,'S24_2360',42,58.87,3),(10190,'S32_2206',46,38.62,1),
(10190,'S32_4485',42,89.80,4),(10190,'S50_4713',40,67.53,2),
(10191,'S12_1099',21,155.66,3),(10191,'S12_3380',40,104.52,1),
(10191,'S12_3990',30,70.22,4),(10191,'S18_3278',36,75.59,6),
(10191,'S18_3482',23,119.06,5),(10191,'S18_3782',43,60.93,9),
(10191,'S18_4721',32,136.90,8),(10191,'S24_3371',48,53.27,2),
(10191,'S24_4620',44,77.61,7),(10192,'S12_4675',27,99.04,16),
(10192,'S18_1129',22,140.12,11),(10192,'S18_1589',29,100.80,7),
(10192,'S18_1889',45,70.84,15),(10192,'S18_1984',47,128.03,10),
(10192,'S18_2870',38,110.88,8),(10192,'S18_3232',26,137.17,12),
(10192,'S18_3685',45,125.74,9),(10192,'S24_1046',37,72.02,4),
(10192,'S24_1628',47,49.30,6),(10192,'S24_2766',46,86.33,2),
(10192,'S24_2887',23,112.74,1),(10192,'S24_2972',30,33.23,13),
(10192,'S24_3191',32,69.34,3),(10192,'S24_3432',46,93.16,5),
(10192,'S24_3856',45,112.34,14),(10193,'S18_1342',28,92.47,7),
(10193,'S18_1367',46,46.36,6),(10193,'S18_1749',21,153.00,14),
(10193,'S18_2248',42,60.54,13),(10193,'S18_2325',44,115.69,11),
(10193,'S18_2795',22,143.44,8),(10193,'S18_2949',28,87.13,1),
(10193,'S18_2957',24,53.09,3),(10193,'S18_3136',23,97.39,2),
(10193,'S18_3320',32,79.37,5),(10193,'S18_4409',24,92.03,15),
(10193,'S18_4933',25,66.28,16),(10193,'S24_1937',26,32.19,10),
(10193,'S24_2022',20,44.80,9),(10193,'S24_3969',22,38.16,12),
(10193,'S24_4258',20,92.52,4),(10194,'S10_1949',42,203.59,11),
(10194,'S10_4962',26,134.44,4),(10194,'S12_1666',38,124.37,8),
(10194,'S18_1097',21,103.84,10),(10194,'S18_2432',45,51.05,2),
(10194,'S18_4600',32,113.82,5),(10194,'S18_4668',41,47.79,9),
(10194,'S24_2300',49,112.46,1),(10194,'S32_1268',37,77.05,3),
(10194,'S32_3522',39,61.41,7),(10194,'S700_2824',26,80.92,6),
(10195,'S12_4473',49,118.50,6),(10195,'S18_2238',27,139.17,5),
(10195,'S18_2319',35,112.91,9),(10195,'S18_3232',50,150.71,10),
(10195,'S24_1444',44,54.33,3),(10195,'S24_2840',32,31.82,7),
(10195,'S24_4048',34,95.81,2),(10195,'S32_2509',32,51.95,8),
(10195,'S32_3207',33,59.03,1),(10195,'S50_1392',49,97.23,4),
(10196,'S12_1108',47,203.64,5),(10196,'S12_3148',24,151.08,6),
(10196,'S12_3891',38,147.07,4),(10196,'S18_3140',49,127.03,1),
(10196,'S18_3259',35,81.68,3),(10196,'S18_4027',27,126.39,8),
(10196,'S50_1514',46,56.82,7),(10196,'S700_1938',50,84.88,2),
(10197,'S10_4757',45,118.32,6),(10197,'S18_3029',46,83.44,4),
(10197,'S18_3856',22,85.75,3),(10197,'S18_4522',50,78.99,14),
(10197,'S24_2011',41,109.37,13),(10197,'S24_3151',47,83.20,8),
(10197,'S24_3816',22,67.93,5),(10197,'S700_1138',23,60.00,9),
(10197,'S700_2047',24,78.75,2),(10197,'S700_2610',50,66.50,7),
(10197,'S700_3505',27,100.17,10),(10197,'S700_3962',35,88.39,11),
(10197,'S72_1253',29,39.73,1),(10197,'S72_3212',42,48.59,12),
(10198,'S18_1662',42,149.81,4),(10198,'S24_2841',48,60.97,5),
(10198,'S24_3420',27,61.81,6),(10198,'S24_3949',43,65.51,3),
(10198,'S700_2466',42,94.73,1),(10198,'S700_4002',40,74.03,2),
(10199,'S50_1341',29,37.97,1),(10199,'S700_1691',48,81.29,2),
(10199,'S700_3167',38,70.40,3),(10200,'S18_2581',28,74.34,3),
(10200,'S24_1785',33,99.57,5),(10200,'S24_4278',39,70.28,4),
(10200,'S32_1374',35,80.91,1),(10200,'S32_4289',27,65.35,6),
(10200,'S700_2834',39,115.09,2),(10201,'S10_1678',22,82.30,2),
(10201,'S10_2016',24,116.56,5),(10201,'S10_4698',49,191.72,4),
(10201,'S12_2823',25,126.52,1),(10201,'S18_2625',30,48.46,6),
(10201,'S24_1578',39,93.54,3),(10201,'S24_2000',25,66.27,7),
(10202,'S18_3782',30,55.33,3),(10202,'S18_4721',43,124.99,2),
(10202,'S24_2360',50,56.10,6),(10202,'S24_4620',50,75.18,1),
(10202,'S32_2206',27,33.39,4),(10202,'S32_4485',31,81.64,7),
(10202,'S50_4713',40,79.73,5),(10203,'S12_1099',20,161.49,8),
(10203,'S12_3380',20,111.57,6),(10203,'S12_3990',44,63.84,9),
(10203,'S12_4675',47,115.16,5),(10203,'S18_1889',45,73.15,4),
(10203,'S18_3232',48,157.49,1),(10203,'S18_3278',33,66.74,11),
(10203,'S18_3482',32,127.88,10),(1
0203,'S24_2972',21,33.23,2),(10203,'S24_3371',34,56.94,7),
(10203,'S24_3856',47,140.43,3),(10204,'S18_1129',42,114.65,17),
(10204,'S18_1589',40,113.24,13),(10204,'S18_1749',33,153.00,4),
(10204,'S18_1984',38,133.72,16),(10204,'S18_2248',23,59.33,3),
(10204,'S18_2325',26,119.50,1),(10204,'S18_2870',27,106.92,14),
(10204,'S18_3685',35,132.80,15),(10204,'S18_4409',29,83.75,5),
(10204,'S18_4933',45,69.84,6),(10204,'S24_1046',20,69.82,10),
(10204,'S24_1628',45,46.79,12),(10204,'S24_2766',47,79.06,8),
(10204,'S24_2887',42,112.74,7),(10204,'S24_3191',40,84.75,9),
(10204,'S24_3432',48,104.94,11),(10204,'S24_3969',39,34.88,2),
(10205,'S18_1342',36,98.63,2),(10205,'S18_1367',48,45.82,1),
(10205,'S18_2795',40,138.38,3),(10205,'S24_1937',32,27.88,5),
(10205,'S24_2022',24,36.74,4);

-- Create `payments` table

DROP TABLE IF EXISTS `payments`;

CREATE TABLE `payments` (

`customerNumber` int(11) NOT NULL,
`checkNumber` varchar(12) NOT NULL,
`paymentDate` datetime DEFAULT NULL,
`amount` decimal(12,2) DEFAULT NULL,
PRIMARY KEY (`customerNumber`,`checkNumber`)
);

-- Dump data into `payments`

INSERT INTO `payments` VALUES (103,'HQ336336','2004-10-19 [Link]',6066.78),

(103,'JM555205','2003-06-05 [Link]',14571.44),(103,'OM314933','2004-12-18
[Link]',1676.14),(112,'BO864823','2004-12-17 [Link]',14191.12),
(112,'HQ55022','2003-06-06 [Link]',32641.98),(112,'ND748579','2004-08-20
[Link]',33347.88),(114,'GG31455','2003-05-20 [Link]',45864.03),
(114,'MA765515','2004-12-15 [Link]',82261.22),(114,'NP603840','2003-05-31
[Link]',7565.08),(114,'NR27552','2004-03-10 [Link]',44894.74),
(119,'DB933704','2004-11-14 [Link]',19501.82),(119,'LN373447','2004-08-08
[Link]',47924.19),(119,'NG94694','2005-02-22 [Link]',49523.67),
(121,'DB889831','2003-02-16 [Link]',50218.95),(121,'FD317790','2003-10-28
[Link]',1491.38),(121,'KI831359','2004-11-04 [Link]',17876.32),
(121,'MA302151','2004-11-28 [Link]',34638.14),(124,'AE215433','2005-03-05
[Link]',101244.59),(124,'BG255406','2004-08-28 [Link]',85410.87),
(124,'CQ287967','2003-04-11 [Link]',11044.30),(124,'ET64396','2005-04-16
[Link]',83598.04),(124,'HI366474','2004-12-27 [Link]',47142.70),
(124,'HR86578','2004-11-02 [Link]',55639.66),(124,'KI131716','2003-08-15
[Link]',111654.40),(124,'LF217299','2004-03-26 [Link]',43369.30),
(124,'NT141748','2003-11-25 [Link]',45084.38),(128,'DI925118','2003-01-28
[Link]',10549.01),(128,'FA465482','2003-10-18 [Link]',24101.81),
(128,'FH668230','2004-03-24 [Link]',33820.62),(128,'IP383901','2004-11-18
[Link]',7466.32),(129,'DM826140','2004-12-08 [Link]',26248.78),
(129,'ID449593','2003-12-11 [Link]',23923.93),(129,'PI42991','2003-04-09
[Link]',16537.85),(131,'CL442705','2003-03-12 [Link]',22292.62),
(131,'MA724562','2004-12-02 [Link]',50025.35),(131,'NB445135','2004-09-11
[Link]',35321.97),(141,'AU364101','2003-07-19 [Link]',36251.03),
(141,'DB583216','2004-11-01 [Link]',36140.38),(141,'DL460618','2005-05-19
[Link]',46895.48),(141,'HJ32686','2004-01-30 [Link]',59830.55),
(141,'ID10962','2004-12-31 [Link]',116208.40),(141,'IN446258','2005-03-25
[Link]',65071.26),(141,'JE105477','2005-03-18 [Link]',120166.58),
(141,'JN355280','2003-10-26 [Link]',49539.37),(141,'JN722010','2003-02-25
[Link]',40206.20),(141,'KT52578','2003-12-09 [Link]',63843.55),
(141,'MC46946','2004-07-09 [Link]',35420.74),(141,'MF629602','2004-08-16
[Link]',20009.53),(141,'NU627706','2004-05-17 [Link]',26155.91),
(144,'IR846303','2004-12-12 [Link]',36005.71),(144,'LA685678','2003-04-09
[Link]',7674.94),(145,'CN328545','2004-07-03 [Link]',4710.73),
(145,'ED39322','2004-04-26 [Link]',28211.70),(145,'HR182688','2004-12-01
[Link]',20564.86),(145,'JJ246391','2003-02-20 [Link]',53959.21),
(146,'FP549817','2004-03-18 [Link]',40978.53),(146,'FU793410','2004-01-16
[Link]',49614.72),(146,'LJ160635','2003-12-10 [Link]',39712.10),
(148,'BI507030','2003-04-22 [Link]',44380.15),(148,'DD635282','2004-08-11
[Link]',2611.84),(148,'KM172879','2003-12-26 [Link]',105743.00),
(148,'ME497970','2005-03-27 [Link]',3516.04),(151,'BF686658','2003-12-22
[Link]',58793.53),(151,'GB852215','2004-07-26 [Link]',20314.44),
(151,'IP568906','2003-06-18 [Link]',58841.35),(151,'KI884577','2004-12-14
[Link]',39964.63),(157,'HI618861','2004-11-19 [Link]',35152.12),
(157,'NN711988','2004-09-07 [Link]',63357.13),(161,'BR352384','2004-11-14
[Link]',2434.25),(161,'BR478494','2003-11-18 [Link]',50743.65),
(161,'KG644125','2005-02-02 [Link]',12692.19),(161,'NI908214','2003-08-05
[Link]',38675.13),(166,'BQ327613','2004-09-16 [Link]',38785.48),
(166,'DC979307','2004-07-07 [Link]',44160.92),(166,'LA318629','2004-02-28
[Link]',22474.17),(167,'ED743615','2004-09-19 [Link]',12538.01),
(167,'GN228846','2003-12-03 [Link]',85024.46),(171,'GB878038','2004-03-15
[Link]',18997.89),(171,'IL104425','2003-11-22 [Link]',42783.81),
(172,'AD832091','2004-09-09 [Link]',1960.80),(172,'CE51751','2004-12-04
[Link]',51209.58),(172,'EH208589','2003-04-20 [Link]',33383.14),
(173,'GP545698','2004-05-13 [Link]',11843.45),(173,'IG462397','2004-03-29
[Link]',20355.24),(175,'CITI3434344','2005-05-19 [Link]',28500.78),
(175,'IO448913','2003-11-19 [Link]',24879.08),(175,'PI15215','2004-07-10
[Link]',42044.77),(177,'AU750837','2004-04-17 [Link]',15183.63),
(177,'CI381435','2004-01-19 [Link]',47177.59),(181,'CM564612','2004-04-25
[Link]',22602.36),(181,'GQ132144','2003-01-30 [Link]',5494.78),
(181,'OH367219','2004-11-16 [Link]',44400.50),(186,'AE192287','2005-03-10
[Link]',23602.90),(186,'AK412714','2003-10-27 [Link]',37602.48),
(186,'KA602407','2004-10-21 [Link]',34341.08),(187,'AM968797','2004-11-03
[Link]',52825.29),(187,'BQ39062','2004-12-08 [Link]',47159.11),
(187,'KL124726','2003-03-27 [Link]',48425.69),(189,'BO711618','2004-10-03
[Link]',17359.53),(189,'NM916675','2004-03-01 [Link]',32538.74),
(198,'FI192930','2004-12-06 [Link]',9658.74),(198,'HQ920205','2003-07-06
[Link]',6036.96),(198,'IS946883','2004-09-21 [Link]',5858.56),
(201,'DP677013','2003-10-20 [Link]',23908.24),(201,'OO846801','2004-06-15
[Link]',37258.94),(202,'HI358554','2003-12-18 [Link]',36527.61),
(202,'IQ627690','2004-11-08 [Link]',33594.58),(204,'GC697638','2004-08-13
[Link]',51152.86),(204,'IS150005','2004-09-24 [Link]',4424.40),
(205,'GL756480','2003-12-04 [Link]',3879.96),(205,'LL562733','2003-09-05
[Link]',50342.74),(205,'NM739638','2005-02-06 [Link]',39580.60),
(209,'BOAF82044','2005-05-03 [Link]',35157.75),(209,'ED520529','2004-06-21
[Link]',4632.31),(209,'PH785937','2004-05-04 [Link]',36069.26),
(211,'BJ535230','2003-12-09 [Link]',45480.79),(216,'BG407567','2003-05-09
[Link]',3101.40),(216,'ML780814','2004-12-06 [Link]',24945.21),
(216,'MM342086','2003-12-14 [Link]',40473.86),(219,'BN17870','2005-03-02
[Link]',3452.75),(219,'BR941480','2003-10-18 [Link]',4465.85),
(227,'MQ413968','2003-10-31 [Link]',36164.46),(227,'NU21326','2004-11-02
[Link]',53745.34),(233,'BOFA23232','2005-05-20 [Link]',29070.38),
(233,'II180006','2004-07-01 [Link]',22997.45),(233,'JG981190','2003-11-18
[Link]',16909.84),(239,'NQ865547','2004-03-15 [Link]',80375.24),
(240,'IF245157','2004-11-16 [Link]',46788.14),(240,'JO719695','2004-03-28
[Link]',24995.61),(242,'AF40894','2003-11-22 [Link]',33818.34),
(242,'HR224331','2005-06-03 [Link]',12432.32),(242,'KI744716','2003-07-21
[Link]',14232.70),(249,'IJ399820','2004-09-19 [Link]',33924.24),
(249,'NE404084','2004-09-04 [Link]',48298.99),(250,'EQ12267','2005-05-17
[Link]',17928.09),(250,'HD284647','2004-12-30 [Link]',26311.63),
(250,'HN114306','2003-07-18 [Link]',23419.47),(256,'EP227123','2004-02-10
[Link]',5759.42),(256,'HE84936','2004-10-22 [Link]',53116.99),
(259,'EU280955','2004-11-06 [Link]',61234.67),(259,'GB361972','2003-12-07
[Link]',27988.47),(260,'IO164641','2004-08-30 [Link]',37527.58),
(260,'NH776924','2004-04-24 [Link]',29284.42),(276,'EM979878','2005-02-09
[Link]',27083.78),(276,'KM841847','2003-11-13 [Link]',38547.19),
(276,'LE432182','2003-09-28 [Link]',41554.73),(276,'OJ819725','2005-04-30
[Link]',29848.52),(278,'BJ483870','2004-12-05 [Link]',37654.09),
(278,'GP636783','2003-03-02 [Link]',52151.81),(278,'NI983021','2003-11-24
[Link]',37723.79),(282,'IA793562','2003-08-03 [Link]',24013.52),
(282,'JT819493','2004-08-02 [Link]',35806.73),(282,'OD327378','2005-01-03
[Link]',31835.36),(286,'DR578578','2004-10-28 [Link]',47411.33),
(286,'KH910279','2004-09-05 [Link]',43134.04),(298,'AJ574927','2004-03-13
[Link]',47375.92),(298,'LF501133','2004-09-18 [Link]',61402.00),
(299,'AD304085','2003-10-24 [Link]',36798.88),(299,'NR157385','2004-09-05
[Link]',32260.16),(311,'DG336041','2005-02-15 [Link]',46770.52),
(311,'FA728475','2003-10-06 [Link]',32723.04),(311,'NQ966143','2004-04-25
[Link]',16212.59),(314,'LQ244073','2004-08-09 [Link]',45352.47),
(314,'MD809704','2004-03-03 [Link]',16901.38),(319,'HL685576','2004-11-06
[Link]',42339.76),(319,'OM548174','2003-12-07 [Link]',36092.40),
(320,'GJ597719','2005-01-18 [Link]',8307.28),(320,'HO576374','2003-08-20
[Link]',41016.75),(320,'MU817160','2003-11-24 [Link]',52548.49),
(321,'DJ15149','2003-11-03 [Link]',85559.12),(321,'LA556321','2005-03-15
[Link]',46781.66),(323,'AL493079','2005-05-23 [Link]',75020.13),
(323,'ES347491','2004-06-24 [Link]',37281.36),(323,'HG738664','2003-07-05
[Link]',2880.00),(323,'PQ803830','2004-12-24 [Link]',39440.59),
(324,'DQ409197','2004-12-13 [Link]',13671.82),(324,'FP443161','2003-07-07
[Link]',29429.14),(324,'HB150714','2003-11-23 [Link]',37455.77),
(328,'EN930356','2004-04-16 [Link]',7178.66),(328,'NR631421','2004-05-30
[Link]',31102.85),(333,'HL209210','2003-11-15 [Link]',23936.53),
(333,'JK479662','2003-10-17 [Link]',9821.32),(333,'NF959653','2005-03-01
[Link]',21432.31),(334,'CS435306','2005-01-27 [Link]',45785.34),
(334,'HH517378','2003-08-16 [Link]',29716.86),(334,'LF737277','2004-05-22
[Link]',28394.54),(339,'AP286625','2004-10-24 [Link]',23333.06),
(339,'DA98827','2003-11-28 [Link]',34606.28),(344,'AF246722','2003-11-24
[Link]',31428.21),(344,'NJ906924','2004-04-02 [Link]',15322.93),
(347,'DG700707','2004-01-18 [Link]',21053.69),(347,'LG808674','2003-10-24
[Link]',20452.50),(350,'BQ602907','2004-12-11 [Link]',18888.31),
(350,'CI471510','2003-05-25 [Link]',50824.66),(350,'OB648482','2005-01-29
[Link]',1834.56),(353,'CO351193','2005-01-10 [Link]',49705.52),
(353,'ED878227','2003-07-21 [Link]',13920.26),(353,'GT878649','2003-05-21
[Link]',16700.47),(353,'HJ618252','2005-06-09 [Link]',46656.94),
(357,'AG240323','2003-12-16 [Link]',20220.04),(357,'NB291497','2004-05-15
[Link]',36442.34),(362,'FP170292','2004-07-11 [Link]',18473.71),
(362,'OG208861','2004-09-21 [Link]',15059.76),(363,'HL575273','2004-11-17
[Link]',50799.69),(363,'IS232033','2003-01-16 [Link]',10223.83),
(363,'PN238558','2003-12-05 [Link]',55425.77),(379,'CA762595','2005-02-12
[Link]',28322.83),(379,'FR499138','2003-09-16 [Link]',32680.31),
(379,'GB890854','2004-08-02 [Link]',12530.51),(381,'BC726082','2004-12-03
[Link]',12081.52),(381,'CC475233','2003-04-19 [Link]',1627.56),
(381,'GB117430','2005-02-03 [Link]',14379.90),(381,'MS154481','2003-08-22
[Link]',1128.20),(382,'CC871084','2003-05-12 [Link]',35826.33),
(382,'CT821147','2004-08-01 [Link]',6419.84),(382,'PH29054','2004-11-27
[Link]',42813.83),(385,'BN347084','2003-12-02 [Link]',20644.24),
(385,'CP804873','2004-11-19 [Link]',15822.84),(385,'EK785462','2003-03-09
[Link]',51001.22),(386,'DO106109','2003-11-18 [Link]',38524.29),
(386,'HG438769','2004-07-18 [Link]',51619.02),(398,'AJ478695','2005-02-14
[Link]',33967.73),(398,'DO787644','2004-06-21 [Link]',22037.91),
(398,'JPMR4544','2005-05-18 [Link]',615.45),(398,'KB54275','2004-11-29
[Link]',48927.64),(406,'BJMPR4545','2005-04-23 [Link]',12190.85),
(406,'HJ217687','2004-01-28 [Link]',49165.16),(406,'NA197101','2004-06-17
[Link]',25080.96),(412,'GH197075','2004-07-25 [Link]',35034.57),
(412,'PJ434867','2004-04-14 [Link]',31670.37),(415,'ER54537','2004-09-28
[Link]',31310.09),(424,'KF480160','2004-12-07 [Link]',25505.98),
(424,'LM271923','2003-04-16 [Link]',21665.98),(424,'OA595449','2003-10-31
[Link]',22042.37),(447,'AO757239','2003-09-15 [Link]',6631.36),
(447,'ER615123','2003-06-25 [Link]',17032.29),(447,'OU516561','2004-12-17
[Link]',26304.13),(448,'FS299615','2005-04-18 [Link]',27966.54),
(448,'KR822727','2004-09-30 [Link]',48809.90),(450,'EF485824','2004-06-21
[Link]',59551.38),(452,'ED473873','2003-11-15 [Link]',27121.90),
(452,'FN640986','2003-11-20 [Link]',15130.97),(452,'HG635467','2005-05-03
[Link]',8807.12),(455,'HA777606','2003-12-05 [Link]',38139.18),
(455,'IR662429','2004-05-12 [Link]',32239.47),(456,'GJ715659','2004-11-13
[Link]',27550.51),(456,'MO743231','2004-04-30 [Link]',1679.92),
(458,'DD995006','2004-11-15 [Link]',33145.56),(458,'NA377824','2004-02-06
[Link]',22162.61),(458,'OO606861','2003-06-13 [Link]',57131.92),
(462,'ED203908','2005-04-15 [Link]',30293.77),(462,'GC60330','2003-11-08
[Link]',9977.85),(462,'PE176846','2004-11-27 [Link]',48355.87),
(471,'AB661578','2004-07-28 [Link]',9415.13),(471,'CO645196','2003-12-10
[Link]',35505.63),(473,'LL427009','2004-02-17 [Link]',7612.06),
(473,'PC688499','2003-10-27 [Link]',17746.26),(475,'JP113227','2003-12-09
[Link]',7678.25),(475,'PB951268','2004-02-13 [Link]',36070.47),
(484,'GK294076','2004-10-26 [Link]',3474.66),(484,'JH546765','2003-11-29
[Link]',47513.19),(486,'BL66528','2004-04-14 [Link]',5899.38),
(486,'HS86661','2004-11-23 [Link]',45994.07),(486,'JB117768','2003-03-20
[Link]',25833.14),(487,'AH612904','2003-09-28 [Link]',29997.09),
(487,'PT550181','2004-02-29 [Link]',12573.28),(489,'OC773849','2003-12-04
[Link]',22275.73),(489,'PO860906','2004-01-31 [Link]',7310.42),
(495,'BH167026','2003-12-26 [Link]',59265.14),(495,'FN155234','2004-05-14
[Link]',6276.60),(496,'EU531600','2005-05-25 [Link]',30253.75),
(496,'MB342426','2003-07-16 [Link]',32077.44),(496,'MN89921','2004-12-31
[Link]',52166.00);

-- Create `productlines` table

DROP TABLE IF EXISTS `productlines`;

CREATE TABLE `productlines` (

`productLine` varchar(25) NOT NULL,
`textDescription` varchar(255) DEFAULT NULL,
PRIMARY KEY (`productLine`)
);

-- Dump data into `productlines`

INSERT INTO `productlines` VALUES ('Classic Cars','Attention car enthusiasts: Make

your wildest car ownership dreams come true.'),('Motorcycles','Our motorcycles are
state of the art replicas of classic as well as contemporary motorcycle legends
such as Harley Davidson, Ducati and Vespa.'),('Planes','Unique, diecast airplane
and helicopter replicas suitable for collections, as well as home, office or
classroom decorations.'),('Ships','The perfect holiday or anniversary gift for
executives, clients, friends, and family.'),('Trains','Model trains are a rewarding
hobby for enthusiasts of all ages.'),('Trucks and Buses','The Truck and Bus models
are realistic replicas of buses and specialized trucks produced from the early
1920s to present.'),('Vintage Cars','Our Vintage Car models realistically portray
automobiles produced from the early 1900s through the 1940s.'), ('Boats', 'Boats
category is a subset of Ships category, hence there is nothing new in this
bucket.');

-- Create `products` table

DROP TABLE IF EXISTS `products`;

CREATE TABLE `products` (

`productCode` varchar(12) NOT NULL,
`productName` varchar(45) DEFAULT NULL,
`productLine` varchar(25) DEFAULT NULL,
`productScale` varchar(25) DEFAULT NULL,
`productVendor` varchar(25) DEFAULT NULL,
`quantityInStock` varchar(5) DEFAULT NULL,
`buyPrice` varchar(12) DEFAULT NULL,
`MSRP` varchar(12) DEFAULT NULL,
PRIMARY KEY (`productCode`),
CONSTRAINT `product_line` FOREIGN KEY (`productLine`) REFERENCES `productlines`
(`productLine`)
);

-- Dump data into `products`

INSERT INTO `products` VALUES ('S10_1678','1969 Harley Davidson Ultimate

Chopper','Motorcycles','[Link]','Min Lin Diecast','7933','48.81','95.7'),
('S10_1949','1952 Alpine Renault 1300','Classic Cars','[Link]','Classic Metal
Creations','7305','98.58','214.3'),('S10_2016','1996 Moto Guzzi
1100i','Motorcycles','[Link]','Highway 66 Mini
Classics','6625','68.99','118.94'),('S10_4757','1972 Alfa Romeo GTA','Classic
Cars','[Link]','Motor City Art Classics','3252','85.68','136'),('S10_4962','1962
LanciaA Delta 16V','Classic Cars','[Link]','Second Gear
Diecast','6791','103.42','147.74'),('S12_1099','1968 Ford Mustang','Classic
Cars','[Link]','Autoart Studio Design','68','95.34','194.57'),('S12_1108','2001
Ferrari Enzo','Classic Cars','[Link]','Second Gear
Diecast','3619','95.59','207.8'),('S12_1666','1958 Setra Bus','Trucks and
Buses','[Link]','Welly Diecast Productions','1579','77.9','136.67'),
('S12_2823','2002 Suzuki XREO','Motorcycles','[Link]','Unimax Art
Galleries','9997','66.27','150.62'),('S12_3148','1969 Corvair Monza','Classic
Cars','[Link]','Welly Diecast Productions','NULL','NULL','6906'),
('S12_3380','1968 Dodge Charger','Classic Cars','[Link]','Welly Diecast
Productions','9123','75.16','117.44'),('S12_3891','1969 Ford Falcon','Classic
Cars','[Link]','Second Gear Diecast','1049','83.05','173.02'),('S12_3990','1970
Plymouth Hemi Cuda','Classic Cars','[Link]','Studio M Art
Models','5663','31.92','79.8'),('S12_4473','1957 Chevy Pickup','Trucks and
Buses','[Link]','Exoto Designs','NULL','6125','55.7'),('S12_4675','1969 Dodge
Charger','Classic Cars','[Link]','Welly Diecast
Productions','7323','58.73','115.16'),('S18_1097','1940 Ford Pickup Truck','Trucks
and Buses','[Link]','Studio M Art Models','2613','58.33','116.67'),
('S18_1129','1993 Mazda RX-7','Classic Cars','[Link]','Highway 66 Mini
Classics','3975','83.51','141.54'),('S18_1342','1937 Lincoln Berline','Vintage
Cars','[Link]','Motor City Art Classics','8693','60.62','102.74'),
('S18_1367','1936 Mercedes-Benz 500K Special Roadster','Vintage
Cars','[Link]','Studio M Art Models','8635','24.26','53.91'),('S18_1589','1965
Aston Martin DB5','Classic Cars','[Link]','Classic Metal
Creations','9042','65.96','124.44'),('S18_1662','1980s Black Hawk
Helicopter','Planes','[Link]','Red Start Diecast','5330','77.27','157.69'),
('S18_1749','1917 Grand Touring Sedan','Vintage Cars','[Link]','Welly Diecast
Productions','2724','86.7','170'),('S18_1889','1948 Porsche 356-A
Roadster','Classic Cars','[Link]','Gearbox Collectibles','8826','53.9','77'),
('S18_1984','1995 Honda Civic','Classic Cars','[Link]','Min Lin
Diecast','9772','93.89','142.25'),('S18_2238','1998 Chrysler Plymouth
Prowler','Classic Cars','[Link]','Gearbox
Collectibles','4724','101.51','163.73'),('S18_2248','1911 Ford Town Car','Vintage
Cars','[Link]','Motor City Art Classics','540','33.3','60.54'),('S18_2319','1964
Mercedes Tour Bus','Trucks and Buses','[Link]','Unimax Art
Galleries','8258','74.86','122.73'),('S18_2325','1932 Model A Ford J-
Coupe','Vintage Cars','[Link]','Autoart Studio Design','9354','58.48','127.13'),
('S18_2432','1926 Ford Fire Engine','Trucks and Buses','[Link]','Carousel DieCast
Legends','2018','24.92','60.77'),('S18_2581','P-51-D
Mustang','Planes','0.0916666666666667','Gearbox Collectibles','992','49','84.48'),
('S18_2625','1936 Harley Davidson El Knucklehead','Motorcycles','[Link]','Welly
Diecast Productions','4357','24.23','60.57'),('S18_2795','1928 Mercedes-Benz
SSK','Vintage Cars','[Link]','Gearbox Collectibles','548','72.56','168.75'),
('S18_2870','1999 Indy 500 Monte Carlo SS','Classic Cars','[Link]','Red Start
Diecast','8164','56.76','132'),('S18_2949','1913 Ford Model T Speedster','Vintage
Cars','[Link]','Carousel DieCast Legends','4189','60.78','101.31'),
('S18_2957','1934 Ford V8 Coupe','Vintage Cars','[Link]','Min Lin
Diecast','5649','34.35','62.46'),('S18_3029','1999 Yamaha Speed
Boat','Ships','[Link]','Min Lin Diecast','4259','51.61','86.02'),
('S18_3136','18th Century Vintage Horse Carriage','Vintage Cars','[Link]','Red
Start Diecast','5992','60.74','104.72'),('S18_3140','1903 Ford Model A','Vintage
Cars','[Link]','Unimax Art Galleries','3913','68.3','136.59'),('S18_3232','1992
Ferrari 360 Spider red','Classic Cars','[Link]','Unimax Art
Galleries','8347','77.9','169.34'),('S18_3233','1985 Toyota Supra','Classic
Cars','[Link]','Highway 66 Mini Classics','7733','57.01','107.57'),
('S18_3259','Collectable Wooden Train','Trains','[Link]','Carousel DieCast
Legends','6450','67.56','100.84'),('S18_3278','1969 Dodge Super Bee','Classic
Cars','[Link]','Min Lin Diecast','1917','49.05','80.41'),('S18_3320','1917
Maxwell Touring Car','Vintage Cars','[Link]','Exoto
Designs','7913','57.54','99.21'),('S18_3482','1976 Ford Gran Torino','Classic
Cars','[Link]','Gearbox Collectibles','9127','73.49','146.99'),('S18_3685','1948
Porsche Type 356 Roadster','Classic Cars','[Link]','Gearbox
Collectibles','8990','62.16','141.28'),('S18_3782','1957 Vespa
GS150','Motorcycles','[Link]','Studio M Art Models','7689','32.95','62.17'),
('S18_3856','1941 Chevrolet Special Deluxe Cabriolet','Vintage
Cars','[Link]','Exoto Designs','2378','64.58','105.87'),('S18_4027','1970 Triumph
Spitfire','Classic Cars','[Link]','Min Lin Diecast','5545','91.92','143.62'),
('S18_4409','1932 Alfa Romeo 8C2300 Spider Sport','Vintage Cars','[Link]','Exoto
Designs','6553','43.26','92.03'),('S18_4522','1904 Buick Runabout','Vintage
Cars','[Link]','Exoto Designs','8290','52.66','87.77'),('S18_4600','1940s Ford
truck','Trucks and Buses','[Link]','Motor City Art
Classics','3128','84.76','121.08'),('S18_4668','1939 Cadillac Limousine','Vintage
Cars','[Link]','Studio M Art Models','6645','23.14','50.31'),('S18_4721','1957
Corvette Convertible','Classic Cars','[Link]','Classic Metal
Creations','1249','69.93','148.8'),('S18_4933','1957 Ford Thunderbird','Classic
Cars','[Link]','Studio M Art Models','3209','34.21','71.27'),('S24_1046','1970
Chevy Chevelle SS 454','Classic Cars','[Link]','Unimax Art
Galleries','1005','49.24','73.49'),('S24_1444','1970 Dodge Coronet','Classic
Cars','[Link]','Highway 66 Mini Classics','NULL','4074','32.37'),
('S24_1578','1997 BMW R 1100 S','Motorcycles','[Link]','Autoart Studio
Design','7003','60.86','112.7'),('S24_1628','1966 Shelby Cobra 427 S/C','Classic
Cars','[Link]','Carousel DieCast Legends','8197','29.18','50.31'),
('S24_1785','1928 British Royal Navy Airplane','Planes','[Link]','Classic Metal
Creations','3627','66.74','109.42'),('S24_1937','1939 Chevrolet Deluxe
Coupe','Vintage Cars','[Link]','Motor City Art Classics','7332','22.57','33.19'),
('S24_2000','1960 BSA Gold Star DBD34','Motorcycles','[Link]','Highway 66 Mini
Classics','15','37.32','76.17'),('S24_2011','18th century
schooner','Ships','[Link]','Carousel DieCast Legends','1898','82.34','122.89'),
('S24_2022','1938 Cadillac V-16 Presidential Limousine','Vintage
Cars','[Link]','Classic Metal Creations','2847','20.61','44.8'),('S24_2300','1962
Volkswagen Microbus','Trucks and Buses','[Link]','Autoart Studio
Design','2327','61.34','127.79'),('S24_2360','1982 Ducati 900
Monster','Motorcycles','[Link]','Highway 66 Mini
Classics','6840','47.1','69.26'),('S24_2766','1949 Jaguar XK 120','Classic
Cars','[Link]','Classic Metal Creations','2350','47.25','90.87'),
('S24_2840','1958 Chevy Corvette Limited Edition','Classic
Cars','[Link]','Carousel DieCast Legends','2542','15.91','35.36'),
('S24_2841','1900s Vintage Bi-Plane','Planes','[Link]','Autoart Studio
Design','5942','34.25','68.51'),('S24_2887','1952 Citroen-15CV','Classic
Cars','[Link]','Exoto Designs','1452','72.82','117.44'),('S24_2972','1982
Lamborghini Diablo','Classic Cars','[Link]','Second Gear
Diecast','7723','16.24','37.76'),('S24_3151','1912 Ford Model T Delivery
Wagon','Vintage Cars','[Link]','Min Lin Diecast','9173','46.91','88.51'),
('S24_3191','1969 Chevrolet Camaro Z28','Classic Cars','[Link]','Exoto
Designs','4695','50.51','85.61'),('S24_3371','1971 Alpine Renault 1600s','Classic
Cars','[Link]','Welly Diecast Productions','7995','38.58','61.23'),
('S24_3420','1937 Horch 930V Limousine','Vintage Cars','[Link]','Autoart Studio
Design','2902','26.3','65.75'),('S24_3432','2002 Chevy Corvette','Classic
Cars','[Link]','Gearbox Collectibles','9446','62.11','107.08'),('S24_3816','1940
Ford Delivery Sedan','Vintage Cars','[Link]','Carousel DieCast
Legends','6621','48.64','83.86'),('S24_3856','1956 Porsche 356A Coupe','Classic
Cars','[Link]','Classic Metal Creations','6600','98.3','140.43'),
('S24_3949','Corsair F4U ( Bird Cage)','Planes','[Link]','Second Gear
Diecast','6812','29.34','68.24'),('S24_3969','1936 Mercedes Benz 500k
Roadster','Vintage Cars','[Link]','Red Start Diecast','2081','21.75','41.03'),
('S24_4048','1992 Porsche Cayenne Turbo Silver','Classic Cars','[Link]','Exoto
Designs','6582','69.78','118.28'),('S24_4258','1936 Chrysler Airflow','Vintage
Cars','[Link]','Second Gear Diecast','4710','57.46','97.39'),('S24_4278','1900s
Vintage Tri-Plane','Planes','[Link]','Unimax Art
Galleries','2756','36.23','72.45'),('S24_4620','1961 Chevrolet Impala','Classic
Cars','[Link]','Classic Metal Creations','7869','32.33','80.84'),
('S32_1268','1980’s GM Manhattan Express','Trucks and Buses','[Link]','Motor
City Art Classics','5099','53.93','96.31'),('S32_1374','1997 BMW F650
ST','Motorcycles','[Link]','Exoto Designs','178','66.92','99.89'),
('S32_2206','1982 Ducati 996 R','Motorcycles','[Link]','Gearbox
Collectibles','9241','24.14','40.23'),('S32_2509','1954 Greyhound
Scenicruiser','Trucks and Buses','[Link]','Classic Metal
Creations','2874','25.98','54.11'),('S32_3207','1950\'s Chicago Surface Lines
Streetcar','Trains','[Link]','Gearbox Collectibles','8601','26.72','62.14'),
('S32_3522','1996 Peterbilt 379 Stake Bed with Outrigger','Trucks and
Buses','[Link]','Red Start Diecast','814','33.61','64.64'),('S32_4289','1928
Ford Phaeton Deluxe','Vintage Cars','[Link]','Highway 66 Mini
Classics','136','33.02','68.79'),('S32_4485','1974 Ducati 350 Mk3
Desmo','Motorcycles','[Link]','Second Gear Diecast','3341','56.13','102.05'),
('S50_1341','1930 Buick Marquette Phaeton','Vintage Cars','[Link]','Studio M Art
Models','7062','27.06','43.64'),('S50_1392','Diamond T620 Semi-Skirted
Tanker','Trucks and Buses','[Link]','Highway 66 Mini
Classics','1016','68.29','115.75'),('S50_1514','1962 City of Detroit
Streetcar','Trains','[Link]','Classic Metal Creations','1645','37.49','58.58'),
('S50_4713','2002 Yamaha YZR M1','Motorcycles','[Link]','Autoart Studio
Design','600','34.17','81.36'),('S700_1138','The Schooner
Bluenose','Ships','0.527777777777778','Autoart Studio Design','1897','34','66.67'),
('S700_1691','American Airlines: B767-300','Planes','0.527777777777778','Min Lin
Diecast','5841','51.15','91.34'),('S700_1938','The
Mayflower','Ships','0.527777777777778','Studio M Art Models','737','43.3','86.61'),
('S700_2047','HMS Bounty','Ships','0.527777777777778','Unimax Art
Galleries','3501','39.83','90.52'),('S700_2466','America West Airlines B757-
200','Planes','0.527777777777778','Motor City Art Classics','9653','68.8','99.72'),
('S700_2610','The USS Constitution Ship','Ships','0.527777777777778','Red Start
Diecast','NULL',' NULL','NULL'),('S700_2824','1982 Camaro Z28','Classic
Cars','[Link]','Carousel DieCast Legends','6934','46.53','101.15'),
('S700_2834','ATA: B757-300','Planes','0.527777777777778','Highway 66 Mini
Classics','7106','59.33','118.65'),('S700_3167','F/A 18 Hornet
1/72','Planes','0.0916666666666667','Motor City Art Classics','551','54.4','80'),
('S700_3505','The Titanic','Ships','0.527777777777778','Carousel DieCast
Legends','1956','51.09','100.17'),('S700_3962','The Queen
Mary','Ships','0.527777777777778','Welly Diecast
Productions','5088','53.63','99.31'),('S700_4002','American Airlines: MD-
11S','Planes','0.527777777777778','Second Gear Diecast','8820','36.27','74.03'),
('S72_1253','Boeing X-32A JSF','Planes','0.0916666666666667','Motor City Art
Classics','4857','32.77','49.66'),('S72_3212','Pont
Yacht','Ships','0.0916666666666667','Unimax Art Galleries','414','33.3','54.6');

-- Print the first 5 entries of "employees" tables.

select * from employees limit 5;

-- Print the first 5 entries of "offices" tables.

select * from offices limit 5;

-- Print the first 5 entries of "customers" tables.

select * from customers limit 5;

-- Print the first 5 entries of "orders" tables.

select * from orders limit 5;

-- Print the first 5 entries of "orderdetails" tables.

select * from orderdetails limit 5;

-- Print the first 5 entries of "payments" tables.

select * from payments limit 5;

-- Print the first 5 entries of "products" tables.

select * from products limit 5;

-- Print the first 5 entries of "productlines" tables.

select * from productlines limit 5;

-- Section 1

-- Q-1: Which month has received the maximum aggregate payments from the customers,
along with the aggregated value of the payment of that month?

-- select payments, sum (amount) from

select paymentDate as dt ,sum(amount) as total_payment

 from payments
group by dt
order by total_payment desc
limit 1;

-- Q-2: What is the shipped date of the maximum quantity ordered for the product
name '1968 Ford Mustang'?

select * from

-- Q-3: What is the average credit limit for Singapore from "customers" table?

select * from orders limit 5;

select * from products limit 5;
select * from orderdetails limit 5;

select * from orderdetails od

join products p
on [Link] = [Link]
where [Link] = '1968 Ford mustang';
join [Link]

-- inner join: shows data from both tables (comman)

-- left join show left side value and right side matching
-- right join shows right side vallue and left side matching
-- full join shows union