Advertisement
Guest User

Untitled

a guest
Oct 17th, 2019
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.48 KB | None | 0 0
  1. *********Customers*********
  2.  
  3. INSERT INTO customers(ID, customerName, contactLastName, contactFirstName, phone, address, city, state, postalCode, creditLimit, salesRepEmployeeID)
  4. VALUES
  5. (33,'Signal Gift Stores','King','Jean','7025551838','8489 Strong St.','Las Vegas','NV','83030','71800.00','17'),
  6. (34,'Mini Gifts Distributors Ltd.','Nelson','Susan','4155551450','5677 Strong St.','San Rafael','CA','97562','210500.00','16'),
  7. (35,'Mini Wheels Co.','Murphy','Julie','6505555787','5557 North Pendale Street','San Francisco','CA','94217','64600.00','16'),
  8. (36,'Land of Toys Inc.','Lee','Kwai','2125557818','897 Long Airport Avenue','NYC','NY','10022','114900.00','21'),
  9. (37,'Muscle Machine Inc','Young','Jeff','2125557413','4092 Furth Circle','NYC','NY','10022','138500.00','20'),
  10. (38,'Diecast Classics Inc.','Leong','Kelvin','2155551555','7586 Pompton St.','Allentown','PA','70267','100600.00','19'),
  11. (39,'Technics Stores Inc.','Hashimoto','Juri','6505556809','9408 Furth Circle','Burlingame','CA','94217','84600.00','16'),
  12. (40,'American Souvenirs Inc','Franco','Keith','2035557845','149 Spinnaker Dr.','New Haven','CT','97823','0.00','20'),
  13. (41,'Cambridge Collectables Co.','Tseng','Jerry','6175555555','4658 Baden Av.','Cambridge','MA','51247','43400.00','18'),
  14. (42,'Gift Depot Inc.','King,Julie','2035552570','25593 South Bay Ln.','Bridgewater','CT','97562','84300.00','21'),
  15. (43,'Vitachrome Inc.','Frick','Michael','2125551500','2678 Kingston Rd.','NYC','NY','10022','76400.00','20'),
  16. (44,'Auto-Moto Classics Inc.','Taylor','Leslie','6175558428','16780 Pompton St.','Brickhaven','MA','58339','23000.00','19'),
  17. (45,'Online Mini Collectables','Barajas','Miguel','6175557555','7635 Spinnaker Dr.','Brickhaven','MA','58339','68700.00','18'),
  18. (46,'Toys4GrownUps.com','Young','Julie','6265557265','78934 Hillside Dr.','Pasadena','CA','90003','90700.00','17'),
  19. (47,'Boards & Toys Co.','Young','Mary','3105552373','4097 Douglas Av.','Glendale','CA','92561','11000.00','17'),
  20. (48,'Collectable Mini Designs Co.','Thompson','Valarie','7605558146','361 Furth Circle','San Diego','CA','91217','105000.00','17'),
  21. (49,'Marta\s Replicas Co.','Hernandez','Marta','6175558555','39323 Spinnaker Dr.','Cambridge','MA','51247','123700.00','19'),
  22. (50,'Mini Classics','Frick','Steve','9145554562','3758 North Pendale Street','White Plains','NY','24067','102700.00','21'),
  23. (51,'Mini Creations Ltd.','Huang','Wing','5085559555','4575 Hillside Dr.','New Bedford','MA','50553','94500.00','18'),
  24. (52,'Corporate Gift Ideas Co.','Brown','Julie','6505551386','7734 Strong St.','San Francisco','CA','94217','105000.00','16'),
  25. (53,'Tekni Collectables Inc.','Brown','William','2015559350','7476 Moss Rd.','Newark','NJ','94019','43000.00','21'),
  26. (54,'Classic Gift Ideas, Inc','Cervantes','Francisca','2155554695','782 First Street','Philadelphia','PA','71270','81100.00','18'),
  27. (55,'Men \R\ US Retailers, Ltd.','Chandler','Brian','2155554369','6047 Douglas Av.','Los Angeles','CA','91003','57700.00','17'),
  28. (56,'Gifts4AllAges.com','Yoshido','Juri','6175559555','8616 Spinnaker Dr.','Boston','MA','51003','41900.00','19'),
  29. (57,'Online Diecast Creations Co.','Young','Dorothy','6035558647','2304 Long Airport Avenue','Nashua','NH','62005','114200.00','19'),
  30. (58,'Collectables For Less Inc.','Nelson','Allen','6175558555','7825 Douglas Av.','Brickhaven','MA','58339','70700.00','19'),
  31. (59,'Classic Legends Inc.','Hernandez','Maria','2125558493','5905 Pompton St.','NYC','NY','10022','67500.00','20'),
  32. (60,'Gift Ideas Corp.','Lewis','Dan','2035554407','2440 Pompton St.','Glendale','CT','97561','49700.00','21'),
  33. (61,'The Sharp Gifts Warehouse','Frick','Sue','4085553659','3086 Ingle Ln.','San Jose','CA','94217','77600.00','16'),
  34. (62,'Super Scale Inc.','Murphy','Leslie','2035559545','567 North Pendale Street','New Haven','CT','97823','95400.00','20'),
  35. (63,'Microscale Inc.','Choi','Yu','2125551957','5290 North Pendale Street','NYC','NY','10022','39800.00','20'),
  36. (64,'FunGiftIdeas.com','Benitez','Violeta','5085552555','1785 First Street','New Bedford','MA','50553','85800.00','19'),
  37. (65,'West Coast Collectables Co.','Thompson','Steve','3105553722','3675 Furth Circle','Burbank','CA','94019','55400.00','17'),
  38. (66,'Motor Mint Distributors Inc.','Salazar','Rosa','2155559857','11328 Douglas Av.','Philadelphia','PA','71270','72600.00','21'),
  39. (67,'Signal Collectibles Ltd.','Taylor','Sue','4155554312','2793 Furth Circle','Brisbane','CA','94217','60300.00','16'),
  40. (68,'Diecast Collectables','Franco','Valarie','6175552555','6251 Ingle Ln.','Boston','MA','51003','85100.00','18');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement