insert into checks values ('1', 'Ma Bell', '150', 'Have sons next time'); insert into checks values ('2', 'Reading R.R.', '245.34', 'Train to Chicago'); insert into checks values ('3', 'Ma Bell', '200.32', 'Celluar Phone'); insert into checks values ('4', 'Local Utilities', '98', 'Gas'); insert into checks values ('5', 'Joes Stale $ Dent', '150', 'Groceries'); insert into checks values ('6', 'Cash', '25', 'Wild Night Out'); insert into checks values ('7', 'Joans Gas', '25.1', 'Gas'); insert into deposits values ('1', 'Rich Uncle', '200', 'Take off Xmas list'); insert into deposits values ('2', 'Employer', '1000', '15 June Payday'); insert into deposits values ('3', 'Credit Union', '500', 'Loan'); insert into bikes values ('TREK 2300', '22.5', 'CARBON FIBER', '3500', 'RACING'); insert into bikes values ('BURLEY', '22', 'STEEL', '2000', 'TANDEM'); insert into bikes values ('GIANT', '19', 'STEEL', '1500','COMMUTER'); insert into bikes values ('FUJI', '20', 'STEEL', '500', 'TOURING'); insert into bikes values ('SPECIALIZED', '16', 'STEEL', '100', 'MOUNTAIN'); insert into bikes values ('CANNONDALE', '22.5', 'ALUMINUM', '3000', 'RACING'); insert into price values ('TOMATOES', '.34'); insert into price values ('POTATOES', '.51'); insert into price values ('BANANAS', '.67'); insert into price values ('TURNIPS', '.45'); insert into price values ('CHEESE', '.89'); insert into price values ('APPLES', '.23'); insert into hilow values ('CA', '-50', '120',null); insert into hilow values ('FL', '20', '110',null); insert into hilow values ('LA', '15', '99',null); insert into hilow values ('ND', '-70', '101',null); insert into hilow values ('NE', '-60', '100',null); insert into remains values ('10', '5'); insert into remains values ('8', '3'); insert into remains values ('23', '9'); insert into remains values ('40', '17'); insert into remains values ('1024', '16'); insert into remains values ('85', '34'); insert into precedence values ('1', '2', '3', '4'); insert into precedence values ('13', '24', '35', '46'); insert into precedence values ('9', '3', '23', '5'); insert into precedence values ('63', '2', '45', '3'); insert into precedence values ('7', '2', '1', '4'); insert into friends values ('BUNDY', 'AL', '100', '555-1111', 'IL', '22333'); insert into friends values ('MERRICK', 'BUD', '300', '555-6666', 'CO', '80212'); insert into friends values ('MAST', 'JD', '381', '555-6767', 'LA', '23456'); insert into friends values ('BULHER', 'FERRIS', '345', '555-3223', 'IL', '23332'); insert into parts values ('APPENDIX', 'MID-STOMACH', '1'); insert into parts values ('ADAMS APPLE', 'THROAT', '2'); insert into parts values ('HEART', 'CHEST', '3'); Insert into parts values ('SPINE', 'BACK', '4'); insert into parts values ('ANVIL', 'EAR', '5'); insert into parts values ('KIDNEY', 'MID-BACK', '6'); insert into vacation values ('ABLE', '101', '2', '4'); insert into vacation values ('BAKER', '104', '5', '23'); insert into vacation values ('BLEDSOE', '107', '8', '45'); insert into vacation values ('BOLIVAR', '233', '4', '80'); insert into vacation values ('BOLD', '210', '15', '100'); insert into vacation values ('COSTALES', '211', '10', '78'); insert into football values ('ABLE'); insert into football values ('BRAVO'); insert into football values ('CHARLIE'); insert into football values ('DECON'); insert into football values ('EXITOR'); insert into football values ('FUBAR'); insert into football values ('GOOBER'); insert into softball values ('ABLE'); insert into softball values ('BAKER'); insert into softball values ('CHARLIE'); insert into softball values ('DEAN'); insert into softball values ('EXITOR'); insert into softball values ('FALCONER'); insert into softball values ('GOOBER'); insert into teamstats values ('JONES', '1B', '145', '45', '34', '31', '8', '1', '5', '10'); insert into teamstats values ('DONKNOW', '3B', '175', '65', '23', '50', '10', '1', '4', '15'); insert into teamstats values ('WORLEY', 'LF', '157', '49', '15', '35', '8', '3', '3', '16'); insert into teamstats values ('DAVID', 'OF', '187', '70', '24', '48', '4', '0', '17', '42'); insert into teamstats values ('HAMHOCKER', '3B', '50', '12', '10', '10', '2', '0', '0', '13'); insert into teamstats values ('CASEY', 'DH', '1', '0', '0', '0', '0', '0', '0', '1'); insert into project values ('KICKOFF MTG', '01-APR-98', '01-APR-98'); insert into project values ('TECH SURVEY', '02-APR-98', '01-MAY-98'); insert into project values ('USER MTGS', '15-MAY-98', '30-MAY-98'); insert into project values ('DESIGN WIDGET', '01-JUN-98', '30-JUN-98'); insert into project values ('CODE WIDGET', '01-JUL-98', '02-SEP-98'); insert into project values ('TESTING', '03-SEP-98', '17-JAN-99'); insert into numbers values ('3.1415', '4'); insert into numbers values ('-45', '.707'); insert into numbers values ('5', '9'); insert into numbers values ('-57.667', '42'); insert into numbers values ('15', '55'); insert into numbers values ('-7.2', '5.3'); insert into characters values ('PURVIS', 'KELLY', 'A', '32'); insert into characters values ('TAYLOR', 'CHUCK', 'J', '67'); insert into characters values ('CHRISTINE', 'LAURA', 'C', '65'); insert into characters values ('ADAMS', 'FESTER', 'M', '87'); insert into characters values ('COSTALES', 'ARMANDO', 'A', '77'); insert into characters values ('KONG', 'MAJOR', 'G', '52'); insert into ssn_table values ('300431117'); insert into ssn_table values ('301457111'); insert into ssn_table values ('459789998'); insert into job_tbl values ('ALVIN SMITH', 'VICEPRESIDENT', 'MARKETING'); insert into `convert` values ('40', '95'); insert into `convert` values ('13', '23'); insert into `convert` values ('74', '68'); insert into puzzle values ('TYLER', 'BACKYARD'); insert into puzzle values ('MAJOR', 'KITCHEN'); insert into puzzle values ('SPEEDY', 'LIVING ROOM'); insert into puzzle values ('WALDO', 'GARAGE'); insert into puzzle values ('LADDIE', 'UTILITY CLOSET'); insert into puzzle values ('ARNOLD', 'TV ROOM'); insert into orgchart values ('ADAMS', 'RESEARCH', '34000.00', '34', '12'); insert into orgchart values ('WILKES', 'MARKETING', '31000.00', '40', '9'); insert into orgchart values ('STOKES', 'MARKETING', '36000.00', '20', '19'); insert into orgchart values ('MEZA', 'COLLECTIONS', '40000.00', '30', '27'); insert into orgchart values ('MERRICK', 'RESEARCH', '45000.00', '20', '17'); insert into orgchart values ('RICHARDSON', 'MARKETING', '42000.00', '25', '18'); insert into orgchart values ('FURY', 'COLLECTIONS', '35000.00', '22', '14'); insert into orgchart values ('PRECOURT', 'PR', '37500.00', '24', '24'); insert into customer values ('TRUE WHEEL', '550 HUSKER', 'NE', '58702', '555-4545', 'NONE'); insert into customer values ('BIKE SPEC', 'CPT SHRIVE', 'LA', '45678', '555-1234', 'NONE'); insert into customer values ('LE SHOPPE', 'HOMETOWN', 'KS', '54678', '555-1278', 'NONE'); insert into customer values ('AAA BIKE', '10 OLDTOWN', 'NE', '56784', '555-3421', 'JOHN-MGR'); insert into customer values ('JACKS BIKE', '24 EGLIN', 'FL', '34567', '555-2314', 'NONE'); insert into part values ('54', 'PEDALS', '54.25'); insert into part values ('42', 'SEATS', '24.50'); insert into part values ('46', 'TIRES', '15.25'); insert into part values ('23', 'MOUNTAIN BIKE', '350.45'); insert into part values ('76', 'ROAD BIKE', '530.00'); insert into part values ('10', 'TANDEM', '1200.00'); insert into orders values ('15-MAY-1996', 'TRUE WHEEL', '23', '6', 'PAID'); insert into orders values ('19-MAY-1996', 'TRUE WHEEL', '76', '3', 'PAID'); insert into orders values ('2-SEP-1996', 'TRUE WHEEL', '10', '1', 'PAID'); insert into orders values ('30-JUN-1996', 'TRUE WHEEL', '42', '8', 'PAID'); insert into orders values ('30-JUN-1996', 'BIKE SPEC', '54', '10', 'PAID'); insert into orders values ('30-MAY-1996', 'BIKE SPEC', '23', '8', 'PAID'); insert into orders values ('17-JAN-1996', 'BIKE SPEC', '76', '11', 'PAID'); insert into orders values ('17-JAN-1996', 'LE SHOPPE', '76', '5', 'PAID'); insert into orders values ('1-JUN-1996', 'LE SHOPPE', '10', '3', 'PAID'); insert into orders values ('1-JUN-1996', 'AAA BIKE', '10', '1', 'PAID'); insert into orders values ('1-JUL-1996', 'AAA BIKE', '76', '4', 'PAID'); insert into orders values ('1-JUL-1996', 'AAA BIKE', '46', '14', 'PAID'); insert into orders values ('11-JUL-1996', 'JACKS BIKE', '76', '14', 'PAID'); insert into bills values ('Phone Company', '125', '1'); insert into bills values ('Power Company', '75', '1'); insert into bills values ('Record Club', '25', '2'); insert into bills values ('Software Company', '250', '1'); insert into bills values ('Cable TV Company', '35', '3'); insert into bills values ('Joe''s Car Palace', '350', '5'); insert into bills values ('S.C. Student Loan', '200', '6'); insert into bills values ('Florida Water Company', '20', '1'); insert into bills values ('U-O_s Insurance Company', '125', '5'); insert into bills values ('Debtor''s Credit Card', '35', '4'); insert into salaries values ('JACK', '35000', '29'); insert into salaries values ('JILL', '48000', '42'); insert into salaries values ('JOHN', '61000', '55'); insert into products values ('P01', 'MICKEY MOUSE LAMP', '29.95'); insert into products values ('P02', 'NO 2 PENCILS - 20 PACK', '19.9'); insert into products values ('P03', 'COFFEE MUG', '6.95'); insert into products values ('P04', 'FAR SIDE CALENDAR', '10.5'); insert into products values ('P05', 'NATURE CALENDAR', '12.99'); insert into products values ('P06', 'SQL COMMAND REFERENCES', '29.99'); insert into products values ('P07', 'BLACK LEATHER BRIEFCASE', '99.99'); insert into states values ('IN'); insert into states values ('FL'); insert into states values ('KY'); insert into states values ('IL'); insert into states values ('OH'); insert into states values ('CA'); insert into states values ('NY'); INSERT INTO COMPANY VALUES ('Phone Company', '111 1st Street', 'Atlanta', 'GA'); INSERT INTO COMPANY VALUES ('Power Company', '222 2nd Street', 'Jacksonville', 'FL'); INSERT INTO COMPANY VALUES ('Record Club', '333 3rd Avenue', 'Los Angeles', 'CA'); INSERT INTO COMPANY VALUES ('Software Company', '444 4th Drive', 'San Francisco', 'CA'); INSERT INTO COMPANY VALUES ('Cable TV Company', '555 5th Drive', 'Austin', 'TX'); INSERT INTO COMPANY VALUES ('Joe''s Car Palace', '1000 Govt. Blvd', 'Miami', 'FL'); INSERT INTO COMPANY VALUES ('S.C. Student Loan', '25 College Blvd', 'Columbia', 'SC'); INSERT INTO COMPANY VALUES ('Florida Water Company', '1883 Hwy 87', 'Navarre', 'FL'); INSERT INTO COMPANY VALUES ('U-O-Us Insurance Company', '295 Beltline Hwy', 'Macon', 'GA'); INSERT INTO COMPANY VALUES ('Debtor''s Credit Card', '115 2nd Avenue', 'Newark', 'NJ'); INSERT INTO BANK_ACCOUNTS VALUES (1, 'Checking', 500, 'First Federal'); INSERT INTO BANK_ACCOUNTS VALUES (2, 'Money market', 1200, 'First Investor'); INSERT INTO BANK_ACCOUNTS VALUES (3, 'Checking', 90, 'Credit Union'); INSERT INTO BANK_ACCOUNTS VALUES (4, 'Savings', 400, 'First Federal'); INSERT INTO BANK_ACCOUNTS VALUES (5, 'Checking', 2500, 'Second Mutual'); INSERT INTO BANK_ACCOUNTS VALUES (6, 'Business', 4500, 'Fidelity'); INSERT INTO BILLS VALUES ('Phone Company', 125, 1); INSERT INTO BILLS VALUES ('Power Company', 75, 1); INSERT INTO BILLS VALUES ('Record Club', 25, 2); INSERT INTO BILLS VALUES ('Software Company', 250, 1); INSERT INTO BILLS VALUES ('Cable TV Company', 35, 3); INSERT INTO BILLS VALUES ('Joe''s Car Palace', 350, 5); INSERT INTO BILLS VALUES ('S.C. Student Loan', 200, 6); INSERT INTO BILLS VALUES ('Florida Water Company', 20, 1); INSERT INTO BILLS VALUES ('U-O-Us Insurance Company', 125, 5); INSERT INTO BILLS VALUES ('Debtor''s Credit Card', 35, 4); INSERT INTO CUSTOMERS VALUES ('Bill Turner', '725 N. Deal Parkway', 'Washington', 'DC', 20085, 1); INSERT INTO CUSTOMERS VALUES ('John Keith', '1220 Via De Luna Dr.', 'Jacksonville', 'FL', 33581, 2); INSERT INTO CUSTOMERS VALUES ('Mary Rosenburg', '482 Wannamaker Avenue', 'Williamsburg', 'VA', 23478, 3); INSERT INTO CUSTOMERS VALUES ('David Blanken', '405 N. Davis Highway', 'Greenville', 'SC', 29652, 4); INSERT INTO CUSTOMERS VALUES ('Rebecca Little', '7753 Woods Lane', 'Houston', 'TX', 38764, 5); INSERT INTO BALANCES VALUES (1298.53, 854.22, 1); INSERT INTO BALANCES VALUES (5427.22, 6015.96, 2); INSERT INTO BALANCES VALUES (211.25, 190.01, 3); INSERT INTO BALANCES VALUES (73.79, 25.87, 4); INSERT INTO BALANCES VALUES (1285.90, 1473.75, 5); INSERT INTO BALANCES VALUES (1234.56, 1543.67, 6); INSERT INTO BALANCES VALUES (345.25, 348.03, 7); The following INSERT statements are for Lesson 19: insert into artists values(‘Soul Asylum`,`Minneapolis`,`Rock`,1); insert into artists values(‘Maurice Ravel`,`France`,`Classical`,2); insert into artists values(‘Dave Matthews Band`,`Charlottesville`,`Rock`,3); insert into artists values(‘Vince Gill`,`Nashville`,`Country`,4); insert into artists values(‘Oingo Boingo`,`Los Angeles`,`Pop`,5); insert into artists values(‘Crowded House`,`New Zealand`,`Pop`,6); insert into artists values(‘Mary Chapin-Carpenter`,`Nashville`,`Country`,7); insert into artists values(‘Edward MacDowell`,`U.S.A`,`Classical`,8); insert into media values(1,`Record`,4.99); insert into media values(2,`Tape`,9.99); insert into media values(3,`CD`,13.99); insert into media values(4,`CD-ROM`,29.99); insert into media values(5,`DAT`,19.99); insert into recordings values(1,2,`Hang Time`,1988); insert into recordings values(1,3,`Made to Be Broken`,1986); insert into recordings values(2,3,`Bolero`,1990); insert into recordings values(3,5,`Under the Table and Dreaming`,1994); insert into recordings values(4,3,`When Love Finds You`,1994); insert into recordings values(5,2,`Boingo`,1987); insert into recordings values(5,1,`Dead Man`s Party`,1984); insert into recordings values(6,2,`Woodface`,1990); insert into recordings values(6,3,`Together Alone`,1993); insert into recordings values(7,5,`Come On, Come On`,1992); insert into recordings values(7,3,`Stones in the Road`,1994); insert into recordings values(8,5,`Second Piano Concerto`,1985); The following INSERT statements are for Lesson 22: INSERT INTO EMP_TBL VALUES (‘324540787`,`MERCER`,`RICHARD`,`1023 S 3RD`,`LOUSIVILLE`,`KY`,`45345`,`3178234528`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘234566742`,`SMITH`,`HENRY`,`321 GRAND AVE`,`TERRE HAUTE`,`IN`,`47804`,`8122344434`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘313219830`,`PIERCE`,`THOMAS`,`311 MERIDIAN`,`INDIANAPOLIS`,`IN`,`46113`,`3175462918`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘435663121`,`REYNOLDS`,`WILLIAM`,`342 SOUTH ST`,`CARMEL`,`IN`,`45343`,`3177926529`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘412331221`,`TAYLOR`,`VIRGINIA`,`12 EAST 54TH`,`INDIANAPOLIS`,`IN`,`46112`,`3179872335`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘143234343`,`JONES`,`JOHN`,`23 WEST 38TH`,`INDIANAPOLIS`,`IN`,`46112`,`3179856734`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘453897657`,`BENNETT`,`CHRIS`,`4268 WEST 10TH`,`INDIANAPOLIS`,`IN`,`46112`,`3179874532`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘412453872`,`OSBORNE`,`JASON`,`35 SOUTH CHESTER`,`INDIANAPOLIS`,`IN`,`46112`,`3174539876`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘345608124`,`TAYLOR`,`JOHN`,`30 EAST 24TH`,`INDIANAPOLIS`,`IN`,`46112`,`3179561234`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘238513942`,`NICCOSON`,`JULIE`,`5434 EAST 5TH`,`INDIANAPOLIS`,`IN`,`46112`,`3179463248`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘435649765`,`SCHULER`,`STEVE`,`4534 GRAND`,`INDIANAPOLIS`,`IN`,`46123`,`317453654`,NULL,NULL); INSERT INTO EMP_TBL VALUES (‘127643652`,`FERGUSON`,`JOHN`,`345 EAST 10TH`,`INDIANAPOLIS`,`IN`,`46112`,`3174534351`,NULL,NULL); INSERT INTO EMP_PAY_TBL VALUES (‘324540787`,`01-JAN-2006`,`CLERK`,33000.00,NULL,`SMITH`,`SALES`); INSERT INTO EMP_PAY_TBL VALUES (‘234566742`,`15-JUL-2004`,`VP MARKETING`,250000.00,NULL,`VIGO`,`MARKETING`); INSERT INTO EMP_PAY_TBL VALUES (‘313219830`,`08-AUG-2005`,`SALEPERSON`,30000.00,NULL,`MARION`,`SALES`); INSERT INTO EMP_PAY_TBL VALUES (‘435663121`,`01-JAN-2005`,`CLERK`,NULL,9.00,`HAMILTON`,`HQ`); INSERT INTO EMP_PAY_TBL VALUES (‘412331221`,`01-MAY-2005`,`CUSTOMER SERVICE`,NULL,13.00,`MARION`,`SALES`); INSERT INTO EMP_PAY_TBL VALUES (‘143234343`,`01-JUL-2004`,`CUSTOMER SERVICE`,NULL,13.15,`MARION`,`SALES`); INSERT INTO EMP_PAY_TBL VALUES (‘453897657`,`15-OCT-2002`,`CUSTOMER SERVICE`,NULL,14.00,`MARION`,`SALES`); INSERT INTO EMP_PAY_TBL VALUES (‘412453872`,`01-FEB-2003`,`CUSTOMER SERVICE`,NULL,12.75,`MARION`,`SALES`); INSERT INTO EMP_PAY_TBL VALUES (‘345608124`,`15-APR-2002`,`CUSTOMER SERVICE`,NULL,13.25,`MARION`,`SALES`); INSERT INTO EMP_PAY_TBL VALUES (‘238513942`,`01-AUG-2006`,`CUSTOMER SERVICE`,NULL,13.00,`MARION`,`SALES`); INSERT INTO EMP_PAY_TBL VALUES (‘435649765`,`01-APR-2003`,`CUSTOMER SERVICE`,NULL,18.50,`MARION`,`SALES`); INSERT INTO EMP_PAY_TBL VALUES (‘127643652`,`01-MAY-2005`,`CUSTOMER SERVICE`,NULL,14.00,`MARION`,`SALES`); INSERT INTO VENDOR_TBL VALUES (‘1234`,`SONY`,`2343 NORTH 3RD`,`TERRE HAUTE`,`IN`,`47802`,`8135451007`,`8135451002`,`Robert Mcelroy`,`MUSIC`); INSERT INTO VENDOR_TBL VALUES (‘4563`,`CAPITOL PACKING`,`1234 NORTH MERIDIAN`,`INDIANAPOLIS`,`IN`,`46312`,`2127035888`,`2127036790`,`Betsy Conway`,`BOXES`); INSERT INTO VENDOR_TBL VALUES (‘3876`,`OFFICE DEPOT`,`23 WEST 82ND`,`INDIANAPOLIS`,`IN`,`46113`,`3175527007`,NULL,NULL,`OFFICE`); INSERT INTO VENDOR_TBL VALUES (‘9256`,`UPS`,`2334 AIRPORT EXPRESSWAY`,`INDIANAPOLIS`,`IN`,`46213`,`3178982301`,NULL,NULL,`SHIPPING`); INSERT INTO VENDOR_TBL VALUES (‘3452`,`APPLE RECORDS`,`32 MAIN ST`,`NEW YORK`,`NY`,`12543`,`2132215009`,`2132215020`,`Cindy Roberts`,`MUSIC`); INSERT INTO VENDOR_TBL VALUES (‘4352`,`COLUMBIA RECORDS`,`32 WEST PACIFIC`,`SEATTLE`,`WA`,`96243`,5172996012`,NULL,NULL,`MUSIC`); INSERT INTO MEMBER_TBL VALUES (‘1111`,`MOORE`,`KEITH`,`D`,`101 S. KENTUCKY`,`GREENSBORO`,`KY`,`54642`,`13-MAY-2007`,`COUNTRY`,`COUNTRY`,`ROCK`,`CLASSICAL`); INSERT INTO MEMBER_TBL VALUES (‘2222`,`DAVID`,`RICHARDS`,`T`,`30 SOUTH AMARILLO`,`DALLAS`,`TX`,`35246`,NULL,`POP`,`POP`,`ROCK`,`COUNTRY`); INSERT INTO MEMBER_TBL VALUES (‘3333`,`LARRY`,`THOMAS`,`C`,`4536 EAST CYCLE`,`CANTON`,`OH`,`10324`,NULL,`ROCK`,`ROCK`,`POP`,`COUNTRY`); INSERT INTO MEMBER_TBL VALUES (‘4444`,`PAUL`,`BAKER`,`W`,`32 EASTERLY AVE`,`BANKFORD`,`MA`,`54335`,`01-JAN-2009`,`CLASSICAL`,`CLASSOCAL`,NULL,NULL); INSERT INTO MEMBER_TBL VALUES (‘5555`,`BEVERLY`,`STONE`,`F`,`1342 NORTH SUTTON`,`PENNSYLVANIA`,`PA`,`34235`,`01-NOV-2005`,`POP`,`ROCK`,`POP`,`COUNTRY`); INSERT INTO MEMBER_TBL VALUES (‘6666`,`JEREMY`,`WYATT`,`Q`,`3254 NORTH CANAL`,`ERIE`,`PA`,`46378`,`13-AUG-2007`,`POP`,NULL,NULL,NULL); INSERT INTO MEMBER_TBL VALUES (‘7777`,`JOHNATHAN`,`ELLIS`,`L`,`34 EAST MAIN`,`MADESTO`,`CA`,`45231`,NULL,`POP`,`POP`,`ROCK`,NULL); INSERT INTO MEMBER_TBL VALUES (‘7777`,`JAMES`,`STEWART`,`G`,`3245 EAST VALLEY`,`HOLLYWOOD`,`CA`,`46354`,`13-MAY-1999`,`CLASSICAL`,`CLASSICAL`,NULL,NULL); INSERT INTO MEM_PROFILE_TBL VALUES (‘1111`,`NORTHEAST`,`MALE`,`20-NOV-1950`,30000.00); INSERT INTO MEM_PROFILE_TBL VALUES (‘2222`,`WEST`,`MALE`,NULL,NULL); INSERT INTO MEM_PROFILE_TBL VALUES (‘3333`,`SOUTH`,`MALE`,NULL,112000.00); INSERT INTO MEM_PROFILE_TBL VALUES (‘4444`,`MIDWEST`,`MALE`,`17-JAN-1980`,65000.00); INSERT INTO MEM_PROFILE_TBL VALUES (‘5555`,`WEST`,`FEMALER`,`02-JAN-1960`,NULL); INSERT INTO MEM_PROFILE_TBL VALUES (‘6666`,`SOUTHEAST`,`MALE`,NULL,35000.00); INSERT INTO MEM_PROFILE_TBL VALUES (‘7777`,`MIDWEST`,`MALE`,`15-JUN-1970`,`40000.00); INSERT INTO MEM_PROFILE_TBL VALUES (‘8888`,`WEST`,`MALE`,`06-JUL-1940`,1500000.00);