Insert rows into tables
SHOW DATABASES;
USE transportation;
INSERT INTO orders (orderDate, requiredDate, shippedDate, status, comments, customerID) VALUES
('2019-05-31','2019-06-08',NULL,'In Process',NULL,67),
('2019-05-31','2019-06-07',NULL,'In Process',NULL,67),
('2019-05-30','2019-06-11',NULL,'In Process',NULL,67),
('2019-05-30','2019-06-05',NULL,'In Process',NULL,67),
('2019-05-29','2019-06-07',NULL,'In Process',NULL,47),
('2019-05-29','2019-06-06',NULL,'In Process','Custom shipping instructions were sent to warehouse',34),
('2019-05-17','2019-05-28','2019-05-19','Shipped',NULL,47),
('2019-05-16','2019-05-24','2019-05-20','Shipped',NULL,34),
('2019-05-13','2019-05-19','2019-05-19','Disputed','Customer doesn\'t like the colors and precision of the models.',47),
('2019-05-10','2019-05-16','2019-05-14','Shipped',NULL,34),
('2019-05-09','2019-05-20','2019-05-12','Disputed','Customer claims the scales of the models don\'t match what was discussed. I keep all the paperwork though to prove otherwise',55),
('2019-05-06','2019-05-13',NULL,'On Hold','Customer credit limit exceeded. Will ship when a payment is received.',34),
('2019-05-05','2019-05-14','2019-05-09','Shipped','Customer requested that DHL is used for this shipping',55),
('2019-05-03','2019-05-13','2019-05-05','Shipped',NULL,34),
('2019-05-01','2019-05-08','2019-05-06','Shipped',NULL,55),
('2019-04-29','2019-05-10','2019-04-30','Shipped',NULL,65),
('2019-04-23','2019-05-05','2019-04-24','Shipped',NULL,63),
('2019-04-22','2019-05-04',NULL,'On Hold','Customer credit limit exceeded. Will ship when a payment is received.',61),
('2019-04-22','2019-04-29','2019-04-27','Shipped',NULL,59),
('2019-04-15','2019-04-25','2019-04-21','Disputed','Customer claims container with shipment was damaged during shipping and some items were missing. I am talking to FedEx about this.',57),
('2019-04-14','2019-04-24','2019-04-20','Shipped',NULL,55),
('2019-04-08','2019-04-18','2019-04-11','Shipped',NULL,51),
('2019-04-08','2019-04-14','2019-04-11','Shipped',NULL,49),
('2019-04-07','2019-04-14','2019-04-12','Shipped',NULL,47),
('2019-04-03','2019-04-14',NULL,'On Hold','Customer credit limit exceeded. Will ship when a payment is received.',45),
('2019-04-01','2019-04-12','2019-04-03','Shipped',NULL,43),
('2019-04-01','2019-04-11','2019-04-04','Shipped','Customer requested that DHL is used for this shipping',41),
('2019-03-30','2019-04-09','2019-03-31','Shipped',NULL,39),
('2019-03-28','2019-04-09','2019-04-01','Shipped',NULL,37),
('2019-03-23','2019-04-02','2019-03-28','Shipped',NULL,35),
('2019-03-17','2019-03-24','2019-03-23','Shipped','We must be cautions with this customer. Their VP of Sales resigned. Company may be heading down.',33),
('2019-03-15','2019-03-25','2019-03-19','Shipped',NULL,36),
('2019-03-11','2019-03-22','2019-03-14','Shipped','They want to reevaluate their terms agreement with Finance.',38),
('2019-03-10','2019-03-18','2019-03-12','Shipped',NULL,40),
('2019-03-09','2019-03-20','2019-03-15','Shipped',NULL,42),
('2019-03-04','2019-03-11','2019-03-07','Shipped','They want to reevaluate their terms agreement with Finance.',44),
('2019-03-03','2019-03-11','2019-03-09','Shipped',NULL,46),
('2019-03-03','2019-03-09','2019-03-08','Shipped',NULL,53),
('2019-03-02','2019-03-09','2019-03-06','Shipped','We need to keep in close contact with their Marketing VP. He is the decision maker for all their purchases.',50),
('2019-03-01','2019-03-09','2019-03-06','Resolved','Disputed then Resolved on 3/15/2019. Customer doesn\'t like the craftsmaship of the models.',52),
('2019-02-28','2019-03-09','2019-03-01','Shipped',NULL,54),
('2019-02-23','2019-03-06','2019-02-27','Shipped',NULL,56),
('2019-02-22','2019-03-02','2019-02-25','Shipped',NULL,58),
('2019-02-17','2019-02-25','2019-02-18','Shipped',NULL,60),
('2019-02-17','2019-02-23','2019-02-18','Shipped','Custom shipping instructions sent to warehouse',62),
('2019-02-16','2019-02-24','2019-02-18','Shipped',NULL,64),
('2019-02-10','2019-02-18','2019-02-11','Shipped',NULL,34),
('2019-02-10','2019-02-18','2019-02-11','Shipped',NULL,34),
('2019-02-09','2019-02-21','2019-02-12','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',68),
('2019-02-08','2019-02-18','2019-02-13','Shipped',NULL,68);