
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', '1998-04-01', '1998-04-01');

insert into project values
('TECH SURVEY', '1998-04-02', '1998-05-01');

insert into project values
('USER MTGS', '1998-05-15', '1998-05-30');

insert into project values
('DESIGN WIDGET', '1998-06-01', '1998-06-30');

insert into project values
('CODE WIDGET', '1998-07-01', '1998-09-02');

insert into project values
('TESTING', '1998-09-03', '1999-01-17');

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
('19-MAY-1996', 'TRUE WHEEL', '76', '3', 'PAID');

insert into orders values
('1996-09-02', 'TRUE WHEEL', '10', '1', 'PAID');

insert into orders values
('1996-06-30', 'TRUE WHEEL', '42', '8', 'PAID');

insert into orders values
('1996-06-30', 'BIKE SPEC', '54', '10', 'PAID');

insert into orders values
('1996-05-30', 'BIKE SPEC', '23', '8', 'PAID');

insert into orders values
('1996-01-17', 'BIKE SPEC', '76', '11', 'PAID');

insert into orders values
('1996-01-17', 'LE SHOPPE', '76', '5', 'PAID');

insert into orders values
('1996-06-01', 'LE SHOPPE', '10', '3', 'PAID');

insert into orders values
('1996-06-01', 'AAA BIKE', '10', '1', 'PAID');

insert into orders values
('1996-07-01', 'AAA BIKE', '76', '4', 'PAID');

insert into orders values
('1996-07-01', 'AAA BIKE', '46', '14', 'PAID');

insert into orders values
('1996-07-11', '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 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);
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);
 
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);

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', '1998-04-01', '1998-04-01');

insert into project values
('TECH SURVEY', '1998-04-02', '1998-05-01');

insert into project values
('USER MTGS', '1998-05-15', '1998-05-30');

insert into project values
('DESIGN WIDGET', '1998-06-01', '1998-06-30');

insert into project values
('CODE WIDGET', '1998-07-01', '1998-09-02');

insert into project values
('TESTING', '1998-09-03', '1999-01-17');

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
('19-MAY-1996', 'TRUE WHEEL', '76', '3', 'PAID');

insert into orders values
('1996-09-02', 'TRUE WHEEL', '10', '1', 'PAID');

insert into orders values
('1996-06-30', 'TRUE WHEEL', '42', '8', 'PAID');

insert into orders values
('1996-06-30', 'BIKE SPEC', '54', '10', 'PAID');

insert into orders values
('1996-05-30', 'BIKE SPEC', '23', '8', 'PAID');

insert into orders values
('1996-01-17', 'BIKE SPEC', '76', '11', 'PAID');

insert into orders values
('1996-01-17', 'LE SHOPPE', '76', '5', 'PAID');

insert into orders values
('1996-06-01', 'LE SHOPPE', '10', '3', 'PAID');

insert into orders values
('1996-06-01', 'AAA BIKE', '10', '1', 'PAID');

insert into orders values
('1996-07-01', 'AAA BIKE', '76', '4', 'PAID');

insert into orders values
('1996-07-01', 'AAA BIKE', '46', '14', 'PAID');

insert into orders values
('1996-07-11', '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 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);
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);
 
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);
