rem ========================================================================== rem Project: INFSCI 2710 "Database Management" rem Version: Spring 2000 rem Module: grades.sql rem Purpose: CREATE TABLE and INSERT INTO Statements for Grades Database rem Created: 24.03.2000 rem Last Change: 24.03.2000 rem Language: Oracle SQL*Plus rem Authors: Stefan Brass rem Email: sbrass@sis.pitt.edu rem Address: Univ. of Pittsburgh, School of Information Sc., PA 15260, USA rem Copyright: (c) 2000 by Stefan Brass rem Copying: You may do anything with this, but don't make me responsible. rem ========================================================================== rem -------------------------------------------------------------------------- rem You may use this program code, but you cannot make me or the University of rem Pittsburgh or anybody else liable in any way for any bugs or damage. rem This program code comes without any guarantee. I have written it in a big rem hurry, so it is very probable that it contains errors. rem I am continually trying to improve the code. rem If you find errors or have improvements, please tell me. rem Formally, the GNU Public Licence applies to this code. rem (You may also simply use it and pretend that you have written it.) rem Please note that all the student names used here are names of famous rem database reserachers. They would all have got an A+ in this course. rem The grades are actual data from the Spring 2000 course, but by renaming rem the students in a random order (not alphabetically) it should be rem impossible to find out the grades of a real student. rem -------------------------------------------------------------------------- SET ECHO OFF rem ################################################################## PROMPT The old versions of the tables are deleted. PROMPT Do not worry about the message Table does not exist ... DROP TABLE RESULTS; DROP TABLE EXERCISES; DROP TABLE CATEGORIES; DROP TABLE STUDENTS; DROP SEQUENCE STUD_NUMBERS; rem ################################################################## PROMPT The tables are being created... CREATE TABLE STUDENTS ( STUD_ID NUMBER(5) NOT NULL, FIRST_NAME VARCHAR(20) NOT NULL, LAST_NAME VARCHAR(20) NOT NULL, EMAIL VARCHAR(40) NULL, PASSWORD VARCHAR(20) NOT NULL, LAST_TERM CHAR(1) NULL, REGISTERED DATE NOT NULL, GRADE CHAR(2) NULL, CONSTRAINT STUDENTS_KEY PRIMARY KEY (STUD_ID), CONSTRAINT STUDENTS_NAMES_MUST_BE_UNIQUE UNIQUE (FIRST_NAME, LAST_NAME), CONSTRAINT STUD_ID_MUST_BE_GREATER_ZERO CHECK (STUD_ID >= 0), CONSTRAINT LAST_TERM_MUST_BE_Y_OR_N CHECK(LAST_TERM IN ('Y', 'N')), CONSTRAINT GRADE_MUST_BE_A_AMINUS_ETC CHECK (GRADE IN ('A+','A','A-','B+','B','B-','C+','C','C-', 'D+','D','D-','F','G', 'S', 'N', 'H', 'U'))); CREATE SEQUENCE STUD_NUMBERS START WITH 1000; CREATE TABLE CATEGORIES ( CAT CHAR(1) NOT NULL PRIMARY KEY, CAT_NAME VARCHAR(40) NOT NULL, OUTPUT_ORDER NUMBER(2) NOT NULL, CONSTRAINT OUTPUT_ORDER_GREATER_ZERO CHECK(OUTPUT_ORDER >= 0), CONSTRAINT OUTPUT_ORDER_UNIQUE UNIQUE(OUTPUT_ORDER)); CREATE TABLE EXERCISES ( CAT CHAR(1) NOT NULL, EX_NO NUMBER(2) NOT NULL, TOPIC VARCHAR(20) NOT NULL, MAX_POINTS NUMBER(2) NOT NULL, CONSTRAINT EXERCISES_KEY PRIMARY KEY (CAT, EX_NO), CONSTRAINT CAT_VALID FOREIGN KEY (CAT) REFERENCES CATEGORIES, CONSTRAINT EX_NO_MUST_BE_GREATER_0 CHECK (EX_NO >= 0), CONSTRAINT MAX_POINTS_MUST_BE_GREATER_0 CHECK (MAX_POINTS >= 0)); CREATE TABLE RESULTS ( CAT CHAR(1) NOT NULL, EX_NO NUMBER(2) NOT NULL, STUD_ID NUMBER(5) NOT NULL, POINTS NUMBER(3,1) NOT NULL, ENTERED DATE NOT NULL, CONSTRAINT RESULTS_KEY PRIMARY KEY (CAT, EX_NO, STUD_ID), CONSTRAINT RESULTS_REF_EXERCISES FOREIGN KEY (CAT, EX_NO) REFERENCES EXERCISES, CONSTRAINTS RESULTS_REF_STUDENTS FOREIGN KEY (STUD_ID) REFERENCES STUDENTS, CONSTRAINT POINTS_MUST_BE_GREATER_0 CHECK (POINTS >= 0)); rem ################################################################## Prompt Setting the Sequence to the next unused student number ... DROP SEQUENCE STUD_NUMBERS; CREATE SEQUENCE STUD_NUMBERS START WITH 3385; rem ################################################################## PROMPT Inserting student records ... INSERT INTO STUDENTS VALUES(3000, 'Serge', 'Abiteboul', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('02-MAR-2000 11:25', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3001, 'Malcolm P.', 'Atkinson', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('07-JAN-2000 19:20', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3002, 'Paolo', 'Atzeni', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('07-JAN-2000 19:54', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3003, 'Rudolf', 'Bayer', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('08-JAN-2000 14:28', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3004, 'Joachim', 'Biskup', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('09-JAN-2000 01:48', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3005, 'Anthony', 'Bonner', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('10-JAN-2000 08:05', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3006, 'Francois', 'Bry', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('10-JAN-2000 09:25', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3007, 'Alejandro', 'Buchmann', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('10-JAN-2000 10:02', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3008, 'Peter', 'Buneman', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('10-JAN-2000 15:34', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3009, 'Jan', 'Van den Bussche', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('10-JAN-2000 18:24', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3010, 'Stefano', 'Ceri', 'abc@pitt.edu', 'CMcaWQSXtH6', 'Y', TO_DATE('10-JAN-2000 22:45', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3011, 'Sudarshan S.', 'Chawathe', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('11-JAN-2000 10:34', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3012, 'Peter P.', 'Chen', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('11-JAN-2000 10:49', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3013, 'Donald', 'Chamberlin', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('11-JAN-2000 10:51', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3014, 'Jan', 'Chomicki', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('11-JAN-2000 12:25', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3015, 'Panos Kypros', 'Chrysanthis', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('11-JAN-2000 14:18', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3016, 'Sophie', 'Cluet', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('12-JAN-2000 09:40', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3017, 'Suzanne W.', 'Dietrich', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('12-JAN-2000 12:08', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3018, 'Klaus R.', 'Dittrich', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('12-JAN-2000 12:08', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3019, 'Claude', 'Delobel', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('12-JAN-2000 12:57', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3020, 'David J.', 'DeWitt', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('12-JAN-2000 13:48', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3021, 'Hans-Dieter', 'Ehrich', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('12-JAN-2000 23:13', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3022, 'Ramez', 'Elmasri', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('13-JAN-2000 09:44', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3023, 'Ron', 'Fagin', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('13-JAN-2000 14:14', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3024, 'Christos', 'Faloutsos', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('13-JAN-2000 17:07', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3025, 'Michael J.', 'Franklin', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('13-JAN-2000 17:36', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3026, 'Piero', 'Fraternali', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('13-JAN-2000 20:23', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3027, 'Burkhard', 'Freitag', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('14-JAN-2000 12:09', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3044, 'Hector', 'Garcia-Molina', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('15-JAN-2000 18:12', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3045, 'Georges', 'Gardarin', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('16-JAN-2000 16:14', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3046, 'Allen', 'Van Gelder', 'abc@pitt.edu', 'CMcaWQSXtH6', 'Y', TO_DATE('16-JAN-2000 18:26', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3047, 'Georg', 'Gottlob', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('16-JAN-2000 22:52', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3048, 'Goesta', 'Grahne', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('17-JAN-2000 09:51', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3049, 'Jim', 'Gray', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('17-JAN-2000 13:11', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3050, 'Stephane', 'Grumbach', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('17-JAN-2000 13:49', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3051, 'Ralf Hartmut', 'Gueting', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('18-JAN-2000 12:49', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3052, 'Marc', 'Gyssens', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('18-JAN-2000 17:33', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3053, 'Theo', 'Haerder', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('18-JAN-2000 21:36', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3054, 'Andreas', 'Heuer', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('19-JAN-2000 16:32', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3055, 'Richard', 'Hull', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('19-JAN-2000 21:28', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3064, 'Tomasz', 'Imielinski', 'abc@pitt.edu', 'CMcaWQSXtH6', 'Y', TO_DATE('20-JAN-2000 08:56', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3065, 'Matthias', 'Jarke', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('20-JAN-2000 11:43', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3066, 'Manfred A.', 'Jeusfeld', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('20-JAN-2000 23:24', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3067, 'Paris Christos', 'Kanellakis', 'abc@pitt.edu', 'CMcaWQSXtH6', 'Y', TO_DATE('22-JAN-2000 11:24', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3068, 'David', 'Kemp', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('23-JAN-2000 23:29', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3069, 'Alfons', 'Kemper', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('24-JAN-2000 21:09', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3070, 'Larry', 'Kerschberg', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('25-JAN-2000 12:11', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3084, 'Werner', 'Kiessling', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('25-JAN-2000 17:19', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3104, 'Michael', 'Kifer', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('25-JAN-2000 21:13', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3105, 'Phokion G.', 'Kolaitis', 'abc@pitt.edu', 'CMcaWQSXtH6', 'Y', TO_DATE('27-JAN-2000 14:42', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3126, 'Henry F.', 'Korth', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('30-JAN-2000 10:28', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3127, 'Hans-Peter', 'Kriegel', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('31-JAN-2000 10:48', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3128, 'Laks V.S.', 'Lakshmanan', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('31-JAN-2000 13:53', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3129, 'Georg', 'Lausen', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('01-FEB-2000 18:40', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3131, 'Alon Y.', 'Levy', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('01-FEB-2000 22:37', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3132, 'Udo W.', 'Lipeck', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('02-FEB-2000 10:31', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3133, 'Peter C.', 'Lockemann', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('02-FEB-2000 17:48', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3134, 'David', 'Maier', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('02-FEB-2000 23:51', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3135, 'Rainer', 'Manthey', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('03-FEB-2000 00:25', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3136, 'Alberto', 'Mendelzon', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('03-FEB-2000 01:27', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3137, 'Jack', 'Minker', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('03-FEB-2000 01:28', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3138, 'Bernhard', 'Mitschang', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('03-FEB-2000 12:21', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3139, 'Guido', 'Moerkotte', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('03-FEB-2000 12:55', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3144, 'Mukesh', 'Mohania', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('03-FEB-2000 15:03', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3164, 'Jeffrey F.', 'Naughton', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('03-FEB-2000 15:29', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3165, 'Shamkant B.', 'Navathe', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('03-FEB-2000 15:43', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3184, 'Erich J.', 'Neuhold', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('03-FEB-2000 19:39', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3185, 'M. Tamer', 'Oezsu', 'abc@pitt.edu', 'CMcaWQSXtH6', 'Y', TO_DATE('04-FEB-2000 14:08', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3204, 'Jan', 'Paredaens', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('06-FEB-2000 12:59', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3205, 'Alain', 'Pirotte', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('06-FEB-2000 15:39', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3206, 'Erhard', 'Rahm', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('07-FEB-2000 08:01', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3207, 'Raghu', 'Ramakrishnan', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('07-FEB-2000 17:39', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3244, 'Krithi', 'Ramamritham', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('09-FEB-2000 19:38', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3264, 'Kotagiri', 'Ramamohanarao', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('10-FEB-2000 21:22', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3284, 'Louiqa', 'Raschid', 'abc@pitt.edu', 'CMcaWQSXtH6', 'Y', TO_DATE('15-FEB-2000 15:15', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3324, 'Kenneth A.', 'Ross', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('22-FEB-2000 16:01', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3344, 'Nick', 'Roussopoulos', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('22-FEB-2000 20:26', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3345, 'Gunter', 'Saake', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('23-FEB-2000 05:24', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3364, 'Fereidoon', 'Sadri', 'abc@pitt.edu', 'CMcaWQSXtH6', 'Y', TO_DATE('26-FEB-2000 23:46', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3366, 'Hans-Joerg', 'Schek', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('28-FEB-2000 19:04', 'DD-MON-YYYY HH24:MI'), null); INSERT INTO STUDENTS VALUES(3367, 'Joachim W.', 'Schmidt', 'abc@pitt.edu', 'CMcaWQSXtH6', 'N', TO_DATE('01-MAR-2000 12:03', 'DD-MON-YYYY HH24:MI'), null); rem ################################################################## PROMPT Inserting CATEGORIES records ... INSERT INTO CATEGORIES VALUES('H', 'Homework', 1); INSERT INTO CATEGORIES VALUES('M', 'Midterm Exam', 2); INSERT INTO CATEGORIES VALUES('F', 'Final Exam', 3); rem ################################################################## PROMPT Inserting EXERCISES records ... INSERT INTO EXERCISES VALUES('H', 1, 'ER-MODEL', 10); INSERT INTO EXERCISES VALUES('H', 2, 'ER-MODEL-CONSTRAINTS', 10); INSERT INTO EXERCISES VALUES('H', 3, 'ER-MODEL(ADVANCED)', 12); INSERT INTO EXERCISES VALUES('H', 4, 'BASIC-ALGEBRA-SQL', 12); INSERT INTO EXERCISES VALUES('H', 5, 'ADV-ALGEBRA-SQL+', 12); INSERT INTO EXERCISES VALUES('H', 6, 'ER-MODEL TO TABLES', 12); INSERT INTO EXERCISES VALUES('M', 1, 'ER-DESIGN', 12); INSERT INTO EXERCISES VALUES('M', 2, 'COMPARE ER-SCHEMAS', 6); INSERT INTO EXERCISES VALUES('M', 3, 'KEYS', 6); INSERT INTO EXERCISES VALUES('M', 4, 'FOREIGN KEYS', 6); INSERT INTO EXERCISES VALUES('M', 5, 'RELATIONAL ALGEBRA', 9); INSERT INTO EXERCISES VALUES('M', 6, 'SQL', 9); INSERT INTO EXERCISES VALUES('M', 7, 'SQL ERRORS', 6); INSERT INTO EXERCISES VALUES('M', 8, 'RELATIONAL PUZZLE', 0); rem ################################################################## PROMPT Inserting RESULTS records ... INSERT INTO RESULTS VALUES('H', 1, 3000, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3001, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3002, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3003, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3004, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3005, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3006, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3007, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3008, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3009, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3010, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3011, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3012, 9.5, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3013, 9.5, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3014, 9, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3015, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3016, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3017, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3018, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3019, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3020, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3021, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3022, 9.5, '28-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3023, 9, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3024, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3025, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3026, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3027, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3044, 9, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3045, 9.5, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3046, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3047, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3048, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3049, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3050, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3051, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3052, 9.5, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3053, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3054, 9.5, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3055, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3064, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3065, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3066, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3067, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3068, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3069, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3070, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3084, 9.5, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3104, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3126, 9, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3127, 10, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3128, 10, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3131, 9.5, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3132, 9.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3133, 9.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3134, 10, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3135, 9, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3136, 9.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3138, 10, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3139, 10, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3144, 10, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3164, 10, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3165, 9.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3184, 10, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3204, 10, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3205, 10, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3206, 9.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3207, 10, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3244, 8.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3264, 9.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3284, 8.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3324, 7, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 1, 3345, 9.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3000, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3001, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3002, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3003, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3004, 9.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3005, 10, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3006, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3007, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3008, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3009, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3010, 9.5, '01-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3011, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3012, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3013, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3014, 9, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3015, 9.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3016, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3017, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3018, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3019, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3020, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3021, 9, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3022, 9.5, '28-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3023, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3024, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3025, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3026, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3027, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3044, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3045, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3046, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3047, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3048, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3049, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3050, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3051, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3052, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3053, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3054, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3055, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3064, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3065, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3066, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3067, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3069, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3070, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3084, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3104, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3126, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3127, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3128, 9.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3132, 8.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3133, 9, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3134, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3135, 9.5, '09-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3136, 9, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3138, 9.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3139, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3144, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3164, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3184, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3185, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3204, 10, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3205, 9.5, '08-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3206, 9, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3207, 10, '28-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3244, 9, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3264, 9.5, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3284, 9, '17-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3324, 7, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 2, 3345, 9.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3000, 10.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3001, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3002, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3003, 11.5, '18-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3004, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3005, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3006, 10.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3007, 10.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3008, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3009, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3010, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3011, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3012, 12, '18-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3013, 12, '18-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3014, 11, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3015, 10.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3016, 11.5, '18-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3017, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3018, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3019, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3020, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3021, 11.5, '22-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3022, 9, '28-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3023, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3024, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3025, 11, '18-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3026, 12, '18-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3027, 11, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3044, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3045, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3046, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3047, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3048, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3049, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3050, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3051, 11.5, '18-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3052, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3053, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3054, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3055, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3064, 10.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 3, 3065, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3066, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3067, 11, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3068, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3069, 10.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3070, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3084, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3104, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3126, 10, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3127, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3128, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3132, 10.5, '22-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3133, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3134, 11, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3135, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3136, 10.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3138, 12, '22-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3139, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3144, 10.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 3, 3164, 11, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3184, 10, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3185, 11.5, '18-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3204, 12, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3205, 11.5, '16-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3206, 10, '02-MAR-00'); INSERT INTO RESULTS VALUES('H', 3, 3207, 11.5, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 3, 3244, 10.5, '28-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3264, 11.5, '16-MAR-00'); INSERT INTO RESULTS VALUES('H', 3, 3284, 8, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 3, 3324, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3345, 10, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 3, 3366, 12, '02-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3000, 10.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3001, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3002, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3003, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3004, 10.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3005, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3006, 10.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3007, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3008, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3009, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3010, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3011, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3012, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3013, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3014, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3015, 10.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3016, 11.5, '22-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3017, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3018, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3019, 11.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3020, 10, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3021, 10.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3022, 10.5, '28-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3023, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3024, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3025, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3026, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3027, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3044, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3045, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3047, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3048, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3049, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3050, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3051, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3052, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3053, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3054, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3055, 11.5, '19-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3064, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3066, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3067, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3068, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3069, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3070, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3084, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3104, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3126, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3127, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3128, 10.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3132, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3133, 10, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3134, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3135, 12, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3136, 11, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3138, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3139, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3164, 11.5, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3184, 7.5, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3204, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3205, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3206, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3207, 12, '16-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3244, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3264, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3284, 10, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3324, 7.5, '22-MAR-00'); INSERT INTO RESULTS VALUES('H', 4, 3345, 10.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 4, 3366, 12, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3001, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3002, 10.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3003, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3004, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3005, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3006, 11.5, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3007, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3008, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3009, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3010, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3011, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3012, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3013, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3014, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3015, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3016, 12, '22-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3017, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3018, 10.5, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3019, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3020, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3021, 10, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3022, 11, '28-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3023, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3024, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3025, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3026, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3027, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3044, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3045, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3047, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3048, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3049, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3050, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3051, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3052, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3053, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3054, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3055, 12, '16-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3064, 11.5, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3065, 11.5, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3066, 12, '22-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3067, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3068, 12, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3069, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3070, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3084, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3104, 12, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3126, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3127, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3132, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3133, 11.5, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3134, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3135, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3138, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3139, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3144, 11.5, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3164, 10.5, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3184, 12, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3204, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3205, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3206, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3207, 12, '15-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3244, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3264, 12, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3284, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 5, 3324, 12, '22-MAR-00'); INSERT INTO RESULTS VALUES('H', 5, 3345, 11, '23-FEB-00'); INSERT INTO RESULTS VALUES('H', 6, 3001, 11.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3002, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3003, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3005, 11.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3006, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3008, 11.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3009, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3010, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3011, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3012, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3013, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3014, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3015, 11.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3016, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3017, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3019, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3020, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3023, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3024, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3027, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3044, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3045, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3047, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3048, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3049, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3050, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3051, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3052, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3053, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3054, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3055, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3064, 11.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3065, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3066, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3067, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3070, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3104, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3126, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3127, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3128, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3133, 9.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3134, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3135, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3138, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3139, 11.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3144, 11.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3164, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3184, 8, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3185, 11.5, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3204, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3205, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3206, 10, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3207, 11, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3264, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('H', 6, 3366, 12, '21-MAR-00'); INSERT INTO RESULTS VALUES('M', 1, 3000, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3001, 11, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3002, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3003, 10.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3004, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3005, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3006, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3007, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3008, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3009, 10.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3010, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3011, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3012, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3013, 10.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3014, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3015, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3016, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3017, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3018, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3019, 11, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3020, 10.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3021, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3022, 7.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3023, 11, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3024, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3025, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3026, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3027, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3044, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3045, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3047, 11, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3048, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3049, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3050, 12.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3051, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3052, 9.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3053, 11, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3054, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3055, 11, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3064, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3065, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3066, 11.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3067, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3068, 10, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3069, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3070, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3084, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3104, 11.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3126, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3127, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3128, 7.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3132, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3133, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3134, 9.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3135, 7.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3136, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3138, 10.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3139, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3144, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3164, 11, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3184, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3185, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3204, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3205, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3206, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3207, 12, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3244, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3264, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3284, 7.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3324, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 1, 3364, 7, '20-MAR-00'); INSERT INTO RESULTS VALUES('M', 1, 3366, 11, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3000, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3001, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3002, 1.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3003, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3004, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3005, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3006, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3007, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3008, 3.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3009, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3010, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3011, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3012, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3013, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3014, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3015, 1, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3016, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3017, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3018, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3019, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3020, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3021, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3022, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3023, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3024, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3025, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3026, 4.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3027, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3044, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3045, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3047, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3048, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3049, 5.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3050, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3051, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3052, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3053, 5.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3054, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3055, 5.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3064, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3065, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3066, 4.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3067, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3068, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3069, 2.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3070, 3.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3084, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3104, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3126, 1, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3127, 6.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3128, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3132, 1, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3133, 4.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3134, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3135, 3.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3136, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3138, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3139, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3144, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3164, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3184, 2.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3185, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3204, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3205, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3206, 4.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3207, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3244, 1, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3264, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3284, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3324, 1, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 2, 3364, 3, '20-MAR-00'); INSERT INTO RESULTS VALUES('M', 2, 3366, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3000, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3001, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3002, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3003, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3004, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3005, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3006, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3007, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3008, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3009, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3010, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3011, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3012, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3013, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3014, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3015, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3016, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3017, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3018, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3019, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3020, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3021, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3022, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3023, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3024, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3025, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3026, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3027, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3044, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3045, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3047, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3048, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3049, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3050, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3051, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3052, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3053, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3054, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3055, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3064, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3065, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3066, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3067, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3068, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3069, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3070, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3084, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3104, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3126, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3127, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3128, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3132, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3133, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3134, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3135, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3136, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3138, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3139, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3144, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3164, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3184, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3185, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3204, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3205, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3206, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3207, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3244, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3264, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3284, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3324, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 3, 3364, 0, '20-MAR-00'); INSERT INTO RESULTS VALUES('M', 3, 3366, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3000, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3001, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3002, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3003, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3004, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3005, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3006, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3007, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3008, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3009, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3010, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3011, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3012, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3013, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3014, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3015, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3016, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3017, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3018, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3019, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3020, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3021, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3022, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3023, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3024, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3025, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3026, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3027, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3044, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3045, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3047, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3048, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3049, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3050, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3051, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3052, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3053, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3054, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3055, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3064, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3065, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3066, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3067, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3068, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3069, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3070, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3084, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3104, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3126, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3127, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3128, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3132, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3133, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3134, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3135, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3136, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3138, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3139, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3144, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3164, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3184, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3185, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3204, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3205, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3206, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3207, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3244, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3264, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3284, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3324, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 4, 3364, 2, '20-MAR-00'); INSERT INTO RESULTS VALUES('M', 4, 3366, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3000, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3001, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3002, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3003, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3004, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3005, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3006, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3007, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3008, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3009, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3010, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3011, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3012, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3013, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3014, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3015, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3016, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3017, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3018, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3019, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3020, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3021, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3022, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3023, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3024, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3025, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3026, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3027, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3044, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3045, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3047, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3048, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3049, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3050, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3051, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3052, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3053, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3054, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3055, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3064, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3065, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3066, 7.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3067, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3068, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3069, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3070, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3084, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3104, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3126, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3127, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3128, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3132, 6.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3133, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3134, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3135, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3136, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3138, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3139, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3144, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3164, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3184, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3185, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3204, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3205, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3206, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3207, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3244, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3264, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3284, 4.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3324, 5.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 5, 3364, 4, '20-MAR-00'); INSERT INTO RESULTS VALUES('M', 5, 3366, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3000, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3001, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3002, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3003, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3004, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3005, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3006, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3007, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3008, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3009, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3010, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3011, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3012, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3013, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3014, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3015, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3016, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3017, 7.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3018, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3019, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3020, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3021, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3022, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3023, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3024, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3025, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3026, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3027, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3044, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3045, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3047, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3048, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3049, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3050, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3051, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3052, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3053, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3054, 7.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3055, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3064, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3065, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3066, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3067, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3068, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3069, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3070, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3084, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3104, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3126, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3127, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3128, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3132, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3133, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3134, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3135, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3136, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3138, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3139, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3144, 6.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3164, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3184, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3185, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3204, 8.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3205, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3206, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3207, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3244, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3264, 7.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3284, 7, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3324, 8, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 6, 3364, 8, '20-MAR-00'); INSERT INTO RESULTS VALUES('M', 6, 3366, 9, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3000, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3001, 5.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3002, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3003, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3004, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3005, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3006, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3007, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3008, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3009, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3010, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3011, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3012, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3013, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3014, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3015, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3016, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3017, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3018, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3019, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3020, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3021, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3022, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3023, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3024, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3025, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3026, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3027, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3044, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3045, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3047, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3048, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3049, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3050, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3051, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3052, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3053, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3054, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3055, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3064, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3065, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3066, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3067, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3068, 3.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3069, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3070, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3084, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3104, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3126, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3127, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3128, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3132, 5.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3133, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3134, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3135, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3136, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3138, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3139, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3144, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3164, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3184, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3185, 5.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3204, 5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3205, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3206, 3.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3207, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3244, 3.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3264, 4, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3284, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3324, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 7, 3364, 4, '20-MAR-00'); INSERT INTO RESULTS VALUES('M', 7, 3366, 6, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3000, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3001, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3002, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3003, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3004, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3005, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3006, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3007, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3008, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3009, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3010, 1, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3011, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3012, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3013, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3014, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3015, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3016, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3017, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3018, 1, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3019, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3020, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3021, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3022, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3023, 1.5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3024, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3025, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3026, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3027, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3044, 1, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3045, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3047, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3048, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3049, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3050, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3051, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3052, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3053, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3054, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3055, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3064, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3065, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3066, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3067, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3068, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3069, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3070, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3084, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3104, 3, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3126, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3127, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3128, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3132, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3133, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3134, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3135, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3136, .5, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3138, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3139, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3144, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3164, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3184, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3185, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3204, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3205, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3206, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3207, 2, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3244, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3264, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3284, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3324, 0, '29-FEB-00'); INSERT INTO RESULTS VALUES('M', 8, 3364, 0, '20-MAR-00'); INSERT INTO RESULTS VALUES('M', 8, 3366, 3, '29-FEB-00'); PROMPT Commit transaction: COMMIT; rem ################################################################## PROMPT Done.