SHARE
TWEET

Untitled

a guest Apr 21st, 2019 69 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('1', 'John', 'Smith', 'MALE', '01/01/1990', '5555555555', '123 Main St', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  2. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('2', 'Kenneth', 'Parscale', 'MALE', '02/01/1991', '8776433906', '7902 Porta Av.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  3. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS) VALUES ('3', 'John', 'Goodman', 'MALE', '03/01/1992', '6787796798', '7076 Posuere, St', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  4. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('4', 'David', 'Davidson', 'MALE', '04/01/1993', '9245816615', '2985 Felis. Avenue', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  5. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('5', 'Katelyn', 'Smith', 'FEMALE', '05/01/1994', '8172472199', '6415 Mattis Rd', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  6. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('6', 'Lauren', 'Hart', 'FEMALE', '06/01/1995', '8768347257', '123 Main St', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  7. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('7', 'Brian', 'Brianson', 'MALE', '07/01/1996', '9231902541', '6640 Tellus Avenue', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  8. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('8', 'Jamie', 'Jamieson', 'MALE', '08/01/1997', '2319629517', '975 Orci. St.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  9. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('9', 'Nick', 'Nickieson', 'MALE', '09/01/1996', '8662497146', '480 Tortor Rd.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  10. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('10', 'Elliot', 'Moose', 'MALE', '10/01/1995', '7848093165', '22 Falcon Rd.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  11. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('11', 'Brianna', 'Moose', 'FEMALE', '11/01/1994', '7410462290', '11 Woodwine Rd.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  12. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('12', 'Julian', 'Lahey', 'MALE', '12/01/1993', '5617790841', '2191 Nunc Ave', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  13. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('13', 'Ricky', 'Lahey', 'MALE', '01/02/1992', '7734662258', '3952 Egestas Rd', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  14. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('14', 'Bubbles', 'Bubbleson', 'MALE', '021/03/1991', '9433162638', '6223 Magna Rd.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  15. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('15', 'Eugene', 'Smithers', 'MALE', '04/01/1989', '7913239039', '123 Skyline Dr.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  16. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('16', 'Marge', 'Simspon', 'FEMALE', '05/12/1988', '7364528343', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  17. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('17', 'Bart', 'Simspon', 'MALE', '04/12/1980', '7364528343', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  18. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('18', 'Homer', 'Simspon', 'MALE', '03/11/1980', '8821725673', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  19. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('19', 'Maggie', 'Simspon', 'FEMALE', '02/12/1981', '3756681985', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  20. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('20', 'Itchy', 'Simspon', 'MALE', '07/08/1982', '3906613121', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  21. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('21', 'Scratchy', 'Simspon', 'MALE', '08/09/1983', '7153600202', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  22. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('22', 'Poochy', 'Simspon', 'MALE', '10/01/1984', '3775935479', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  23. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('23', 'Magnus', 'Pompey', 'MALE', '02/01/1985', '4732581091', '7706 Bridgeton Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  24. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('24', 'Biggus', 'Diccus', 'MALE', '03/01/1986', '4538628118', '676 Randall Mill Dr.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  25. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('25', 'Julius', 'Caesar', 'MALE', '10/01/1987', '6530531105', '8 Lyme Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  26. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('26', 'Monty', 'Python', 'MALE', '09/01/1987', '3841041135', '3 Howard Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  27. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('27', 'Elliot', 'Broidy', 'MALE', '08/01/1988', '7439241138', '386 Lake Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  28. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('28', 'Please', 'Help', 'MALE', '07/01/1970', '7930040634', '472 County Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  29. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('29', 'Falco', 'Lombardi', 'MALE', '06/01/1971', '1666492994', '8611 Arnold St.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  30. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('30', 'TJ', 'Yoshi', 'MALE', '051/01/1971', '9016640028', '480 Tortor Rd.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  31. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('31', 'Zelda', 'Link', 'FEMALE', '04/01/1972', '3227391748', '751 High St.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  32. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('32', 'Bowser', 'Koopa', 'MALE', '03/01/1973', '7301425292', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  33. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('33', 'Roy', 'Koopa', 'MALE', '02/01/1973', '7552775333', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  34. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('34', 'Iggy', 'Koopa', 'MALE', '01/01/1990', '2407976101', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  35. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('35', 'Lemmy', 'Koopa', 'MALE', '12/01/1990', '9671929720', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  36. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('36', 'Ludwig', 'Koopa', 'MALE', '11/01/1990', '5614671084', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  37. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('37', 'Mario', 'Luigi', 'MALE', '11/01/1982', '1594854682', '410 Blue Spring Court', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  38. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('38', 'Gannondorf', 'Zelda', 'MALE', '10/01/1981', '3501023577', '480 Tortor Rd.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  39. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('39', 'Palutena', 'Pit', 'FEMALE', '09/01/1980', '8764799664', '929 Ketch Harbour St.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  40. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('40', 'Ken', 'Masters', 'MALE', '08/01/1979', '4437033597', '859 Windfall Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  41. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('41', 'Phoenix', 'Wright', 'MALE', '07/01/1978', '5361074114', '855 University Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  42. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('42', 'Maya', 'Masters', 'MALE', '06/01/19968', '4789360248', '9659 Circle Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  43. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('43', 'Scar', 'Toph', 'MALE', '05/01/1967', '9329835955', '7559 Peninsula Lane', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  44. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('44', 'Jason', 'Zimmerman', 'MALE', '04/01/1966', '8129149333', '542 Talbot Court', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  45. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('45', 'Hatsune', 'Miku', 'FEMALE', '03/01/1965', '0803351285', '38 Redwood Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  46. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('46', 'Ayanami', 'Rei', 'FEMALE', '02/01/1964', '5691633391', '13 N. Chestnut Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  47. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('47', 'Hakurei', 'Reimu', 'FEMALE', '01/01/1963', '1367586031', '9697 Elizabeth Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  48. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('48', 'Remilia', 'Scarlet', 'FEMALE', '12/01/1962', '1156099419', '659 Thatcher St.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  49. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('49', 'Flandre', 'Scarlet', 'FEMALE', '11/01/1961', '2236675817', '9688 Westminster Street ', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  50. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('50', 'Alice', 'Margatroid', 'FEMALE', '04/01/1960', '7307348370', '8627 Depot Dr.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  51. INSERT INTO "DOCTOR" (DOCTOR_ID, FIRST_NAME, LAST_NAME) VALUES ('1', 'Jeff ', 'Pratee');
  52. INSERT INTO "DOCTOR" (DOCTOR_ID, FIRST_NAME, LAST_NAME) VALUES ('2', 'Brett ', 'Pratee');
  53. INSERT INTO "DOCTOR" (DOCTOR_ID, FIRST_NAME, LAST_NAME) VALUES ('3', 'Brian ', 'Pratee');
  54. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('1', '1', '1', 'Exam and glasses', '01/01/2019');
  55. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('2', '2', '2', 'Exam and glasses', '01/01/2019');
  56. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('3', '3', '3', 'Styes', '01/01/2019');
  57. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('4', '1', '4', 'Pink eye', '01/01/2019');
  58. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('5', '2', '5', 'Exam and contacts', '01/02/2019');
  59. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('6', '1', '6', 'Exam and glasses', '01/02/2019');
  60. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('7', '1', '7', 'Exam and glasses', '01/02/2019');
  61. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('8', '1', '8', 'Exam', '01/02/2019');
  62. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('9', '2', '9', 'Styes', '01/03/2019');
  63. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('10', '1', '10', 'Exam', '01/03/2019');
  64. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('11', '1', '1', 'Exam and glasses', '01/03/2019');
  65. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('12', '3', '11', 'Exam and glasses', '01/03/2019');
  66. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('13', '1', '12', 'Exam and glasses', '01/04/2019');
  67. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('14', '2', '13', 'Pink eye', '01/06/2019');
  68. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('15', '1', '14', 'Pink eye', '01/06/2019');
  69. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('16', '1', '15', 'Exam and contacts', '01/07/2019');
  70. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('17', '3', '16', 'Exam and contacts', '01/07/2019');
  71. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('18', '2', '17', 'Exam and contacts', '01/07/2019');
  72. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('19', '1', '18', 'Exam and glasses', '01/08/2019');
  73. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('20', '1', '19', 'Exam', '01/08/2019');
  74. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('21', '1', '20', 'Exam', '01/9/2019');
  75. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('22', '2', '2', 'Follow up', '01/09/2019');
  76. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('23', '1', '21', 'Exam and glasses', '01/09/2019');
  77. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('24', '1', '22', 'Exam and glasses', '01/10/2019');
  78. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('25', '1', '23', 'Pink eye', '01/10/2019');
  79. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('26', '1', '24', 'Exam and glasses', '01/11/2019');
  80. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('27', '2', '25', 'Exam and contacts', '01/11/2019');
  81. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('28', '1', '26', 'Styes', '01/11/2019');
  82. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('29', '1', '27', 'Exam and contacts', '01/13/2019');
  83. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('30', '1', '28', 'Exam', '01/14/2019');
  84. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('31', '3', '29', 'Pink eye', '01/14/2019');
  85. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('32', '2', '30', 'Pink eye', '01/14/2019');
  86. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('33', '1', '3', 'Follow up', '01/15/2019');
  87. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('34', '1', '31', 'Exam and contacts', '01/15/2019');
  88. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('35', '3', '32', 'Exam and contacts', '01/15/2019');
  89. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('36', '1', '33', 'Exam and glasses', '01/15/2019');
  90. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('37', '1', '34', 'Exam and glasses', '01/15/2019');
  91. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('38', '2', '35', 'Exam and glasses', '01/16/2019');
  92. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('39', '1', '36', 'Exam and glasses', '01/16/2019');
  93. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('40', '1', '4', 'Follow up', '01/17/2019');
  94. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('41', '2', '37', 'Exam', '01/17/2019');
  95. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('42', '2', '38', 'Styes', '01/17/2019');
  96. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('43', '1', '39', 'Pink eye', '01/17/2019');
  97. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('44', '2', '40', 'Styes', '01/18/2019');
  98. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('45', '1', '5', 'Follow up', '01/18/2019');
  99. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('46', '1', '41', 'Exam and glasses', '01/18/2019');
  100. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('47', '3', '42', 'Exam and glasses', '01/18/2019');
  101. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('48', '1', '43', 'Exam and glasses', '01/18/2019');
  102. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('49', '1', '44', 'Exam and glasses', '01/20/2019');
  103. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('50', '1', '6', 'Follow up', '01/20/2019');
  104. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('51', '2', '45', 'Exam and glasses', '01/20/2019');
  105. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('52', '1', '46', 'Exam and glasses', '01/20/2019');
  106. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('53', '3', '47', 'Exam and glasses', '01/20/2019');
  107. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('54', '2', '48', 'Exam and glasses', '01/21/2019');
  108. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('55', '1', '7', 'Follow up', '01/21/2019');
  109. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('56', '2', '49', 'Exam and glasses', '01/21/2019');
  110. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('57', '1', '50', 'Exam and glasses', '01/22/2019');
  111. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('58', '2', '8', 'Follow up', '01/22/2019');
  112. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('59', '1', '21', 'Pink eye', '01/22/2019');
  113. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('60', '2', '22', 'Follow up', '01/22/2019');
  114. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('61', '1', '26', 'Exam and glasses', '01/22/2019');
  115. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('62', '3', '13', 'Exam and contacts', '01/23/2019');
  116. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('63', '1', '27', 'Exam and contacts', '01/23/2019');
  117. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('64', '1', '35', 'Styes', '01/23/2019');
  118. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('65', '1', '12', 'Exam and contacts', '01/23/2019');
  119. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('1', '1', '3', '01/01/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes daily');
  120. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('2', '1', '9', '01/03/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  121. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('3', '1', '26', '01/11/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  122. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('4', '1', '38', '01/17/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  123. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('5', '1', '40', '01/18/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  124. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('6', '1', '35', '01/23/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  125. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('7', '1', '29', '01/14/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes daily');
  126. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('8', '1', '30', '01/14/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  127. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('9', '1', '39', '01/17/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  128. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('10', '1', '21', '01/22/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  129. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('11', '1', '4', '01/01/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  130. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('12', '1', '23', '01/10/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  131. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('13', '1', '13', '01/06/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  132. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('14', '1', '14', '01/06/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  133.  
  134. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('1', 'Horizon', '365479510', '208981', 'PPO',  '5');
  135. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('2', 'Aetna', '703558595', '775337', 'PPO',  '10');
  136. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('3', 'UnitedHealth', '105531242', '221028', 'PPO',  '15');
  137. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('4', 'Wellpoint', '837353127', '225905', 'PPO',  '20');
  138. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('5', 'Humana', '418953014', '160854', 'PPO',  '5');
  139. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('6', 'Cigna', '956401511', '706116', 'PPO',  '10');
  140. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('7', 'Highmark', '158540167', '441169', 'PPO',  '15');
  141. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('8', 'Horizon', '401837495', '506288', 'PPO',  '20');
  142. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('9', 'Horizon', '968496026', '738471', 'PPO',  '25');
  143. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('10', 'Aetna', '344427508', '442847', 'PPO',  '30');
  144. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('11', 'Cigna', '512077006', '850070', 'PPO',  '5');
  145. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('12', 'Humana', '904470553', '224729', 'PPO',  '10');
  146. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('13', 'Highmark', '544551519', '901032', 'PPO',  '15');
  147. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('14', 'UnitedHealth', '135956812', '514547', 'PPO',  '20');
  148. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('15', 'UnitedHealth', '567025086', '205491', 'PPO',  '25');
  149. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('16', 'Horizon', '152633703', '595839', 'PPO',  '30');
  150. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('17', 'Horizon', '366721520', '851247', 'PPO',  '5');
  151. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('18', 'UnitedHealth', '318365256', '529992', 'PPO',  '10');
  152. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('19', 'UnitedHealth', '585963750', '600755', 'PPO',  '15');
  153. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('20', 'Aetna', '832377105', '404144', 'PPO',  '25');
  154. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('21', 'Horizon', '593746868', '265489', 'PPO',  '30');
  155. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('22', 'Aetna', '318365256', '241894', 'PPO',  '35');
  156. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('23', 'Aetna' '604584439', '672387', 'PPO',  '40');
  157. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('24', 'Aetna', '567025086', '211244', 'PPO',  '5');
  158. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('25', 'Humana', '016515710', '005811', 'PPO',  '10');
  159. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('26', 'Humana', '613292968', '972479', 'PPO',  '15');
  160. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('27', 'Humana', '721073099', '074033', 'PPO',  '20');
  161. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('28', 'Horizon', '666608907', '645118', 'PPO',  '25');
  162. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('29', 'Aetna', '056172817', '761152', 'PPO',  '30');
  163. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('30', 'Highmark', '560466689', '454562', 'PPO',  '35');
  164. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('31', 'Horizon', '283714808', '138172', 'PPO',  '40');
  165. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('32', 'Horizon', '608607848', '594904', 'PPO', '5');
  166. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('33', 'Horizon', '714883203', '045306', 'PPO', '5');
  167. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('34', 'Highmark', '135145899', '539820', 'PPO', '10');
  168. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('35', 'Highmark', '828140452', '500051', 'PPO', '15');
  169. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('36', 'Highmark', '048754237', '910431', 'PPO', '25');
  170. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('37', 'Horizon', '423418545', '709663', 'PPO', '15');
  171. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('38', 'Horizon', '307190508', '904862', 'PPO', '15');
  172. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('39', 'Humana' '380417854', '755546', 'PPO', '25');
  173. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('40', 'Horizon', '166022266', '051370', 'PPO', '30');
  174. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('41', 'Humana', '765477489', '977369', 'PPO', '10');
  175. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('42', 'Horizon', '053109214', '882102', 'PPO', '15');
  176. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('43', 'Aetna', '406786530', '120667', 'PPO', '25');
  177. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('44', 'Aetna', '547443631', '922265', 'PPO', '30');
  178. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('45', 'Horizon', '968715335', '595064', 'PPO', '20');
  179. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('46', 'Horizon', '547443631', '427404', 'PPO', '5');
  180. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('47', 'Horizon', '228863395', '918364', 'PPO', '10');
  181. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('48', 'UnitedHealth', '474025850', '219260', 'PPO', '15');
  182. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('49', 'UnitedHealth', '353046702', '682128', 'PPO', '20');
  183. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('50', 'Humana', '004804954', '624231', 'PPO', '25');
  184. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('1', 'Vision Plan America', '365479510', '208981', 'PPO');
  185. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('2', 'Aetna', '703558595', '775337', 'PPO');
  186. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('3', 'UnitedHealth', '105531242', '221028', 'PPO');
  187. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('4', 'Wellpoint', '837353127', '225905', 'PPO');
  188. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('5', 'Humana', '418953014', '160854', 'PPO');
  189. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('6', 'Davis Vision', '956401511', '706116', 'PPO');
  190. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('7', 'Vision Plan America', '158540167', '441169', 'PPO');
  191. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('8', 'Horizon', '401837495', '506288', 'PPO');
  192. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('9', 'Horizon', '968496026', '738471', 'PPO');
  193. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('10', 'Aetna', '344427508', '442847', 'PPO');
  194. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('11', 'Davis Vision', '512077006', '850070', 'PPO');
  195. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('12', 'Humana', '904470553', '224729', 'PPO');
  196. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('13', 'Vision Plan America', '544551519', '901032', 'PPO');
  197. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('14', 'UnitedHealth', '135956812', '514547', 'PPO');
  198. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('15', 'UnitedHealth', '567025086', '205491', 'PPO');
  199. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('16', 'Horizon', '152633703', '595839', 'PPO');
  200. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('17', 'Horizon', '366721520', '851247', 'PPO');
  201. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('18', 'UnitedHealth', '318365256', '529992', 'PPO');
  202. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('19', 'UnitedHealth', '585963750', '600755', 'PPO');
  203. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('20', 'Aetna', '832377105', '404144', 'PPO');
  204. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('21', 'Horizon', '593746868', '265489', 'PPO',);
  205. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('22', 'Aetna', '318365256', '241894', 'PPO');
  206. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('23', 'Aetna', '604584439', '672387', 'PPO');
  207. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('24', 'Aetna', '567025086', '211244', 'PPO');
  208. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('25', 'Humana', '016515710', '005811', 'PPO');
  209. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('26', 'Humana', '613292968', '972479', 'PPO');
  210. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('27', 'Humana', '721073099', '074033', 'PPO');
  211. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('28', 'Horizon', '666608907', '645118', 'PPO');
  212. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('29', 'Aetna', '056172817', '761152', 'PPO');
  213. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('30', 'Vision Plan America', '560466689', '454562', 'PPO');
  214. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('31', 'Horizon', '283714808', '138172', 'PPO');
  215. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('32', 'Horizon', '608607848', '594904', 'PPO');
  216. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('33', 'Horizon', '714883203', '045306', 'PPO');
  217. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('34', 'Vision Plan America', '135145899', '539820', 'PPO');
  218. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('35', 'Vision Plan Americak', '828140452', '500051', 'PPO');
  219. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('36', 'Vision Plan America', '048754237', '910431', 'PPO'
  220. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('37', 'Horizon', '423418545', '709663', 'PPO');
  221. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('38', 'Horizon', '307190508', '904862', 'PPO');
  222. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('39', 'Humana' '380417854', '755546', 'PPO');
  223. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('40', 'Horizon', '166022266', '051370', 'PPO');
  224. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('41', 'Humana', '765477489', '977369', 'PPO');
  225. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('42', 'Horizon', '053109214', '882102', 'PPO');
  226. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('43', 'Aetna', '406786530', '120667', 'PPO');
  227. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('44', 'Aetna', '547443631', '922265', 'PPO');
  228. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('45', 'Horizon', '968715335', '595064', 'PPO');
  229. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('46', 'Horizon', '547443631', '427404', 'PPO');
  230. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('47', 'Horizon', '228863395', '918364', 'PPO');
  231. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('48', 'UnitedHealth', '474025850', '219260', 'PPO');
  232. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('49', 'UnitedHealth', '353046702', '682128', 'PPO');
  233. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('50', 'Humana', '004804954', '624231', 'PPO');
  234. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('1', '3', '01/01/2019', '9.99');
  235. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('2', '9', '01/03/2019', '9.99');
  236. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('3', '26', '01/11/2019', '9.99');
  237. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('4', '38', '01/17/2019', '12.99');
  238. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('5', '40', '01/18/2019', '12.99');
  239. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('6', '35', '01/23/2019', '12.99');
  240. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('7', '29', '01/14/2019', '12.99');
  241. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('8', '30', '01/14/2019', '9.99');
  242. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('9', '39', '01/17/2019', '9.99');
  243. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('10', '21', '01/22/2019', '9.99');
  244. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('11', '4', '01/01/2019', '9.99');
  245. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('12', '23', '01/10/2019', '9.99');
  246. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('13', '13', '01/06/2019', '9.99');
  247. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('14', '14', '01/06/2019', '9.99');
  248. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('15', '1', '01/06/2019', '9.99');
  249. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('16', '1', '01/01/2019', '290.00');
  250. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('17', '2', '01/01/2019', '280.00');
  251. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('18', '6', '01/02/2019', '270.00');
  252. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('19', '7', '01/02/2019', '300.00');
  253. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('20', '11', '01/03/2019', '300.00');
  254. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('21', '18', '01/08/2019', '300.00');
  255. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('22', '21', '01/09/2019', '300.00');
  256. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('23', '22', '01/10/2019', '300.00');
  257. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('24', '24', '01/11/2019', '290.00');
  258. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('25', '33', '01/15/2019', '290.00');
  259. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('26', '34', '01/15/2019', '290.00');
  260. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('27', '35', '01/16/2019', '290.00');
  261. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('28', '36', '01/16/2019', '290.00');
  262. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('29', '41', '01/18/2019', '290.00');
  263. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('30', '42', '01/18/2019', '280.00');
  264. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('31', '43', '01/18/2019', '280.00');
  265. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('32', '44', '01/20/2019', '280.00');
  266. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('33', '45', '01/20/2019', '280.00');
  267. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('34', '46', '01/20/2019', '280.00');
  268. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('35', '47', '01/20/2019', '280.00');
  269. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('36', '48', '01/21/2019', '280.00');
  270. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('37', '49', '01/21/2019', '280.00');
  271. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('38', '50', '01/22/2019', '280.00');
  272. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('39', '22', '01/09/2019', '26.00');
  273. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('40', '26', '01/11/2019', '26.00');
  274. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('41', '5', '01/02/2019', '27.00');
  275. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('42', '15', '01/07/2019', '28.00');
  276. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('43', '16', '01/07/2019', '29.00');
  277. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('44', '17', '01/07/2019', '27.00');
  278. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('45', '25', '01/11/2019', '30.00');
  279. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('46', '27', '01/13/2019', '31.00');
  280. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('47', '31', '01/15/2019', '30.00');
  281. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('48', '32', '01/15/2019', '31.00');
  282. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('49', '27', '01/13/2019', '31.00');
  283. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('50', '12', '01/04/2019', '31.00');
  284. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('1', '1', '3');
  285. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('2', '1', '3');
  286. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('3', '1', '3');
  287. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('4', '1', '4');
  288. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('5', '1', '4');
  289. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('6', '1', '4');
  290. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('7', '1', '4');
  291. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('8', '1', '3');
  292. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('9', '1', '3');
  293. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('11', '1', '3');
  294. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('12', '1', '3');
  295. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('13', '1', '3');
  296. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('14', '1', '3');
  297. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('15', '1', '3');
  298. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('16', '3', '1');
  299. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('17', '4', '1');
  300. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('18', '5', '1');
  301. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('19', '2', '1');
  302. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('20', '2', '1');
  303. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('21', '2', '1');
  304. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('22', '2', '1');
  305. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('23', '2', '1');
  306. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('24', '3', '1');
  307. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('25', '3', '1');
  308. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('26', '3', '1');
  309. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('27', '3', '1');
  310. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('28', '3', '1');
  311. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('29', '3', '1');
  312. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('30', '4', '1');
  313. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('31', '4', '1');
  314. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('32', '4', '1');
  315. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('33', '4', '1');
  316. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('34', '4', '1');
  317. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('35', '4', '1');
  318. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('36', '4', '1');
  319. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('37', '4', '1');
  320. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('38', '4', '1');
  321. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('39', '6', '1');
  322. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('40', '6', '1');
  323. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('41', '7', '1');
  324. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('42', '8', '1');
  325. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('43', '9', '1');
  326. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('44', '7', '1');
  327. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('45', '10', '1');
  328. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('46', '11', '1');
  329. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('47', '10', '1');
  330. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('48', '11', '1');
  331. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('49', '11', '1');
  332. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('50', '11', '1');
  333. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE) VALUES ('1', 'Eyelid Scrubs', 'Clean your eyes', '3.33', '1');
  334. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, FRAMES_PRODUCT_ID) VALUES ('2', 'Frames', 'Glasses Frames', '300.00', '2', '1');
  335. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, FRAMES_PRODUCT_ID) VALUES ('3', 'Frames', 'Glasses Frames', '290.00', '2', '2');
  336. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, FRAMES_PRODUCT_ID) VALUES ('4', 'Frames', 'Glasses Frames', '280.00', '2', '3');
  337. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('5', 'Frames', 'Glasses Frames', '270.00', '2', '4');
  338. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('6', 'Contacts', 'Contacts', '26.00', '3', '1');
  339. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('7', 'Contacts', 'Contacts', '27.00', '3', '2');
  340. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('8', 'Contacts', 'Contacts', '28.00', '3', '3');
  341. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('9', 'Contacts', 'Contacts', '29.00', '3', '4');
  342. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('10', 'Contacts', 'Contacts', '30.00', '3', '5');
  343. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('11', 'Contacts', 'Contacts', '31.00', '3', '6');
  344. INSERT INTO "FRAMES" (PRODUCT_ID, BRAND, SIZE, COLOR, MATERIAL) VALUES ('2', 'Ray Ban', 'Regular', 'Grey', 'Matte');
  345. INSERT INTO "FRAMES" (PRODUCT_ID, BRAND, SIZE, COLOR, MATERIAL) VALUES ('3', 'Oakley', 'Regular', 'Black', 'Titanium');
  346. INSERT INTO "FRAMES" (PRODUCT_ID, BRAND, SIZE, COLOR, MATERIAL) VALUES ('4', 'Coach', 'Regular', 'Black', 'Zyl');
  347. INSERT INTO "FRAMES" (PRODUCT_ID, BRAND, SIZE, COLOR, MATERIAL) VALUES ('5', 'Versace', 'Regular', 'Grey', 'Matte');
  348. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('6', 'Acuve', 'Regular', 'Clear');
  349. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('7', 'Dailies', 'Regular', 'Clear');
  350. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('8', 'Softlens', 'Regular', 'Clear);
  351. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('9', 'Air Optix', 'Regular', 'Clear');
  352. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('10', 'Proclear', 'Regular', 'Clear');
  353. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('11', 'Bioinfinity', 'Regular', 'Clear');
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top