# drop all tables #################################################

DROP TABLE IF EXISTS grade;
DROP TABLE IF EXISTS payment;

DROP TABLE IF EXISTS instructor;
DROP TABLE IF EXISTS student;
DROP TABLE IF EXISTS course;
DROP TABLE IF EXISTS assignment;
DROP TABLE IF EXISTS dates;
DROP TABLE IF EXISTS state;

DROP VIEW  IF EXISTS v_key_column;

# create instructor table #########################################

CREATE TABLE instructor
(
    instructor_id INT           NOT NULL    PRIMARY KEY AUTO_INCREMENT,
    lname         VARCHAR(20)   NOT NULL,
    fname         VARCHAR(20)   NOT NULL,
    ssn           CHAR(11)      NOT NULL    UNIQUE,
    sex           CHAR(1)       NOT NULL    CHECK (sex = 'M' OR sex = 'F'),
    active_status CHAR(1)       NOT NULL    DEFAULT 'A' CHECK (active_status IN ('A','I')),
    start_date    TIMESTAMP     NOT NULL    DEFAULT CURRENT_TIMESTAMP,
    specialty     varchar(100)
);

CREATE INDEX inst_name_idx ON instructor (lname, fname);

INSERT INTO instructor VALUES(0,'Sultan','Sam','000-02-0001','M','A','1999-09-01','Web technology, Java, XML, SQL');
INSERT INTO instructor VALUES(0,'Pefanis','George','000-02-0002','M','A','2000-02-15','ASP, .NET, HTML');
INSERT INTO instructor VALUES(0,'martin','susan','000-02-0003','F','A','1998-07-01',NULL);
INSERT INTO instructor VALUES(0,'Paller','Marc','000-02-0004','M','A','1995-01-01','Oracle, DB2');
INSERT INTO instructor VALUES(0,'O''Brien','Mary','000-02-0005','F','I','2003-03-25',NULL);
INSERT INTO instructor VALUES(0,'Katz','Eric','000-02-0006','M','A','2001-05-15','JavaScript, C, Flash');


# create student table ###########################################

CREATE TABLE student
(
    student_id   INT           NOT NULL   PRIMARY KEY AUTO_INCREMENT,
    lname        VARCHAR(20)   NOT NULL,
    fname        VARCHAR(20)   NOT NULL,
    ssn          CHAR(11)      NOT NULL,
    sex          ENUM('F','M') NOT NULL,
    program      VARCHAR(20)   NOT NULL,      
    school_year  CHAR(1)       NOT NULL,
    email        VARCHAR(100),

    CONSTRAINT stu_ssn_uq  UNIQUE      (ssn), 
    CONSTRAINT stu_sex_chk CHECK       (sex IN ('M', 'F'))
);

CREATE INDEX stu_name_idx ON student (lname, fname);

INSERT INTO student VALUES(0,'Burns','Barbara','000-01-0001','F','graduate','4','barbara.burns@nyu.edu');
INSERT INTO student VALUES(0,'Cambria','Vincent','000-01-0002','M','undergraduate','3','vcambria@yahoo.com');
INSERT INTO student VALUES(0,'Davidson','Duncan','000-01-0003','M','graduate','2','duncan.davidson@nyu.edu');
INSERT INTO student VALUES(0,'Smith','David','000-01-0004','M','undergraduate','1',NULL);
INSERT INTO student VALUES(0,'Thomas','Eugene','000-01-0005','M','undergraduate','3','ethomas@xyz.com');
INSERT INTO student VALUES(0,'Owens','Cynthia','000-01-0006','F','undergraduate','2',NULL);
INSERT INTO student VALUES(0,'Willis','Eileen','000-01-0007','F','graduate','3',NULL);
INSERT INTO student VALUES(0,'Myers','Rick','000-01-0008','M','undergraduate','2','rick.myers@nyu.edu');
INSERT INTO student VALUES(0,'Ryan','Natasha','000-01-0009','F','graduate','1',NULL);
INSERT INTO student VALUES(0,'Stack','Patrick','000-01-0010','M','undergraduate','1',NULL);
INSERT INTO student VALUES(0,'Tobias','Wayne','000-01-0011','M','graduate','4',NULL);
INSERT INTO student VALUES(0,'Race','Joseph','000-01-0012','M','graduate','3','joerace321@xyz.tv');
INSERT INTO student VALUES(0,'Nelson','Colette','000-01-0013','F','graduate','3',NULL);
INSERT INTO student VALUES(0,'Brinson','Angel','000-01-0014','F','undergraduate','1',NULL);
INSERT INTO student VALUES(0,'Soley','John','000-01-0015','M','undergraduate','2','soleyj@nyu.edu');
INSERT INTO student VALUES(0,'Grace','Robert','000-01-0016','M','undergraduate','2',NULL);
INSERT INTO student VALUES(0,'Tok','Kathy','000-01-0017','F','graduate','1',NULL);
INSERT INTO student VALUES(0,'miller','janet','000-01-0018','F','undergraduate','2',NULL);
INSERT INTO student VALUES(0,'Austin','Maria','000-01-0019','F','graduate','2',NULL);
INSERT INTO student VALUES(0,'Teagan','Edward','000-01-0020','M','undergraduate','4',NULL);
INSERT INTO student VALUES(0,'Milgrom','Anya','000-01-0021','F','undergraduate','4',NULL);
INSERT INTO student VALUES(0,'Vasquez','Lillian','000-01-0022','F','undergraduate','3',NULL);
INSERT INTO student VALUES(0,'Chan','David','000-01-0023','M','graduate','1',NULL);
INSERT INTO student VALUES(0,'James','Phyllis','000-01-0024','F','undergraduate','1',NULL);
INSERT INTO student VALUES(0,'Sultan','Sam','000-02-0001','M','graduate','4',NULL);


# create course table ############################################

CREATE TABLE course
(
    course_id     INT           NOT NULL     PRIMARY KEY AUTO_INCREMENT,
    course_num    CHAR(8)       NOT NULL,
    description   VARCHAR(40)   NOT NULL,
    price         INT           NOT NULL,
    department    VARCHAR(40)   NOT NULL,
    curr_prev     CHAR(4)       NOT NULL,
    inactive_date DATE
);

INSERT INTO course VALUES(0,'X52-9272','SQL Programming Language',540,'Database Technology','curr',null);
INSERT INTO course VALUES(0,'X52-9759','XML for Web Development',1095,'Web Development','curr',null);
INSERT INTO course VALUES(0,'X52-9740','Web Page Development with HTML',1095,'Web Development','curr',null);
INSERT INTO course VALUES(0,'X52-9238','Introduction to Java',1095,'Information Technology','curr',null);
INSERT INTO course VALUES(0,'X52-9742','Intensive Web Development',3995,'Web Development','curr',null);
INSERT INTO course VALUES(0,'X52-9755','JavaScript',1095,'Information Technology','prev','2014-08-01');
INSERT INTO course VALUES(0,'X52-9755','JavaScript',1095,'Web Development','curr',null);
INSERT INTO course VALUES(0,'X52-9267','Object Oriented Analysis and Design',995,'Information Technology','curr',null);
INSERT INTO course VALUES(0,'X52-9550','Data Warehousing and Data Mining',4095,'Database Technology','curr',null);


# create assignment table ############################################

CREATE TABLE assignment
(
    assignment_id INT           NOT NULL    PRIMARY KEY AUTO_INCREMENT,
    description   VARCHAR(50)   NOT NULL,
    percent       DECIMAL(2,2)  NOT NULL
);

INSERT INTO assignment VALUES(null,'Homework 1',.05);
INSERT INTO assignment VALUES(null,'Homework 2',.05);
INSERT INTO assignment VALUES(null,'Homework 3',.05);
INSERT INTO assignment VALUES(null,'Midterm Exam',.25);
INSERT INTO assignment VALUES(null,'Final Exam',.25);
INSERT INTO assignment VALUES(null,'Final Project',.15);
INSERT INTO assignment VALUES(null,'Attendance',.10);
INSERT INTO assignment VALUES(null,'Participation',.10);


# create state table ################################################

CREATE TABLE state
(
    state_code    CHAR(2)       NOT NULL PRIMARY KEY,
    state_name    VARCHAR(50)   NOT NULL,
    region        VARCHAR(50)   NOT NULL,
    region_prev   VARCHAR(50)   NOT NULL
);

INSERT INTO state VALUES('AL','Alabama','Southeast','Southeast');
INSERT INTO state VALUES('AK','Alaska','Alaska','Northwest');
INSERT INTO state VALUES('AZ','Arizona','Pacific','Pacific');
INSERT INTO state VALUES('AR','Arkansas','Southwest','Southwest');
INSERT INTO state VALUES('CA','California','Pacific','Pacific');
INSERT INTO state VALUES('CO','Colorado','Rockies','Rockies');
INSERT INTO state VALUES('CT','Connecticut','Northeast','Northeast');
INSERT INTO state VALUES('DE','Delaware','Mid-Atlantic','Mid-Atlantic');
INSERT INTO state VALUES('FL','Florida','Southeast','Southeast');
INSERT INTO state VALUES('GA','Georgia','Southeast','Southeast');
INSERT INTO state VALUES('HI','Hawaii','Hawaii','Hawaii');
INSERT INTO state VALUES('ID','Idaho','Northwest','Northwest');
INSERT INTO state VALUES('IL','Illinois','Midwest','Midwest');
INSERT INTO state VALUES('IN','Indiana','Midwest','Midwest');
INSERT INTO state VALUES('IA','Iowa','Central','Central');
INSERT INTO state VALUES('KS','Kansas','Central','Central');
INSERT INTO state VALUES('KY','Kentucky','Southeast','Southeast');
INSERT INTO state VALUES('LA','Louisiana','Southwest','Southwest');
INSERT INTO state VALUES('ME','Maine','Northeast','Northeast');
INSERT INTO state VALUES('MD','Maryland','Mid-Atlantic','Mid-Atlantic');
INSERT INTO state VALUES('MA','Massachusetts','Northeast','Northeast');
INSERT INTO state VALUES('MI','Michigan','Midwest','Midwest');
INSERT INTO state VALUES('MN','Minnesota','Midwest','Midwest');
INSERT INTO state VALUES('MS','Mississippi','Southeast','Southeast');
INSERT INTO state VALUES('MO','Missouri','Central','Central');
INSERT INTO state VALUES('MT','Montana','Rockies','Rockies');
INSERT INTO state VALUES('NE','Nebraska','Central','Central');
INSERT INTO state VALUES('NV','Nevada','Pacific','Pacific');
INSERT INTO state VALUES('NH','New Hampshire','Northeast','Northeast');
INSERT INTO state VALUES('NJ','New Jersey','Northeast','Mid-Atlantic');
INSERT INTO state VALUES('NM','New Mexico','Rockies','Rockies');
INSERT INTO state VALUES('NY','New York','Northeast','Northeast');
INSERT INTO state VALUES('NC','North Carolina','Southeast','Southeast');
INSERT INTO state VALUES('ND','North Dakota','Rockies','Rockies');
INSERT INTO state VALUES('OH','Ohio','Midwest','Midwest');
INSERT INTO state VALUES('OK','Oklahoma','Southwest','Southwest');
INSERT INTO state VALUES('OR','Oregon','Northwest','Northwest');
INSERT INTO state VALUES('PA','Pennsylvania','Mid-Atlantic','Mid-Atlantic');
INSERT INTO state VALUES('RI','Rhode Island','Northeast','Northeast');
INSERT INTO state VALUES('SC','South Carolina','Southeast','Southeast');
INSERT INTO state VALUES('SD','South Dakota','Rockies','Rockies');
INSERT INTO state VALUES('TN','Tennessee','Southeast','Southeast');
INSERT INTO state VALUES('TX','Texas','Southwest','Southwest');
INSERT INTO state VALUES('UT','Utah','Rockies','Rockies');
INSERT INTO state VALUES('VT','Vermont','Northeast','Northeast');
INSERT INTO state VALUES('VA','Virginia','Mid-Atlantic','Mid-Atlantic');
INSERT INTO state VALUES('WA','Washington','Northwest','Northwest');
INSERT INTO state VALUES('WV','West Virginia','Mid-Atlantic','Mid-Atlantic');
INSERT INTO state VALUES('WI','Wisconsin','Midwest','Midwest');
INSERT INTO state VALUES('WY','Wyoming','Rockies','Rockies');


# create dates table ############################################

CREATE TABLE dates
(
    date_id     INT         NOT NULL   PRIMARY KEY,
    full_date   DATETIME    NOT NULL,
    year        INT         NOT NULL,
    month       INT         NOT NULL,
    day         INT         NOT NULL,
    month_name  VARCHAR(15) NOT NULL,
    day_name    VARCHAR(15) NOT NULL,
    day_type    VARCHAR(15) NOT NULL,
    day_julian  INT         NOT NULL,
    week_num    INT         NOT NULL,
    quarter     INT         NOT NULL,
    season      VARCHAR(15) NOT NULL, 
    semester    VARCHAR(15) NOT NULL
);

INSERT INTO dates VALUES(1,'2019-01-01',2019,1,1,'January','Tuesday','holiday',001,00,1,'Winter','Spring'); 
INSERT INTO dates VALUES(2,'2019-01-02',2019,1,2,'January','Wednesday','weekday',002,00,1,'Winter','Spring'); 
INSERT INTO dates VALUES(3,'2019-01-03',2019,1,3,'January','Thursday','weekday',003,00,1,'Winter','Spring'); 
INSERT INTO dates VALUES(4,'2019-01-04',2019,1,4,'January','Friday','weekday',004,00,1,'Winter','Spring'); 
INSERT INTO dates VALUES(5,'2019-01-05',2019,1,5,'January','Saturday','weekend',005,00,1,'Winter','Spring'); 
INSERT INTO dates VALUES(6,'2019-01-06',2019,1,6,'January','Sunday','weekend',006,01,1,'Winter','Spring'); 
INSERT INTO dates VALUES(7,'2019-01-07',2019,1,7,'January','Monday','weekday',007,01,1,'Winter','Spring'); 
INSERT INTO dates VALUES(8,'2019-01-08',2019,1,8,'January','Tuesday','weekday',008,01,1,'Winter','Spring'); 
INSERT INTO dates VALUES(9,'2019-01-09',2019,1,9,'January','Wednesday','weekday',009,01,1,'Winter','Spring'); 
INSERT INTO dates VALUES(10,'2019-01-10',2019,1,10,'January','Thursday','weekday',010,01,1,'Winter','Spring'); 
INSERT INTO dates VALUES(11,'2019-01-11',2019,1,11,'January','Friday','weekday',011,01,1,'Winter','Spring'); 
INSERT INTO dates VALUES(12,'2019-01-12',2019,1,12,'January','Saturday','weekend',012,01,1,'Winter','Spring'); 
INSERT INTO dates VALUES(13,'2019-01-13',2019,1,13,'January','Sunday','weekend',013,02,1,'Winter','Spring'); 
INSERT INTO dates VALUES(14,'2019-01-14',2019,1,14,'January','Monday','weekday',014,02,1,'Winter','Spring'); 
INSERT INTO dates VALUES(15,'2019-01-15',2019,1,15,'January','Tuesday','weekday',015,02,1,'Winter','Spring'); 
INSERT INTO dates VALUES(16,'2019-01-16',2019,1,16,'January','Wednesday','weekday',016,02,1,'Winter','Spring'); 
INSERT INTO dates VALUES(17,'2019-01-17',2019,1,17,'January','Thursday','weekday',017,02,1,'Winter','Spring'); 
INSERT INTO dates VALUES(18,'2019-01-18',2019,1,18,'January','Friday','weekday',018,02,1,'Winter','Spring'); 
INSERT INTO dates VALUES(19,'2019-01-19',2019,1,19,'January','Saturday','weekend',019,02,1,'Winter','Spring'); 
INSERT INTO dates VALUES(20,'2019-01-20',2019,1,20,'January','Sunday','weekend',020,03,1,'Winter','Spring'); 
INSERT INTO dates VALUES(21,'2019-01-21',2019,1,21,'January','Monday','weekday',021,03,1,'Winter','Spring'); 
INSERT INTO dates VALUES(22,'2019-01-22',2019,1,22,'January','Tuesday','weekday',022,03,1,'Winter','Spring'); 
INSERT INTO dates VALUES(23,'2019-01-23',2019,1,23,'January','Wednesday','weekday',023,03,1,'Winter','Spring'); 
INSERT INTO dates VALUES(24,'2019-01-24',2019,1,24,'January','Thursday','weekday',024,03,1,'Winter','Spring'); 
INSERT INTO dates VALUES(25,'2019-01-25',2019,1,25,'January','Friday','weekday',025,03,1,'Winter','Spring'); 
INSERT INTO dates VALUES(26,'2019-01-26',2019,1,26,'January','Saturday','weekend',026,03,1,'Winter','Spring'); 
INSERT INTO dates VALUES(27,'2019-01-27',2019,1,27,'January','Sunday','weekend',027,04,1,'Winter','Spring'); 
INSERT INTO dates VALUES(28,'2019-01-28',2019,1,28,'January','Monday','weekday',028,04,1,'Winter','Spring'); 
INSERT INTO dates VALUES(29,'2019-01-29',2019,1,29,'January','Tuesday','weekday',029,04,1,'Winter','Spring'); 
INSERT INTO dates VALUES(30,'2019-01-30',2019,1,30,'January','Wednesday','weekday',030,04,1,'Winter','Spring'); 
INSERT INTO dates VALUES(31,'2019-01-31',2019,1,31,'January','Thursday','weekday',031,04,1,'Winter','Spring'); 
INSERT INTO dates VALUES(32,'2019-02-01',2019,2,1,'February','Friday','weekday',032,04,1,'Winter','Spring'); 
INSERT INTO dates VALUES(33,'2019-02-02',2019,2,2,'February','Saturday','weekend',033,04,1,'Winter','Spring'); 
INSERT INTO dates VALUES(34,'2019-02-03',2019,2,3,'February','Sunday','weekend',034,05,1,'Winter','Spring'); 
INSERT INTO dates VALUES(35,'2019-02-04',2019,2,4,'February','Monday','weekday',035,05,1,'Winter','Spring'); 
INSERT INTO dates VALUES(36,'2019-02-05',2019,2,5,'February','Tuesday','weekday',036,05,1,'Winter','Spring'); 
INSERT INTO dates VALUES(37,'2019-02-06',2019,2,6,'February','Wednesday','weekday',037,05,1,'Winter','Spring'); 
INSERT INTO dates VALUES(38,'2019-02-07',2019,2,7,'February','Thursday','weekday',038,05,1,'Winter','Spring'); 
INSERT INTO dates VALUES(39,'2019-02-08',2019,2,8,'February','Friday','weekday',039,05,1,'Winter','Spring'); 
INSERT INTO dates VALUES(40,'2019-02-09',2019,2,9,'February','Saturday','weekend',040,05,1,'Winter','Spring'); 
INSERT INTO dates VALUES(41,'2019-02-10',2019,2,10,'February','Sunday','weekend',041,06,1,'Winter','Spring'); 
INSERT INTO dates VALUES(42,'2019-02-11',2019,2,11,'February','Monday','weekday',042,06,1,'Winter','Spring'); 
INSERT INTO dates VALUES(43,'2019-02-12',2019,2,12,'February','Tuesday','weekday',043,06,1,'Winter','Spring'); 
INSERT INTO dates VALUES(44,'2019-02-13',2019,2,13,'February','Wednesday','weekday',044,06,1,'Winter','Spring'); 
INSERT INTO dates VALUES(45,'2019-02-14',2019,2,14,'February','Thursday','weekday',045,06,1,'Winter','Spring'); 
INSERT INTO dates VALUES(46,'2019-02-15',2019,2,15,'February','Friday','weekday',046,06,1,'Winter','Spring'); 
INSERT INTO dates VALUES(47,'2019-02-16',2019,2,16,'February','Saturday','weekend',047,06,1,'Winter','Spring'); 
INSERT INTO dates VALUES(48,'2019-02-17',2019,2,17,'February','Sunday','weekend',048,07,1,'Winter','Spring'); 
INSERT INTO dates VALUES(49,'2019-02-18',2019,2,18,'February','Monday','holiday',049,07,1,'Winter','Spring'); 
INSERT INTO dates VALUES(50,'2019-02-19',2019,2,19,'February','Tuesday','weekday',050,07,1,'Winter','Spring'); 
INSERT INTO dates VALUES(51,'2019-02-20',2019,2,20,'February','Wednesday','weekday',051,07,1,'Winter','Spring'); 
INSERT INTO dates VALUES(52,'2019-02-21',2019,2,21,'February','Thursday','weekday',052,07,1,'Winter','Spring'); 
INSERT INTO dates VALUES(53,'2019-02-22',2019,2,22,'February','Friday','weekday',053,07,1,'Winter','Spring'); 
INSERT INTO dates VALUES(54,'2019-02-23',2019,2,23,'February','Saturday','weekend',054,07,1,'Winter','Spring'); 
INSERT INTO dates VALUES(55,'2019-02-24',2019,2,24,'February','Sunday','weekend',055,08,1,'Winter','Spring'); 
INSERT INTO dates VALUES(56,'2019-02-25',2019,2,25,'February','Monday','weekday',056,08,1,'Winter','Spring'); 
INSERT INTO dates VALUES(57,'2019-02-26',2019,2,26,'February','Tuesday','weekday',057,08,1,'Winter','Spring'); 
INSERT INTO dates VALUES(58,'2019-02-27',2019,2,27,'February','Wednesday','weekday',058,08,1,'Winter','Spring'); 
INSERT INTO dates VALUES(59,'2019-02-28',2019,2,28,'February','Thursday','weekday',059,08,1,'Winter','Spring'); 
INSERT INTO dates VALUES(60,'2019-03-01',2019,3,1,'March','Friday','weekday',060,08,1,'Spring','Spring'); 
INSERT INTO dates VALUES(61,'2019-03-02',2019,3,2,'March','Saturday','weekend',061,08,1,'Spring','Spring'); 
INSERT INTO dates VALUES(62,'2019-03-03',2019,3,3,'March','Sunday','weekend',062,09,1,'Spring','Spring'); 
INSERT INTO dates VALUES(63,'2019-03-04',2019,3,4,'March','Monday','weekday',063,09,1,'Spring','Spring'); 
INSERT INTO dates VALUES(64,'2019-03-05',2019,3,5,'March','Tuesday','weekday',064,09,1,'Spring','Spring'); 
INSERT INTO dates VALUES(65,'2019-03-06',2019,3,6,'March','Wednesday','weekday',065,09,1,'Spring','Spring'); 
INSERT INTO dates VALUES(66,'2019-03-07',2019,3,7,'March','Thursday','weekday',066,09,1,'Spring','Spring'); 
INSERT INTO dates VALUES(67,'2019-03-08',2019,3,8,'March','Friday','weekday',067,09,1,'Spring','Spring'); 
INSERT INTO dates VALUES(68,'2019-03-09',2019,3,9,'March','Saturday','weekend',068,09,1,'Spring','Spring'); 
INSERT INTO dates VALUES(69,'2019-03-10',2019,3,10,'March','Sunday','weekend',069,10,1,'Spring','Spring'); 
INSERT INTO dates VALUES(70,'2019-03-11',2019,3,11,'March','Monday','weekday',070,10,1,'Spring','Spring'); 
INSERT INTO dates VALUES(71,'2019-03-12',2019,3,12,'March','Tuesday','weekday',071,10,1,'Spring','Spring'); 
INSERT INTO dates VALUES(72,'2019-03-13',2019,3,13,'March','Wednesday','weekday',072,10,1,'Spring','Spring'); 
INSERT INTO dates VALUES(73,'2019-03-14',2019,3,14,'March','Thursday','weekday',073,10,1,'Spring','Spring'); 
INSERT INTO dates VALUES(74,'2019-03-15',2019,3,15,'March','Friday','weekday',074,10,1,'Spring','Spring'); 
INSERT INTO dates VALUES(75,'2019-03-16',2019,3,16,'March','Saturday','weekend',075,10,1,'Spring','Spring'); 
INSERT INTO dates VALUES(76,'2019-03-17',2019,3,17,'March','Sunday','weekend',076,11,1,'Spring','Spring'); 
INSERT INTO dates VALUES(77,'2019-03-18',2019,3,18,'March','Monday','weekday',077,11,1,'Spring','Spring'); 
INSERT INTO dates VALUES(78,'2019-03-19',2019,3,19,'March','Tuesday','weekday',078,11,1,'Spring','Spring'); 
INSERT INTO dates VALUES(79,'2019-03-20',2019,3,20,'March','Wednesday','weekday',079,11,1,'Spring','Spring'); 
INSERT INTO dates VALUES(80,'2019-03-21',2019,3,21,'March','Thursday','weekday',080,11,1,'Spring','Spring'); 
INSERT INTO dates VALUES(81,'2019-03-22',2019,3,22,'March','Friday','weekday',081,11,1,'Spring','Spring'); 
INSERT INTO dates VALUES(82,'2019-03-23',2019,3,23,'March','Saturday','weekend',082,11,1,'Spring','Spring'); 
INSERT INTO dates VALUES(83,'2019-03-24',2019,3,24,'March','Sunday','weekend',083,12,1,'Spring','Spring'); 
INSERT INTO dates VALUES(84,'2019-03-25',2019,3,25,'March','Monday','weekday',084,12,1,'Spring','Spring'); 
INSERT INTO dates VALUES(85,'2019-03-26',2019,3,26,'March','Tuesday','weekday',085,12,1,'Spring','Spring'); 
INSERT INTO dates VALUES(86,'2019-03-27',2019,3,27,'March','Wednesday','weekday',086,12,1,'Spring','Spring'); 
INSERT INTO dates VALUES(87,'2019-03-28',2019,3,28,'March','Thursday','weekday',087,12,1,'Spring','Spring'); 
INSERT INTO dates VALUES(88,'2019-03-29',2019,3,29,'March','Friday','weekday',088,12,1,'Spring','Spring'); 
INSERT INTO dates VALUES(89,'2019-03-30',2019,3,30,'March','Saturday','weekend',089,12,1,'Spring','Spring'); 
INSERT INTO dates VALUES(90,'2019-03-31',2019,3,31,'March','Sunday','weekend',090,13,1,'Spring','Spring'); 
INSERT INTO dates VALUES(91,'2019-04-01',2019,4,1,'April','Monday','weekday',091,13,2,'Spring','Spring'); 
INSERT INTO dates VALUES(92,'2019-04-02',2019,4,2,'April','Tuesday','weekday',092,13,2,'Spring','Spring'); 
INSERT INTO dates VALUES(93,'2019-04-03',2019,4,3,'April','Wednesday','weekday',093,13,2,'Spring','Spring'); 
INSERT INTO dates VALUES(94,'2019-04-04',2019,4,4,'April','Thursday','weekday',094,13,2,'Spring','Spring'); 
INSERT INTO dates VALUES(95,'2019-04-05',2019,4,5,'April','Friday','weekday',095,13,2,'Spring','Spring'); 
INSERT INTO dates VALUES(96,'2019-04-06',2019,4,6,'April','Saturday','weekend',096,13,2,'Spring','Spring'); 
INSERT INTO dates VALUES(97,'2019-04-07',2019,4,7,'April','Sunday','weekend',097,14,2,'Spring','Spring'); 
INSERT INTO dates VALUES(98,'2019-04-08',2019,4,8,'April','Monday','weekday',098,14,2,'Spring','Spring'); 
INSERT INTO dates VALUES(99,'2019-04-09',2019,4,9,'April','Tuesday','weekday',099,14,2,'Spring','Spring'); 
INSERT INTO dates VALUES(100,'2019-04-10',2019,4,10,'April','Wednesday','weekday',100,14,2,'Spring','Spring'); 
INSERT INTO dates VALUES(101,'2019-04-11',2019,4,11,'April','Thursday','weekday',101,14,2,'Spring','Spring'); 
INSERT INTO dates VALUES(102,'2019-04-12',2019,4,12,'April','Friday','weekday',102,14,2,'Spring','Spring'); 
INSERT INTO dates VALUES(103,'2019-04-13',2019,4,13,'April','Saturday','weekend',103,14,2,'Spring','Spring'); 
INSERT INTO dates VALUES(104,'2019-04-14',2019,4,14,'April','Sunday','weekend',104,15,2,'Spring','Spring'); 
INSERT INTO dates VALUES(105,'2019-04-15',2019,4,15,'April','Monday','weekday',105,15,2,'Spring','Spring'); 
INSERT INTO dates VALUES(106,'2019-04-16',2019,4,16,'April','Tuesday','weekday',106,15,2,'Spring','Spring'); 
INSERT INTO dates VALUES(107,'2019-04-17',2019,4,17,'April','Wednesday','weekday',107,15,2,'Spring','Spring'); 
INSERT INTO dates VALUES(108,'2019-04-18',2019,4,18,'April','Thursday','weekday',108,15,2,'Spring','Spring'); 
INSERT INTO dates VALUES(109,'2019-04-19',2019,4,19,'April','Friday','weekday',109,15,2,'Spring','Spring'); 
INSERT INTO dates VALUES(110,'2019-04-20',2019,4,20,'April','Saturday','weekend',110,15,2,'Spring','Spring'); 
INSERT INTO dates VALUES(111,'2019-04-21',2019,4,21,'April','Sunday','holiday',111,16,2,'Spring','Spring'); 
INSERT INTO dates VALUES(112,'2019-04-22',2019,4,22,'April','Monday','weekday',112,16,2,'Spring','Spring'); 
INSERT INTO dates VALUES(113,'2019-04-23',2019,4,23,'April','Tuesday','weekday',113,16,2,'Spring','Spring'); 
INSERT INTO dates VALUES(114,'2019-04-24',2019,4,24,'April','Wednesday','weekday',114,16,2,'Spring','Spring'); 
INSERT INTO dates VALUES(115,'2019-04-25',2019,4,25,'April','Thursday','weekday',115,16,2,'Spring','Spring'); 
INSERT INTO dates VALUES(116,'2019-04-26',2019,4,26,'April','Friday','weekday',116,16,2,'Spring','Spring'); 
INSERT INTO dates VALUES(117,'2019-04-27',2019,4,27,'April','Saturday','weekend',117,16,2,'Spring','Spring'); 
INSERT INTO dates VALUES(118,'2019-04-28',2019,4,28,'April','Sunday','weekend',118,17,2,'Spring','Spring'); 
INSERT INTO dates VALUES(119,'2019-04-29',2019,4,29,'April','Monday','weekday',119,17,2,'Spring','Spring'); 
INSERT INTO dates VALUES(120,'2019-04-30',2019,4,30,'April','Tuesday','weekday',120,17,2,'Spring','Spring'); 
INSERT INTO dates VALUES(121,'2019-05-01',2019,5,1,'May','Wednesday','weekday',121,17,2,'Spring','Spring'); 
INSERT INTO dates VALUES(122,'2019-05-02',2019,5,2,'May','Thursday','weekday',122,17,2,'Spring','Spring'); 
INSERT INTO dates VALUES(123,'2019-05-03',2019,5,3,'May','Friday','weekday',123,17,2,'Spring','Spring'); 
INSERT INTO dates VALUES(124,'2019-05-04',2019,5,4,'May','Saturday','weekend',124,17,2,'Spring','Spring'); 
INSERT INTO dates VALUES(125,'2019-05-05',2019,5,5,'May','Sunday','weekend',125,18,2,'Spring','Spring'); 
INSERT INTO dates VALUES(126,'2019-05-06',2019,5,6,'May','Monday','weekday',126,18,2,'Spring','Spring'); 
INSERT INTO dates VALUES(127,'2019-05-07',2019,5,7,'May','Tuesday','weekday',127,18,2,'Spring','Spring'); 
INSERT INTO dates VALUES(128,'2019-05-08',2019,5,8,'May','Wednesday','weekday',128,18,2,'Spring','Spring'); 
INSERT INTO dates VALUES(129,'2019-05-09',2019,5,9,'May','Thursday','weekday',129,18,2,'Spring','Spring'); 
INSERT INTO dates VALUES(130,'2019-05-10',2019,5,10,'May','Friday','weekday',130,18,2,'Spring','Spring'); 
INSERT INTO dates VALUES(131,'2019-05-11',2019,5,11,'May','Saturday','weekend',131,18,2,'Spring','Spring'); 
INSERT INTO dates VALUES(132,'2019-05-12',2019,5,12,'May','Sunday','weekend',132,19,2,'Spring','Spring'); 
INSERT INTO dates VALUES(133,'2019-05-13',2019,5,13,'May','Monday','weekday',133,19,2,'Spring','Spring'); 
INSERT INTO dates VALUES(134,'2019-05-14',2019,5,14,'May','Tuesday','weekday',134,19,2,'Spring','Spring'); 
INSERT INTO dates VALUES(135,'2019-05-15',2019,5,15,'May','Wednesday','weekday',135,19,2,'Spring','Spring'); 
INSERT INTO dates VALUES(136,'2019-05-16',2019,5,16,'May','Thursday','weekday',136,19,2,'Spring','Spring'); 
INSERT INTO dates VALUES(137,'2019-05-17',2019,5,17,'May','Friday','weekday',137,19,2,'Spring','Spring'); 
INSERT INTO dates VALUES(138,'2019-05-18',2019,5,18,'May','Saturday','weekend',138,19,2,'Spring','Spring'); 
INSERT INTO dates VALUES(139,'2019-05-19',2019,5,19,'May','Sunday','weekend',139,20,2,'Spring','Spring'); 
INSERT INTO dates VALUES(140,'2019-05-20',2019,5,20,'May','Monday','weekday',140,20,2,'Spring','Spring'); 
INSERT INTO dates VALUES(141,'2019-05-21',2019,5,21,'May','Tuesday','weekday',141,20,2,'Spring','Spring'); 
INSERT INTO dates VALUES(142,'2019-05-22',2019,5,22,'May','Wednesday','weekday',142,20,2,'Spring','Spring'); 
INSERT INTO dates VALUES(143,'2019-05-23',2019,5,23,'May','Thursday','weekday',143,20,2,'Spring','Spring'); 
INSERT INTO dates VALUES(144,'2019-05-24',2019,5,24,'May','Friday','weekday',144,20,2,'Spring','Spring'); 
INSERT INTO dates VALUES(145,'2019-05-25',2019,5,25,'May','Saturday','weekend',145,20,2,'Spring','Spring'); 
INSERT INTO dates VALUES(146,'2019-05-26',2019,5,26,'May','Sunday','weekend',146,21,2,'Spring','Spring'); 
INSERT INTO dates VALUES(147,'2019-05-27',2019,5,27,'May','Monday','holiday',147,21,2,'Spring','Spring'); 
INSERT INTO dates VALUES(148,'2019-05-28',2019,5,28,'May','Tuesday','weekday',148,21,2,'Spring','Spring'); 
INSERT INTO dates VALUES(149,'2019-05-29',2019,5,29,'May','Wednesday','weekday',149,21,2,'Spring','Spring'); 
INSERT INTO dates VALUES(150,'2019-05-30',2019,5,30,'May','Thursday','weekday',150,21,2,'Spring','Spring'); 
INSERT INTO dates VALUES(151,'2019-05-31',2019,5,31,'May','Friday','weekday',151,21,2,'Spring','Spring'); 
INSERT INTO dates VALUES(152,'2019-06-01',2019,6,1,'June','Saturday','weekend',152,21,2,'Summer','Summer'); 
INSERT INTO dates VALUES(153,'2019-06-02',2019,6,2,'June','Sunday','weekend',153,22,2,'Summer','Summer'); 
INSERT INTO dates VALUES(154,'2019-06-03',2019,6,3,'June','Monday','weekday',154,22,2,'Summer','Summer'); 
INSERT INTO dates VALUES(155,'2019-06-04',2019,6,4,'June','Tuesday','weekday',155,22,2,'Summer','Summer'); 
INSERT INTO dates VALUES(156,'2019-06-05',2019,6,5,'June','Wednesday','weekday',156,22,2,'Summer','Summer'); 
INSERT INTO dates VALUES(157,'2019-06-06',2019,6,6,'June','Thursday','weekday',157,22,2,'Summer','Summer'); 
INSERT INTO dates VALUES(158,'2019-06-07',2019,6,7,'June','Friday','weekday',158,22,2,'Summer','Summer'); 
INSERT INTO dates VALUES(159,'2019-06-08',2019,6,8,'June','Saturday','weekend',159,22,2,'Summer','Summer'); 
INSERT INTO dates VALUES(160,'2019-06-09',2019,6,9,'June','Sunday','weekend',160,23,2,'Summer','Summer'); 
INSERT INTO dates VALUES(161,'2019-06-10',2019,6,10,'June','Monday','weekday',161,23,2,'Summer','Summer'); 
INSERT INTO dates VALUES(162,'2019-06-11',2019,6,11,'June','Tuesday','weekday',162,23,2,'Summer','Summer'); 
INSERT INTO dates VALUES(163,'2019-06-12',2019,6,12,'June','Wednesday','weekday',163,23,2,'Summer','Summer'); 
INSERT INTO dates VALUES(164,'2019-06-13',2019,6,13,'June','Thursday','weekday',164,23,2,'Summer','Summer'); 
INSERT INTO dates VALUES(165,'2019-06-14',2019,6,14,'June','Friday','weekday',165,23,2,'Summer','Summer'); 
INSERT INTO dates VALUES(166,'2019-06-15',2019,6,15,'June','Saturday','weekend',166,23,2,'Summer','Summer'); 
INSERT INTO dates VALUES(167,'2019-06-16',2019,6,16,'June','Sunday','weekend',167,24,2,'Summer','Summer'); 
INSERT INTO dates VALUES(168,'2019-06-17',2019,6,17,'June','Monday','weekday',168,24,2,'Summer','Summer'); 
INSERT INTO dates VALUES(169,'2019-06-18',2019,6,18,'June','Tuesday','weekday',169,24,2,'Summer','Summer'); 
INSERT INTO dates VALUES(170,'2019-06-19',2019,6,19,'June','Wednesday','weekday',170,24,2,'Summer','Summer'); 
INSERT INTO dates VALUES(171,'2019-06-20',2019,6,20,'June','Thursday','weekday',171,24,2,'Summer','Summer'); 
INSERT INTO dates VALUES(172,'2019-06-21',2019,6,21,'June','Friday','weekday',172,24,2,'Summer','Summer'); 
INSERT INTO dates VALUES(173,'2019-06-22',2019,6,22,'June','Saturday','weekend',173,24,2,'Summer','Summer'); 
INSERT INTO dates VALUES(174,'2019-06-23',2019,6,23,'June','Sunday','weekend',174,25,2,'Summer','Summer'); 
INSERT INTO dates VALUES(175,'2019-06-24',2019,6,24,'June','Monday','weekday',175,25,2,'Summer','Summer'); 
INSERT INTO dates VALUES(176,'2019-06-25',2019,6,25,'June','Tuesday','weekday',176,25,2,'Summer','Summer'); 
INSERT INTO dates VALUES(177,'2019-06-26',2019,6,26,'June','Wednesday','weekday',177,25,2,'Summer','Summer'); 
INSERT INTO dates VALUES(178,'2019-06-27',2019,6,27,'June','Thursday','weekday',178,25,2,'Summer','Summer'); 
INSERT INTO dates VALUES(179,'2019-06-28',2019,6,28,'June','Friday','weekday',179,25,2,'Summer','Summer'); 
INSERT INTO dates VALUES(180,'2019-06-29',2019,6,29,'June','Saturday','weekend',180,25,2,'Summer','Summer'); 
INSERT INTO dates VALUES(181,'2019-06-30',2019,6,30,'June','Sunday','weekend',181,26,2,'Summer','Summer'); 
INSERT INTO dates VALUES(182,'2019-07-01',2019,7,1,'July','Monday','weekday',182,26,3,'Summer','Summer'); 
INSERT INTO dates VALUES(183,'2019-07-02',2019,7,2,'July','Tuesday','weekday',183,26,3,'Summer','Summer'); 
INSERT INTO dates VALUES(184,'2019-07-03',2019,7,3,'July','Wednesday','weekday',184,26,3,'Summer','Summer'); 
INSERT INTO dates VALUES(185,'2019-07-04',2019,7,4,'July','Thursday','holiday',185,26,3,'Summer','Summer'); 
INSERT INTO dates VALUES(186,'2019-07-05',2019,7,5,'July','Friday','weekday',186,26,3,'Summer','Summer'); 
INSERT INTO dates VALUES(187,'2019-07-06',2019,7,6,'July','Saturday','weekend',187,26,3,'Summer','Summer'); 
INSERT INTO dates VALUES(188,'2019-07-07',2019,7,7,'July','Sunday','weekend',188,27,3,'Summer','Summer'); 
INSERT INTO dates VALUES(189,'2019-07-08',2019,7,8,'July','Monday','weekday',189,27,3,'Summer','Summer'); 
INSERT INTO dates VALUES(190,'2019-07-09',2019,7,9,'July','Tuesday','weekday',190,27,3,'Summer','Summer'); 
INSERT INTO dates VALUES(191,'2019-07-10',2019,7,10,'July','Wednesday','weekday',191,27,3,'Summer','Summer'); 
INSERT INTO dates VALUES(192,'2019-07-11',2019,7,11,'July','Thursday','weekday',192,27,3,'Summer','Summer'); 
INSERT INTO dates VALUES(193,'2019-07-12',2019,7,12,'July','Friday','weekday',193,27,3,'Summer','Summer'); 
INSERT INTO dates VALUES(194,'2019-07-13',2019,7,13,'July','Saturday','weekend',194,27,3,'Summer','Summer'); 
INSERT INTO dates VALUES(195,'2019-07-14',2019,7,14,'July','Sunday','weekend',195,28,3,'Summer','Summer'); 
INSERT INTO dates VALUES(196,'2019-07-15',2019,7,15,'July','Monday','weekday',196,28,3,'Summer','Summer'); 
INSERT INTO dates VALUES(197,'2019-07-16',2019,7,16,'July','Tuesday','weekday',197,28,3,'Summer','Summer'); 
INSERT INTO dates VALUES(198,'2019-07-17',2019,7,17,'July','Wednesday','weekday',198,28,3,'Summer','Summer'); 
INSERT INTO dates VALUES(199,'2019-07-18',2019,7,18,'July','Thursday','weekday',199,28,3,'Summer','Summer'); 
INSERT INTO dates VALUES(200,'2019-07-19',2019,7,19,'July','Friday','weekday',200,28,3,'Summer','Summer'); 
INSERT INTO dates VALUES(201,'2019-07-20',2019,7,20,'July','Saturday','weekend',201,28,3,'Summer','Summer'); 
INSERT INTO dates VALUES(202,'2019-07-21',2019,7,21,'July','Sunday','weekend',202,29,3,'Summer','Summer'); 
INSERT INTO dates VALUES(203,'2019-07-22',2019,7,22,'July','Monday','weekday',203,29,3,'Summer','Summer'); 
INSERT INTO dates VALUES(204,'2019-07-23',2019,7,23,'July','Tuesday','weekday',204,29,3,'Summer','Summer'); 
INSERT INTO dates VALUES(205,'2019-07-24',2019,7,24,'July','Wednesday','weekday',205,29,3,'Summer','Summer'); 
INSERT INTO dates VALUES(206,'2019-07-25',2019,7,25,'July','Thursday','weekday',206,29,3,'Summer','Summer'); 
INSERT INTO dates VALUES(207,'2019-07-26',2019,7,26,'July','Friday','weekday',207,29,3,'Summer','Summer'); 
INSERT INTO dates VALUES(208,'2019-07-27',2019,7,27,'July','Saturday','weekend',208,29,3,'Summer','Summer'); 
INSERT INTO dates VALUES(209,'2019-07-28',2019,7,28,'July','Sunday','weekend',209,30,3,'Summer','Summer'); 
INSERT INTO dates VALUES(210,'2019-07-29',2019,7,29,'July','Monday','weekday',210,30,3,'Summer','Summer'); 
INSERT INTO dates VALUES(211,'2019-07-30',2019,7,30,'July','Tuesday','weekday',211,30,3,'Summer','Summer'); 
INSERT INTO dates VALUES(212,'2019-07-31',2019,7,31,'July','Wednesday','weekday',212,30,3,'Summer','Summer'); 
INSERT INTO dates VALUES(213,'2019-08-01',2019,8,1,'August','Thursday','weekday',213,30,3,'Summer','Summer'); 
INSERT INTO dates VALUES(214,'2019-08-02',2019,8,2,'August','Friday','weekday',214,30,3,'Summer','Summer'); 
INSERT INTO dates VALUES(215,'2019-08-03',2019,8,3,'August','Saturday','weekend',215,30,3,'Summer','Summer'); 
INSERT INTO dates VALUES(216,'2019-08-04',2019,8,4,'August','Sunday','weekend',216,31,3,'Summer','Summer'); 
INSERT INTO dates VALUES(217,'2019-08-05',2019,8,5,'August','Monday','weekday',217,31,3,'Summer','Summer'); 
INSERT INTO dates VALUES(218,'2019-08-06',2019,8,6,'August','Tuesday','weekday',218,31,3,'Summer','Summer'); 
INSERT INTO dates VALUES(219,'2019-08-07',2019,8,7,'August','Wednesday','weekday',219,31,3,'Summer','Summer'); 
INSERT INTO dates VALUES(220,'2019-08-08',2019,8,8,'August','Thursday','weekday',220,31,3,'Summer','Summer'); 
INSERT INTO dates VALUES(221,'2019-08-09',2019,8,9,'August','Friday','weekday',221,31,3,'Summer','Summer'); 
INSERT INTO dates VALUES(222,'2019-08-10',2019,8,10,'August','Saturday','weekend',222,31,3,'Summer','Summer'); 
INSERT INTO dates VALUES(223,'2019-08-11',2019,8,11,'August','Sunday','weekend',223,32,3,'Summer','Summer'); 
INSERT INTO dates VALUES(224,'2019-08-12',2019,8,12,'August','Monday','weekday',224,32,3,'Summer','Summer'); 
INSERT INTO dates VALUES(225,'2019-08-13',2019,8,13,'August','Tuesday','weekday',225,32,3,'Summer','Summer'); 
INSERT INTO dates VALUES(226,'2019-08-14',2019,8,14,'August','Wednesday','weekday',226,32,3,'Summer','Summer'); 
INSERT INTO dates VALUES(227,'2019-08-15',2019,8,15,'August','Thursday','weekday',227,32,3,'Summer','Summer'); 
INSERT INTO dates VALUES(228,'2019-08-16',2019,8,16,'August','Friday','weekday',228,32,3,'Summer','Summer'); 
INSERT INTO dates VALUES(229,'2019-08-17',2019,8,17,'August','Saturday','weekend',229,32,3,'Summer','Summer'); 
INSERT INTO dates VALUES(230,'2019-08-18',2019,8,18,'August','Sunday','weekend',230,33,3,'Summer','Summer'); 
INSERT INTO dates VALUES(231,'2019-08-19',2019,8,19,'August','Monday','weekday',231,33,3,'Summer','Summer'); 
INSERT INTO dates VALUES(232,'2019-08-20',2019,8,20,'August','Tuesday','weekday',232,33,3,'Summer','Summer'); 
INSERT INTO dates VALUES(233,'2019-08-21',2019,8,21,'August','Wednesday','weekday',233,33,3,'Summer','Summer'); 
INSERT INTO dates VALUES(234,'2019-08-22',2019,8,22,'August','Thursday','weekday',234,33,3,'Summer','Summer'); 
INSERT INTO dates VALUES(235,'2019-08-23',2019,8,23,'August','Friday','weekday',235,33,3,'Summer','Summer'); 
INSERT INTO dates VALUES(236,'2019-08-24',2019,8,24,'August','Saturday','weekend',236,33,3,'Summer','Summer'); 
INSERT INTO dates VALUES(237,'2019-08-25',2019,8,25,'August','Sunday','weekend',237,34,3,'Summer','Summer'); 
INSERT INTO dates VALUES(238,'2019-08-26',2019,8,26,'August','Monday','weekday',238,34,3,'Summer','Summer'); 
INSERT INTO dates VALUES(239,'2019-08-27',2019,8,27,'August','Tuesday','weekday',239,34,3,'Summer','Summer'); 
INSERT INTO dates VALUES(240,'2019-08-28',2019,8,28,'August','Wednesday','weekday',240,34,3,'Summer','Summer'); 
INSERT INTO dates VALUES(241,'2019-08-29',2019,8,29,'August','Thursday','weekday',241,34,3,'Summer','Summer'); 
INSERT INTO dates VALUES(242,'2019-08-30',2019,8,30,'August','Friday','weekday',242,34,3,'Summer','Summer'); 
INSERT INTO dates VALUES(243,'2019-08-31',2019,8,31,'August','Saturday','weekend',243,34,3,'Summer','Summer'); 
INSERT INTO dates VALUES(244,'2019-09-01',2019,9,1,'September','Sunday','weekend',244,35,3,'Fall','Fall'); 
INSERT INTO dates VALUES(245,'2019-09-02',2019,9,2,'September','Monday','holiday',245,35,3,'Fall','Fall'); 
INSERT INTO dates VALUES(246,'2019-09-03',2019,9,3,'September','Tuesday','weekday',246,35,3,'Fall','Fall'); 
INSERT INTO dates VALUES(247,'2019-09-04',2019,9,4,'September','Wednesday','weekday',247,35,3,'Fall','Fall'); 
INSERT INTO dates VALUES(248,'2019-09-05',2019,9,5,'September','Thursday','weekday',248,35,3,'Fall','Fall'); 
INSERT INTO dates VALUES(249,'2019-09-06',2019,9,6,'September','Friday','weekday',249,35,3,'Fall','Fall'); 
INSERT INTO dates VALUES(250,'2019-09-07',2019,9,7,'September','Saturday','weekend',250,35,3,'Fall','Fall'); 
INSERT INTO dates VALUES(251,'2019-09-08',2019,9,8,'September','Sunday','weekend',251,36,3,'Fall','Fall'); 
INSERT INTO dates VALUES(252,'2019-09-09',2019,9,9,'September','Monday','weekday',252,36,3,'Fall','Fall'); 
INSERT INTO dates VALUES(253,'2019-09-10',2019,9,10,'September','Tuesday','weekday',253,36,3,'Fall','Fall'); 
INSERT INTO dates VALUES(254,'2019-09-11',2019,9,11,'September','Wednesday','weekday',254,36,3,'Fall','Fall'); 
INSERT INTO dates VALUES(255,'2019-09-12',2019,9,12,'September','Thursday','weekday',255,36,3,'Fall','Fall'); 
INSERT INTO dates VALUES(256,'2019-09-13',2019,9,13,'September','Friday','weekday',256,36,3,'Fall','Fall'); 
INSERT INTO dates VALUES(257,'2019-09-14',2019,9,14,'September','Saturday','weekend',257,36,3,'Fall','Fall'); 
INSERT INTO dates VALUES(258,'2019-09-15',2019,9,15,'September','Sunday','weekend',258,37,3,'Fall','Fall'); 
INSERT INTO dates VALUES(259,'2019-09-16',2019,9,16,'September','Monday','weekday',259,37,3,'Fall','Fall'); 
INSERT INTO dates VALUES(260,'2019-09-17',2019,9,17,'September','Tuesday','weekday',260,37,3,'Fall','Fall'); 
INSERT INTO dates VALUES(261,'2019-09-18',2019,9,18,'September','Wednesday','weekday',261,37,3,'Fall','Fall'); 
INSERT INTO dates VALUES(262,'2019-09-19',2019,9,19,'September','Thursday','weekday',262,37,3,'Fall','Fall'); 
INSERT INTO dates VALUES(263,'2019-09-20',2019,9,20,'September','Friday','weekday',263,37,3,'Fall','Fall'); 
INSERT INTO dates VALUES(264,'2019-09-21',2019,9,21,'September','Saturday','weekend',264,37,3,'Fall','Fall'); 
INSERT INTO dates VALUES(265,'2019-09-22',2019,9,22,'September','Sunday','weekend',265,38,3,'Fall','Fall'); 
INSERT INTO dates VALUES(266,'2019-09-23',2019,9,23,'September','Monday','weekday',266,38,3,'Fall','Fall'); 
INSERT INTO dates VALUES(267,'2019-09-24',2019,9,24,'September','Tuesday','weekday',267,38,3,'Fall','Fall'); 
INSERT INTO dates VALUES(268,'2019-09-25',2019,9,25,'September','Wednesday','weekday',268,38,3,'Fall','Fall'); 
INSERT INTO dates VALUES(269,'2019-09-26',2019,9,26,'September','Thursday','weekday',269,38,3,'Fall','Fall'); 
INSERT INTO dates VALUES(270,'2019-09-27',2019,9,27,'September','Friday','weekday',270,38,3,'Fall','Fall'); 
INSERT INTO dates VALUES(271,'2019-09-28',2019,9,28,'September','Saturday','weekend',271,38,3,'Fall','Fall'); 
INSERT INTO dates VALUES(272,'2019-09-29',2019,9,29,'September','Sunday','weekend',272,39,3,'Fall','Fall'); 
INSERT INTO dates VALUES(273,'2019-09-30',2019,9,30,'September','Monday','weekday',273,39,3,'Fall','Fall'); 
INSERT INTO dates VALUES(274,'2019-10-01',2019,10,1,'October','Tuesday','weekday',274,39,4,'Fall','Fall'); 
INSERT INTO dates VALUES(275,'2019-10-02',2019,10,2,'October','Wednesday','weekday',275,39,4,'Fall','Fall'); 
INSERT INTO dates VALUES(276,'2019-10-03',2019,10,3,'October','Thursday','weekday',276,39,4,'Fall','Fall'); 
INSERT INTO dates VALUES(277,'2019-10-04',2019,10,4,'October','Friday','weekday',277,39,4,'Fall','Fall'); 
INSERT INTO dates VALUES(278,'2019-10-05',2019,10,5,'October','Saturday','weekend',278,39,4,'Fall','Fall'); 
INSERT INTO dates VALUES(279,'2019-10-06',2019,10,6,'October','Sunday','weekend',279,40,4,'Fall','Fall'); 
INSERT INTO dates VALUES(280,'2019-10-07',2019,10,7,'October','Monday','weekday',280,40,4,'Fall','Fall'); 
INSERT INTO dates VALUES(281,'2019-10-08',2019,10,8,'October','Tuesday','weekday',281,40,4,'Fall','Fall'); 
INSERT INTO dates VALUES(282,'2019-10-09',2019,10,9,'October','Wednesday','weekday',282,40,4,'Fall','Fall'); 
INSERT INTO dates VALUES(283,'2019-10-10',2019,10,10,'October','Thursday','weekday',283,40,4,'Fall','Fall'); 
INSERT INTO dates VALUES(284,'2019-10-11',2019,10,11,'October','Friday','weekday',284,40,4,'Fall','Fall'); 
INSERT INTO dates VALUES(285,'2019-10-12',2019,10,12,'October','Saturday','weekend',285,40,4,'Fall','Fall'); 
INSERT INTO dates VALUES(286,'2019-10-13',2019,10,13,'October','Sunday','weekend',286,41,4,'Fall','Fall'); 
INSERT INTO dates VALUES(287,'2019-10-14',2019,10,14,'October','Monday','weekday',287,41,4,'Fall','Fall'); 
INSERT INTO dates VALUES(288,'2019-10-15',2019,10,15,'October','Tuesday','weekday',288,41,4,'Fall','Fall'); 
INSERT INTO dates VALUES(289,'2019-10-16',2019,10,16,'October','Wednesday','weekday',289,41,4,'Fall','Fall'); 
INSERT INTO dates VALUES(290,'2019-10-17',2019,10,17,'October','Thursday','weekday',290,41,4,'Fall','Fall'); 
INSERT INTO dates VALUES(291,'2019-10-18',2019,10,18,'October','Friday','weekday',291,41,4,'Fall','Fall'); 
INSERT INTO dates VALUES(292,'2019-10-19',2019,10,19,'October','Saturday','weekend',292,41,4,'Fall','Fall'); 
INSERT INTO dates VALUES(293,'2019-10-20',2019,10,20,'October','Sunday','weekend',293,42,4,'Fall','Fall'); 
INSERT INTO dates VALUES(294,'2019-10-21',2019,10,21,'October','Monday','weekday',294,42,4,'Fall','Fall'); 
INSERT INTO dates VALUES(295,'2019-10-22',2019,10,22,'October','Tuesday','weekday',295,42,4,'Fall','Fall'); 
INSERT INTO dates VALUES(296,'2019-10-23',2019,10,23,'October','Wednesday','weekday',296,42,4,'Fall','Fall'); 
INSERT INTO dates VALUES(297,'2019-10-24',2019,10,24,'October','Thursday','weekday',297,42,4,'Fall','Fall'); 
INSERT INTO dates VALUES(298,'2019-10-25',2019,10,25,'October','Friday','weekday',298,42,4,'Fall','Fall'); 
INSERT INTO dates VALUES(299,'2019-10-26',2019,10,26,'October','Saturday','weekend',299,42,4,'Fall','Fall'); 
INSERT INTO dates VALUES(300,'2019-10-27',2019,10,27,'October','Sunday','weekend',300,43,4,'Fall','Fall'); 
INSERT INTO dates VALUES(301,'2019-10-28',2019,10,28,'October','Monday','weekday',301,43,4,'Fall','Fall'); 
INSERT INTO dates VALUES(302,'2019-10-29',2019,10,29,'October','Tuesday','weekday',302,43,4,'Fall','Fall'); 
INSERT INTO dates VALUES(303,'2019-10-30',2019,10,30,'October','Wednesday','weekday',303,43,4,'Fall','Fall'); 
INSERT INTO dates VALUES(304,'2019-10-31',2019,10,31,'October','Thursday','weekday',304,43,4,'Fall','Fall'); 
INSERT INTO dates VALUES(305,'2019-11-01',2019,11,1,'November','Friday','weekday',305,43,4,'Fall','Fall'); 
INSERT INTO dates VALUES(306,'2019-11-02',2019,11,2,'November','Saturday','weekend',306,43,4,'Fall','Fall'); 
INSERT INTO dates VALUES(307,'2019-11-03',2019,11,3,'November','Sunday','weekend',307,44,4,'Fall','Fall'); 
INSERT INTO dates VALUES(308,'2019-11-04',2019,11,4,'November','Monday','weekday',308,44,4,'Fall','Fall'); 
INSERT INTO dates VALUES(309,'2019-11-05',2019,11,5,'November','Tuesday','weekday',309,44,4,'Fall','Fall'); 
INSERT INTO dates VALUES(310,'2019-11-06',2019,11,6,'November','Wednesday','weekday',310,44,4,'Fall','Fall'); 
INSERT INTO dates VALUES(311,'2019-11-07',2019,11,7,'November','Thursday','weekday',311,44,4,'Fall','Fall'); 
INSERT INTO dates VALUES(312,'2019-11-08',2019,11,8,'November','Friday','weekday',312,44,4,'Fall','Fall'); 
INSERT INTO dates VALUES(313,'2019-11-09',2019,11,9,'November','Saturday','weekend',313,44,4,'Fall','Fall'); 
INSERT INTO dates VALUES(314,'2019-11-10',2019,11,10,'November','Sunday','weekend',314,45,4,'Fall','Fall'); 
INSERT INTO dates VALUES(315,'2019-11-11',2019,11,11,'November','Monday','weekday',315,45,4,'Fall','Fall'); 
INSERT INTO dates VALUES(316,'2019-11-12',2019,11,12,'November','Tuesday','weekday',316,45,4,'Fall','Fall'); 
INSERT INTO dates VALUES(317,'2019-11-13',2019,11,13,'November','Wednesday','weekday',317,45,4,'Fall','Fall'); 
INSERT INTO dates VALUES(318,'2019-11-14',2019,11,14,'November','Thursday','weekday',318,45,4,'Fall','Fall'); 
INSERT INTO dates VALUES(319,'2019-11-15',2019,11,15,'November','Friday','weekday',319,45,4,'Fall','Fall'); 
INSERT INTO dates VALUES(320,'2019-11-16',2019,11,16,'November','Saturday','weekend',320,45,4,'Fall','Fall'); 
INSERT INTO dates VALUES(321,'2019-11-17',2019,11,17,'November','Sunday','weekend',321,46,4,'Fall','Fall'); 
INSERT INTO dates VALUES(322,'2019-11-18',2019,11,18,'November','Monday','weekday',322,46,4,'Fall','Fall'); 
INSERT INTO dates VALUES(323,'2019-11-19',2019,11,19,'November','Tuesday','weekday',323,46,4,'Fall','Fall'); 
INSERT INTO dates VALUES(324,'2019-11-20',2019,11,20,'November','Wednesday','weekday',324,46,4,'Fall','Fall'); 
INSERT INTO dates VALUES(325,'2019-11-21',2019,11,21,'November','Thursday','weekday',325,46,4,'Fall','Fall'); 
INSERT INTO dates VALUES(326,'2019-11-22',2019,11,22,'November','Friday','weekday',326,46,4,'Fall','Fall'); 
INSERT INTO dates VALUES(327,'2019-11-23',2019,11,23,'November','Saturday','weekend',327,46,4,'Fall','Fall'); 
INSERT INTO dates VALUES(328,'2019-11-24',2019,11,24,'November','Sunday','weekend',328,47,4,'Fall','Fall'); 
INSERT INTO dates VALUES(329,'2019-11-25',2019,11,25,'November','Monday','weekday',329,47,4,'Fall','Fall'); 
INSERT INTO dates VALUES(330,'2019-11-26',2019,11,26,'November','Tuesday','weekday',330,47,4,'Fall','Fall'); 
INSERT INTO dates VALUES(331,'2019-11-27',2019,11,27,'November','Wednesday','weekday',331,47,4,'Fall','Fall'); 
INSERT INTO dates VALUES(332,'2019-11-28',2019,11,28,'November','Thursday','holiday',332,47,4,'Fall','Fall'); 
INSERT INTO dates VALUES(333,'2019-11-29',2019,11,29,'November','Friday','holiday',333,47,4,'Fall','Fall'); 
INSERT INTO dates VALUES(334,'2019-11-30',2019,11,30,'November','Saturday','weekend',334,47,4,'Fall','Fall'); 
INSERT INTO dates VALUES(335,'2019-12-01',2019,12,1,'December','Sunday','weekend',335,48,4,'Winter','Fall'); 
INSERT INTO dates VALUES(336,'2019-12-02',2019,12,2,'December','Monday','weekday',336,48,4,'Winter','Fall'); 
INSERT INTO dates VALUES(337,'2019-12-03',2019,12,3,'December','Tuesday','weekday',337,48,4,'Winter','Fall'); 
INSERT INTO dates VALUES(338,'2019-12-04',2019,12,4,'December','Wednesday','weekday',338,48,4,'Winter','Fall'); 
INSERT INTO dates VALUES(339,'2019-12-05',2019,12,5,'December','Thursday','weekday',339,48,4,'Winter','Fall'); 
INSERT INTO dates VALUES(340,'2019-12-06',2019,12,6,'December','Friday','weekday',340,48,4,'Winter','Fall'); 
INSERT INTO dates VALUES(341,'2019-12-07',2019,12,7,'December','Saturday','weekend',341,48,4,'Winter','Fall'); 
INSERT INTO dates VALUES(342,'2019-12-08',2019,12,8,'December','Sunday','weekend',342,49,4,'Winter','Fall'); 
INSERT INTO dates VALUES(343,'2019-12-09',2019,12,9,'December','Monday','weekday',343,49,4,'Winter','Fall'); 
INSERT INTO dates VALUES(344,'2019-12-10',2019,12,10,'December','Tuesday','weekday',344,49,4,'Winter','Fall'); 
INSERT INTO dates VALUES(345,'2019-12-11',2019,12,11,'December','Wednesday','weekday',345,49,4,'Winter','Fall'); 
INSERT INTO dates VALUES(346,'2019-12-12',2019,12,12,'December','Thursday','weekday',346,49,4,'Winter','Fall'); 
INSERT INTO dates VALUES(347,'2019-12-13',2019,12,13,'December','Friday','weekday',347,49,4,'Winter','Fall'); 
INSERT INTO dates VALUES(348,'2019-12-14',2019,12,14,'December','Saturday','weekend',348,49,4,'Winter','Fall'); 
INSERT INTO dates VALUES(349,'2019-12-15',2019,12,15,'December','Sunday','weekend',349,50,4,'Winter','Fall'); 
INSERT INTO dates VALUES(350,'2019-12-16',2019,12,16,'December','Monday','weekday',350,50,4,'Winter','Fall'); 
INSERT INTO dates VALUES(351,'2019-12-17',2019,12,17,'December','Tuesday','weekday',351,50,4,'Winter','Fall'); 
INSERT INTO dates VALUES(352,'2019-12-18',2019,12,18,'December','Wednesday','weekday',352,50,4,'Winter','Fall'); 
INSERT INTO dates VALUES(353,'2019-12-19',2019,12,19,'December','Thursday','weekday',353,50,4,'Winter','Fall'); 
INSERT INTO dates VALUES(354,'2019-12-20',2019,12,20,'December','Friday','weekday',354,50,4,'Winter','Fall'); 
INSERT INTO dates VALUES(355,'2019-12-21',2019,12,21,'December','Saturday','weekend',355,50,4,'Winter','Fall'); 
INSERT INTO dates VALUES(356,'2019-12-22',2019,12,22,'December','Sunday','weekend',356,51,4,'Winter','Fall'); 
INSERT INTO dates VALUES(357,'2019-12-23',2019,12,23,'December','Monday','weekday',357,51,4,'Winter','Fall'); 
INSERT INTO dates VALUES(358,'2019-12-24',2019,12,24,'December','Tuesday','weekday',358,51,4,'Winter','Fall'); 
INSERT INTO dates VALUES(359,'2019-12-25',2019,12,25,'December','Wednesday','holiday',359,51,4,'Winter','Fall'); 
INSERT INTO dates VALUES(360,'2019-12-26',2019,12,26,'December','Thursday','weekday',360,51,4,'Winter','Fall'); 
INSERT INTO dates VALUES(361,'2019-12-27',2019,12,27,'December','Friday','weekday',361,51,4,'Winter','Fall'); 
INSERT INTO dates VALUES(362,'2019-12-28',2019,12,28,'December','Saturday','weekend',362,51,4,'Winter','Fall'); 
INSERT INTO dates VALUES(363,'2019-12-29',2019,12,29,'December','Sunday','weekend',363,52,4,'Winter','Fall'); 
INSERT INTO dates VALUES(364,'2019-12-30',2019,12,30,'December','Monday','weekday',364,52,4,'Winter','Fall'); 
INSERT INTO dates VALUES(365,'2019-12-31',2019,12,31,'December','Tuesday','weekday',365,52,4,'Winter','Fall'); 


# create grade table ############################################

CREATE TABLE grade
(
    grade_id      INT           NOT NULL PRIMARY KEY AUTO_INCREMENT,
    instructor_id INT           NOT NULL,
    student_id    INT           NOT NULL,
    course_id     INT           NOT NULL,
    assignment_id INT           NOT NULL,
    date_id       INT           NOT NULL,
    grade         INT           NOT NULL,
    percent       DECIMAL(2,2)  NOT NULL,
    value         DECIMAL(6,2)  NOT NULL,

    CONSTRAINT instructor_fk FOREIGN KEY (instructor_id) REFERENCES instructor (instructor_id),
    CONSTRAINT student_fk    FOREIGN KEY (student_id)    REFERENCES student    (student_id),
    CONSTRAINT course_fk     FOREIGN KEY (course_id)     REFERENCES course     (course_id),
    CONSTRAINT assignment_fk FOREIGN KEY (assignment_id) REFERENCES assignment (assignment_id),
    CONSTRAINT date_fk       FOREIGN KEY (date_id)       REFERENCES dates      (date_id)
);

INSERT INTO grade VALUES(0,6,1,1,1,40,81,0.05,4.05);
INSERT INTO grade VALUES(0,6,1,1,2,116,83,0.05,4.15);
INSERT INTO grade VALUES(0,6,1,1,3,124,96,0.05,4.8);
INSERT INTO grade VALUES(0,6,1,1,4,126,76,0.25,19);
INSERT INTO grade VALUES(0,6,1,1,5,281,82,0.25,20.5);
INSERT INTO grade VALUES(0,6,1,1,6,289,82,0.15,12.3);
INSERT INTO grade VALUES(0,2,1,2,1,56,76,0.05,3.8);
INSERT INTO grade VALUES(0,2,1,2,2,233,77,0.05,3.85);
INSERT INTO grade VALUES(0,2,1,2,3,242,73,0.05,3.65);
INSERT INTO grade VALUES(0,2,1,2,4,309,99,0.25,24.75);
INSERT INTO grade VALUES(0,3,1,3,1,10,77,0.05,3.85);
INSERT INTO grade VALUES(0,3,1,3,2,106,82,0.05,4.1);
INSERT INTO grade VALUES(0,3,1,3,3,281,75,0.05,3.75);
INSERT INTO grade VALUES(0,3,1,3,4,324,97,0.25,24.25);
INSERT INTO grade VALUES(0,3,1,3,5,346,81,0.25,20.25);
INSERT INTO grade VALUES(0,1,1,4,1,82,87,0.05,4.35);
INSERT INTO grade VALUES(0,1,1,4,2,150,79,0.05,3.95);
INSERT INTO grade VALUES(0,1,1,4,3,157,75,0.05,3.75);
INSERT INTO grade VALUES(0,1,1,4,4,271,94,0.25,23.5);
INSERT INTO grade VALUES(0,4,1,5,1,8,93,0.05,4.65);
INSERT INTO grade VALUES(0,4,1,5,2,74,80,0.05,4);
INSERT INTO grade VALUES(0,4,1,5,3,172,81,0.05,4.05);
INSERT INTO grade VALUES(0,1,1,6,1,64,82,0.05,4.1);
INSERT INTO grade VALUES(0,1,1,6,2,109,94,0.05,4.7);
INSERT INTO grade VALUES(0,1,1,6,3,142,94,0.05,4.7);
INSERT INTO grade VALUES(0,1,1,6,4,178,71,0.25,17.75);
INSERT INTO grade VALUES(0,1,1,6,5,200,80,0.25,20);
INSERT INTO grade VALUES(0,4,1,6,1,120,86,0.05,4.3);
INSERT INTO grade VALUES(0,4,1,6,2,151,90,0.05,4.5);
INSERT INTO grade VALUES(0,4,1,7,3,330,88,0.05,4.4);
INSERT INTO grade VALUES(0,1,1,9,6,274,80,0.15,12);
INSERT INTO grade VALUES(0,1,1,9,7,327,96,0.1,9.6);
INSERT INTO grade VALUES(0,6,2,1,1,25,92,0.05,4.6);
INSERT INTO grade VALUES(0,6,2,1,2,47,100,0.05,5);
INSERT INTO grade VALUES(0,6,2,1,3,54,77,0.05,3.85);
INSERT INTO grade VALUES(0,6,2,1,4,325,76,0.25,19);
INSERT INTO grade VALUES(0,3,2,2,3,271,84,0.05,4.2);
INSERT INTO grade VALUES(0,3,2,2,4,278,82,0.25,20.5);
INSERT INTO grade VALUES(0,3,2,2,1,294,71,0.05,3.55);
INSERT INTO grade VALUES(0,3,2,2,5,295,79,0.25,19.75);
INSERT INTO grade VALUES(0,3,2,2,6,305,75,0.15,11.25);
INSERT INTO grade VALUES(0,3,2,2,2,344,73,0.05,3.65);
INSERT INTO grade VALUES(0,4,2,3,1,16,99,0.05,4.95);
INSERT INTO grade VALUES(0,4,2,3,2,19,73,0.05,3.65);
INSERT INTO grade VALUES(0,4,2,3,3,29,89,0.05,4.45);
INSERT INTO grade VALUES(0,4,2,3,4,119,98,0.25,24.5);
INSERT INTO grade VALUES(0,4,2,3,5,163,90,0.25,22.5);
INSERT INTO grade VALUES(0,4,2,3,6,239,93,0.15,13.95);
INSERT INTO grade VALUES(0,4,2,3,7,260,76,0.1,7.6);
INSERT INTO grade VALUES(0,4,2,3,8,363,90,0.1,9);
INSERT INTO grade VALUES(0,3,2,4,1,88,86,0.05,4.3);
INSERT INTO grade VALUES(0,3,2,4,2,99,75,0.05,3.75);
INSERT INTO grade VALUES(0,3,2,4,3,147,73,0.05,3.65);
INSERT INTO grade VALUES(0,3,2,4,4,201,97,0.25,24.25);
INSERT INTO grade VALUES(0,3,2,4,5,261,79,0.25,19.75);
INSERT INTO grade VALUES(0,3,2,4,6,340,95,0.15,14.25);
INSERT INTO grade VALUES(0,3,2,5,1,98,74,0.05,3.7);
INSERT INTO grade VALUES(0,3,2,5,2,104,76,0.05,3.8);
INSERT INTO grade VALUES(0,3,2,5,3,108,100,0.05,5);
INSERT INTO grade VALUES(0,3,2,5,4,226,85,0.25,21.25);
INSERT INTO grade VALUES(0,3,2,5,5,283,89,0.25,22.25);
INSERT INTO grade VALUES(0,1,2,6,1,3,91,0.05,4.55);
INSERT INTO grade VALUES(0,1,2,6,2,13,79,0.05,3.95);
INSERT INTO grade VALUES(0,1,2,6,3,14,78,0.05,3.9);
INSERT INTO grade VALUES(0,1,2,6,4,98,93,0.25,23.25);
INSERT INTO grade VALUES(0,1,2,6,5,160,72,0.25,18);
INSERT INTO grade VALUES(0,1,2,6,6,186,79,0.15,11.85);
INSERT INTO grade VALUES(0,1,2,6,7,188,94,0.1,9.4);
INSERT INTO grade VALUES(0,4,2,6,1,28,90,0.05,4.5);
INSERT INTO grade VALUES(0,4,2,6,2,30,80,0.05,4);
INSERT INTO grade VALUES(0,4,2,6,3,156,92,0.05,4.6);
INSERT INTO grade VALUES(0,4,2,6,4,185,98,0.25,24.5);
INSERT INTO grade VALUES(0,4,2,6,5,202,95,0.25,23.75);
INSERT INTO grade VALUES(0,4,2,7,6,355,87,0.15,13.05);
INSERT INTO grade VALUES(0,1,2,9,8,249,79,0.1,7.9);
INSERT INTO grade VALUES(0,6,3,1,3,8,93,0.05,4.65);
INSERT INTO grade VALUES(0,6,3,1,4,88,92,0.25,23);
INSERT INTO grade VALUES(0,6,3,1,5,184,75,0.25,18.75);
INSERT INTO grade VALUES(0,6,3,1,6,212,80,0.15,12);
INSERT INTO grade VALUES(0,6,3,1,7,214,99,0.1,9.9);
INSERT INTO grade VALUES(0,6,3,1,8,248,96,0.1,9.6);
INSERT INTO grade VALUES(0,6,3,1,1,327,75,0.05,3.75);
INSERT INTO grade VALUES(0,6,3,1,2,341,95,0.05,4.75);
INSERT INTO grade VALUES(0,2,3,2,5,49,79,0.25,19.75);
INSERT INTO grade VALUES(0,2,3,2,6,131,89,0.15,13.35);
INSERT INTO grade VALUES(0,2,3,2,7,319,80,0.1,8);
INSERT INTO grade VALUES(0,2,3,2,1,334,72,0.05,3.6);
INSERT INTO grade VALUES(0,2,3,2,2,345,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,3,2,3,352,91,0.05,4.55);
INSERT INTO grade VALUES(0,2,3,2,4,360,82,0.25,20.5);
INSERT INTO grade VALUES(0,2,3,3,1,301,88,0.05,4.4);
INSERT INTO grade VALUES(0,2,3,3,2,321,70,0.05,3.5);
INSERT INTO grade VALUES(0,2,3,3,3,349,81,0.05,4.05);
INSERT INTO grade VALUES(0,2,3,4,1,66,81,0.05,4.05);
INSERT INTO grade VALUES(0,2,3,4,2,68,87,0.05,4.35);
INSERT INTO grade VALUES(0,2,3,4,3,73,82,0.05,4.1);
INSERT INTO grade VALUES(0,2,3,4,4,99,97,0.25,24.25);
INSERT INTO grade VALUES(0,2,3,4,5,134,91,0.25,22.75);
INSERT INTO grade VALUES(0,2,3,4,6,189,93,0.15,13.95);
INSERT INTO grade VALUES(0,2,3,4,7,202,93,0.1,9.3);
INSERT INTO grade VALUES(0,2,3,4,8,210,74,0.1,7.4);
INSERT INTO grade VALUES(0,3,3,5,1,56,93,0.05,4.65);
INSERT INTO grade VALUES(0,3,3,5,2,63,91,0.05,4.55);
INSERT INTO grade VALUES(0,3,3,5,3,143,84,0.05,4.2);
INSERT INTO grade VALUES(0,3,3,5,4,230,86,0.25,21.5);
INSERT INTO grade VALUES(0,3,3,5,5,297,100,0.25,25);
INSERT INTO grade VALUES(0,3,3,5,6,356,96,0.15,14.4);
INSERT INTO grade VALUES(0,1,3,6,1,8,94,0.05,4.7);
INSERT INTO grade VALUES(0,1,3,6,2,18,73,0.05,3.65);
INSERT INTO grade VALUES(0,1,3,6,3,24,81,0.05,4.05);
INSERT INTO grade VALUES(0,1,3,6,4,68,81,0.25,20.25);
INSERT INTO grade VALUES(0,1,3,6,5,114,79,0.25,19.75);
INSERT INTO grade VALUES(0,1,3,6,6,166,99,0.15,14.85);
INSERT INTO grade VALUES(0,1,3,6,4,98,76,0.25,19);
INSERT INTO grade VALUES(0,1,3,6,5,154,86,0.25,21.5);
INSERT INTO grade VALUES(0,1,3,6,6,161,83,0.15,12.45);
INSERT INTO grade VALUES(0,1,3,7,7,236,75,0.1,7.5);
INSERT INTO grade VALUES(0,1,3,7,1,244,98,0.05,4.9);
INSERT INTO grade VALUES(0,1,3,7,8,314,88,0.1,8.8);
INSERT INTO grade VALUES(0,1,3,7,2,332,92,0.05,4.6);
INSERT INTO grade VALUES(0,1,3,7,3,334,92,0.05,4.6);
INSERT INTO grade VALUES(0,1,3,9,7,238,88,0.1,8.8);
INSERT INTO grade VALUES(0,1,3,9,8,317,95,0.1,9.5);
INSERT INTO grade VALUES(0,3,4,1,1,4,73,0.05,3.65);
INSERT INTO grade VALUES(0,3,4,1,2,87,85,0.05,4.25);
INSERT INTO grade VALUES(0,3,4,1,3,176,71,0.05,3.55);
INSERT INTO grade VALUES(0,3,4,1,4,200,76,0.25,19);
INSERT INTO grade VALUES(0,3,4,1,5,232,92,0.25,23);
INSERT INTO grade VALUES(0,3,4,1,6,271,72,0.15,10.8);
INSERT INTO grade VALUES(0,3,4,1,7,277,90,0.1,9);
INSERT INTO grade VALUES(0,3,4,1,8,338,76,0.1,7.6);
INSERT INTO grade VALUES(0,3,4,2,1,51,85,0.05,4.25);
INSERT INTO grade VALUES(0,3,4,2,2,102,75,0.05,3.75);
INSERT INTO grade VALUES(0,3,4,2,3,114,77,0.05,3.85);
INSERT INTO grade VALUES(0,3,4,2,4,143,97,0.25,24.25);
INSERT INTO grade VALUES(0,3,4,2,5,158,88,0.25,22);
INSERT INTO grade VALUES(0,3,4,2,6,330,83,0.15,12.45);
INSERT INTO grade VALUES(0,3,4,2,7,331,85,0.1,8.5);
INSERT INTO grade VALUES(0,3,4,2,8,363,99,0.1,9.9);
INSERT INTO grade VALUES(0,1,4,3,2,51,92,0.05,4.6);
INSERT INTO grade VALUES(0,1,4,3,3,110,97,0.05,4.85);
INSERT INTO grade VALUES(0,1,4,3,4,158,87,0.25,21.75);
INSERT INTO grade VALUES(0,1,4,3,5,169,75,0.25,18.75);
INSERT INTO grade VALUES(0,1,4,3,6,221,84,0.15,12.6);
INSERT INTO grade VALUES(0,1,4,3,7,237,88,0.1,8.8);
INSERT INTO grade VALUES(0,1,4,3,8,292,71,0.1,7.1);
INSERT INTO grade VALUES(0,1,4,3,1,348,85,0.05,4.25);
INSERT INTO grade VALUES(0,4,4,4,1,34,78,0.05,3.9);
INSERT INTO grade VALUES(0,4,4,4,2,36,76,0.05,3.8);
INSERT INTO grade VALUES(0,4,4,4,3,83,75,0.05,3.75);
INSERT INTO grade VALUES(0,4,4,4,4,214,98,0.25,24.5);
INSERT INTO grade VALUES(0,4,4,4,5,284,99,0.25,24.75);
INSERT INTO grade VALUES(0,4,4,4,6,358,88,0.15,13.2);
INSERT INTO grade VALUES(0,6,4,5,1,36,99,0.05,4.95);
INSERT INTO grade VALUES(0,6,4,5,2,72,90,0.05,4.5);
INSERT INTO grade VALUES(0,6,4,5,3,92,80,0.05,4);
INSERT INTO grade VALUES(0,6,4,5,4,271,95,0.25,23.75);
INSERT INTO grade VALUES(0,6,4,5,5,299,95,0.25,23.75);
INSERT INTO grade VALUES(0,4,4,6,1,3,78,0.05,3.9);
INSERT INTO grade VALUES(0,4,4,6,8,16,99,0.1,9.9);
INSERT INTO grade VALUES(0,4,4,6,2,57,100,0.05,5);
INSERT INTO grade VALUES(0,4,4,6,3,120,84,0.05,4.2);
INSERT INTO grade VALUES(0,4,4,6,4,167,76,0.25,19);
INSERT INTO grade VALUES(0,4,4,6,5,170,72,0.25,18);
INSERT INTO grade VALUES(0,1,4,6,1,102,89,0.05,4.45);
INSERT INTO grade VALUES(0,1,4,6,2,210,75,0.05,3.75);
INSERT INTO grade VALUES(0,1,4,7,3,270,76,0.05,3.8);
INSERT INTO grade VALUES(0,1,4,7,4,294,94,0.25,23.5);
INSERT INTO grade VALUES(0,1,4,7,5,307,87,0.25,21.75);
INSERT INTO grade VALUES(0,4,4,9,6,224,83,0.15,12.45);
INSERT INTO grade VALUES(0,4,4,9,7,302,95,0.1,9.5);
INSERT INTO grade VALUES(0,4,5,1,1,10,75,0.05,3.75);
INSERT INTO grade VALUES(0,4,5,1,2,59,92,0.05,4.6);
INSERT INTO grade VALUES(0,4,5,1,3,152,75,0.05,3.75);
INSERT INTO grade VALUES(0,4,5,1,4,235,95,0.25,23.75);
INSERT INTO grade VALUES(0,4,5,1,5,242,86,0.25,21.5);
INSERT INTO grade VALUES(0,4,5,1,6,278,93,0.15,13.95);
INSERT INTO grade VALUES(0,4,5,1,7,281,87,0.1,8.7);
INSERT INTO grade VALUES(0,4,5,1,8,310,92,0.1,9.2);
INSERT INTO grade VALUES(0,2,5,2,4,111,95,0.25,23.75);
INSERT INTO grade VALUES(0,2,5,2,1,205,70,0.05,3.5);
INSERT INTO grade VALUES(0,2,5,2,2,264,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,5,2,3,336,72,0.05,3.6);
INSERT INTO grade VALUES(0,2,5,2,5,347,73,0.25,18.25);
INSERT INTO grade VALUES(0,3,5,3,2,116,92,0.05,4.6);
INSERT INTO grade VALUES(0,3,5,3,3,117,98,0.05,4.9);
INSERT INTO grade VALUES(0,3,5,3,4,161,90,0.25,22.5);
INSERT INTO grade VALUES(0,3,5,3,5,212,94,0.25,23.5);
INSERT INTO grade VALUES(0,3,5,3,6,236,78,0.15,11.7);
INSERT INTO grade VALUES(0,3,5,3,7,265,87,0.1,8.7);
INSERT INTO grade VALUES(0,3,5,3,1,319,89,0.05,4.45);
INSERT INTO grade VALUES(0,6,5,4,1,113,97,0.05,4.85);
INSERT INTO grade VALUES(0,6,5,4,2,184,86,0.05,4.3);
INSERT INTO grade VALUES(0,6,5,4,3,214,93,0.05,4.65);
INSERT INTO grade VALUES(0,6,5,4,4,255,94,0.25,23.5);
INSERT INTO grade VALUES(0,6,5,4,5,291,97,0.25,24.25);
INSERT INTO grade VALUES(0,6,5,4,6,319,90,0.15,13.5);
INSERT INTO grade VALUES(0,6,5,4,7,333,95,0.1,9.5);
INSERT INTO grade VALUES(0,6,5,5,1,32,79,0.05,3.95);
INSERT INTO grade VALUES(0,6,5,5,2,48,85,0.05,4.25);
INSERT INTO grade VALUES(0,6,5,5,3,108,92,0.05,4.6);
INSERT INTO grade VALUES(0,6,5,5,4,141,71,0.25,17.75);
INSERT INTO grade VALUES(0,6,5,5,5,188,75,0.25,18.75);
INSERT INTO grade VALUES(0,6,5,5,6,297,80,0.15,12);
INSERT INTO grade VALUES(0,6,5,5,7,334,87,0.1,8.7);
INSERT INTO grade VALUES(0,1,5,6,1,51,98,0.05,4.9);
INSERT INTO grade VALUES(0,1,5,6,2,60,79,0.05,3.95);
INSERT INTO grade VALUES(0,1,5,6,3,66,74,0.05,3.7);
INSERT INTO grade VALUES(0,1,5,6,4,82,73,0.25,18.25);
INSERT INTO grade VALUES(0,1,5,6,5,85,74,0.25,18.5);
INSERT INTO grade VALUES(0,1,5,6,6,146,78,0.15,11.7);
INSERT INTO grade VALUES(0,1,5,6,7,167,85,0.1,8.5);
INSERT INTO grade VALUES(0,1,5,6,8,167,82,0.1,8.2);
INSERT INTO grade VALUES(0,2,5,6,1,79,76,0.05,3.8);
INSERT INTO grade VALUES(0,2,5,6,2,90,92,0.05,4.6);
INSERT INTO grade VALUES(0,2,5,6,3,204,71,0.05,3.55);
INSERT INTO grade VALUES(0,2,5,7,4,287,95,0.25,23.75);
INSERT INTO grade VALUES(0,2,5,7,5,364,85,0.25,21.25);
INSERT INTO grade VALUES(0,4,6,1,1,187,89,0.05,4.45);
INSERT INTO grade VALUES(0,4,6,1,2,293,79,0.05,3.95);
INSERT INTO grade VALUES(0,4,6,1,3,295,94,0.05,4.7);
INSERT INTO grade VALUES(0,4,6,1,4,295,76,0.25,19);
INSERT INTO grade VALUES(0,6,6,2,2,23,100,0.05,5);
INSERT INTO grade VALUES(0,6,6,2,3,165,70,0.05,3.5);
INSERT INTO grade VALUES(0,6,6,2,4,203,100,0.25,25);
INSERT INTO grade VALUES(0,6,6,2,5,207,76,0.25,19);
INSERT INTO grade VALUES(0,6,6,2,6,213,91,0.15,13.65);
INSERT INTO grade VALUES(0,6,6,2,7,237,97,0.1,9.7);
INSERT INTO grade VALUES(0,6,6,2,1,343,79,0.05,3.95);
INSERT INTO grade VALUES(0,3,6,3,1,158,76,0.05,3.8);
INSERT INTO grade VALUES(0,3,6,3,2,286,100,0.05,5);
INSERT INTO grade VALUES(0,3,6,3,3,295,97,0.05,4.85);
INSERT INTO grade VALUES(0,3,6,3,4,313,82,0.25,20.5);
INSERT INTO grade VALUES(0,1,6,4,1,5,73,0.05,3.65);
INSERT INTO grade VALUES(0,1,6,4,2,9,72,0.05,3.6);
INSERT INTO grade VALUES(0,1,6,4,3,57,76,0.05,3.8);
INSERT INTO grade VALUES(0,1,6,4,4,186,83,0.25,20.75);
INSERT INTO grade VALUES(0,1,6,4,5,248,70,0.25,17.5);
INSERT INTO grade VALUES(0,1,6,4,6,304,90,0.15,13.5);
INSERT INTO grade VALUES(0,1,6,4,7,308,97,0.1,9.7);
INSERT INTO grade VALUES(0,1,6,4,8,327,78,0.1,7.8);
INSERT INTO grade VALUES(0,1,6,5,1,56,78,0.05,3.9);
INSERT INTO grade VALUES(0,1,6,5,2,84,78,0.05,3.9);
INSERT INTO grade VALUES(0,1,6,5,3,87,87,0.05,4.35);
INSERT INTO grade VALUES(0,1,6,5,4,184,73,0.25,18.25);
INSERT INTO grade VALUES(0,1,6,5,5,203,92,0.25,23);
INSERT INTO grade VALUES(0,1,6,5,6,253,94,0.15,14.1);
INSERT INTO grade VALUES(0,1,6,5,7,293,77,0.1,7.7);
INSERT INTO grade VALUES(0,4,6,6,1,95,86,0.05,4.3);
INSERT INTO grade VALUES(0,4,6,6,2,126,83,0.05,4.15);
INSERT INTO grade VALUES(0,4,6,6,3,128,72,0.05,3.6);
INSERT INTO grade VALUES(0,4,6,6,4,146,73,0.25,18.25);
INSERT INTO grade VALUES(0,4,6,6,5,176,97,0.25,24.25);
INSERT INTO grade VALUES(0,6,6,9,1,70,71,0.05,3.55);
INSERT INTO grade VALUES(0,6,6,9,2,117,72,0.05,3.6);
INSERT INTO grade VALUES(0,6,6,9,3,198,75,0.05,3.75);
INSERT INTO grade VALUES(0,4,6,7,6,264,91,0.15,13.65);
INSERT INTO grade VALUES(0,4,6,7,7,300,93,0.1,9.3);
INSERT INTO grade VALUES(0,4,6,7,8,338,79,0.1,7.9);
INSERT INTO grade VALUES(0,1,7,1,1,59,89,0.05,4.45);
INSERT INTO grade VALUES(0,1,7,1,2,64,100,0.05,5);
INSERT INTO grade VALUES(0,1,7,1,3,79,97,0.05,4.85);
INSERT INTO grade VALUES(0,1,7,1,4,87,84,0.25,21);
INSERT INTO grade VALUES(0,1,7,1,5,190,84,0.25,21);
INSERT INTO grade VALUES(0,1,7,1,6,246,73,0.15,10.95);
INSERT INTO grade VALUES(0,3,7,2,5,22,86,0.25,21.5);
INSERT INTO grade VALUES(0,3,7,2,6,57,87,0.15,13.05);
INSERT INTO grade VALUES(0,3,7,2,7,151,96,0.1,9.6);
INSERT INTO grade VALUES(0,3,7,2,8,151,83,0.1,8.3);
INSERT INTO grade VALUES(0,3,7,2,1,219,98,0.05,4.9);
INSERT INTO grade VALUES(0,3,7,2,2,275,76,0.05,3.8);
INSERT INTO grade VALUES(0,3,7,2,3,286,93,0.05,4.65);
INSERT INTO grade VALUES(0,3,7,2,4,342,81,0.25,20.25);
INSERT INTO grade VALUES(0,4,7,3,1,13,78,0.05,3.9);
INSERT INTO grade VALUES(0,4,7,3,2,78,86,0.05,4.3);
INSERT INTO grade VALUES(0,4,7,3,3,114,83,0.05,4.15);
INSERT INTO grade VALUES(0,4,7,3,4,136,78,0.25,19.5);
INSERT INTO grade VALUES(0,4,7,3,5,177,100,0.25,25);
INSERT INTO grade VALUES(0,4,7,3,6,211,80,0.15,12);
INSERT INTO grade VALUES(0,4,7,3,7,273,93,0.1,9.3);
INSERT INTO grade VALUES(0,4,7,3,8,331,92,0.1,9.2);
INSERT INTO grade VALUES(0,2,7,4,1,13,89,0.05,4.45);
INSERT INTO grade VALUES(0,2,7,4,2,54,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,7,4,3,80,88,0.05,4.4);
INSERT INTO grade VALUES(0,2,7,4,1,272,85,0.05,4.25);
INSERT INTO grade VALUES(0,2,7,4,4,272,100,0.25,25);
INSERT INTO grade VALUES(0,2,7,4,5,339,71,0.25,17.75);
INSERT INTO grade VALUES(0,3,7,5,3,97,97,0.05,4.85);
INSERT INTO grade VALUES(0,3,7,5,4,190,99,0.25,24.75);
INSERT INTO grade VALUES(0,3,7,5,5,319,74,0.25,18.5);
INSERT INTO grade VALUES(0,3,7,5,6,351,81,0.15,12.15);
INSERT INTO grade VALUES(0,3,7,5,1,354,72,0.05,3.6);
INSERT INTO grade VALUES(0,3,7,5,2,359,78,0.05,3.9);
INSERT INTO grade VALUES(0,4,7,6,1,37,84,0.05,4.2);
INSERT INTO grade VALUES(0,4,7,6,2,37,77,0.05,3.85);
INSERT INTO grade VALUES(0,4,7,6,3,86,100,0.05,5);
INSERT INTO grade VALUES(0,4,7,6,4,113,82,0.25,20.5);
INSERT INTO grade VALUES(0,4,7,6,5,119,78,0.25,19.5);
INSERT INTO grade VALUES(0,4,7,6,6,123,80,0.15,12);
INSERT INTO grade VALUES(0,4,7,6,7,172,71,0.1,7.1);
INSERT INTO grade VALUES(0,4,7,6,8,190,87,0.1,8.7);
INSERT INTO grade VALUES(0,4,7,9,1,119,89,0.05,4.45);
INSERT INTO grade VALUES(0,4,7,9,2,197,97,0.05,4.85);
INSERT INTO grade VALUES(0,4,7,9,3,205,83,0.05,4.15);
INSERT INTO grade VALUES(0,4,7,9,4,226,86,0.25,21.5);
INSERT INTO grade VALUES(0,4,7,9,5,270,85,0.25,21.25);
INSERT INTO grade VALUES(0,6,8,1,1,7,70,0.05,3.5);
INSERT INTO grade VALUES(0,6,8,1,2,167,89,0.05,4.45);
INSERT INTO grade VALUES(0,6,8,1,3,213,80,0.05,4);
INSERT INTO grade VALUES(0,6,8,1,4,220,79,0.25,19.75);
INSERT INTO grade VALUES(0,6,8,1,5,247,92,0.25,23);
INSERT INTO grade VALUES(0,6,8,1,6,287,99,0.15,14.85);
INSERT INTO grade VALUES(0,6,8,1,7,345,81,0.1,8.1);
INSERT INTO grade VALUES(0,6,8,2,3,16,73,0.05,3.65);
INSERT INTO grade VALUES(0,6,8,2,4,80,75,0.25,18.75);
INSERT INTO grade VALUES(0,6,8,2,5,214,88,0.25,22);
INSERT INTO grade VALUES(0,6,8,2,6,307,82,0.15,12.3);
INSERT INTO grade VALUES(0,6,8,2,1,342,94,0.05,4.7);
INSERT INTO grade VALUES(0,6,8,2,2,352,80,0.05,4);
INSERT INTO grade VALUES(0,1,8,3,1,93,98,0.05,4.9);
INSERT INTO grade VALUES(0,1,8,3,2,146,95,0.05,4.75);
INSERT INTO grade VALUES(0,1,8,3,3,173,94,0.05,4.7);
INSERT INTO grade VALUES(0,1,8,3,4,221,98,0.25,24.5);
INSERT INTO grade VALUES(0,1,8,3,5,224,94,0.25,23.5);
INSERT INTO grade VALUES(0,1,8,3,6,359,85,0.15,12.75);
INSERT INTO grade VALUES(0,6,8,4,2,70,73,0.05,3.65);
INSERT INTO grade VALUES(0,6,8,4,3,136,81,0.05,4.05);
INSERT INTO grade VALUES(0,6,8,4,4,165,84,0.25,21);
INSERT INTO grade VALUES(0,6,8,4,5,225,93,0.25,23.25);
INSERT INTO grade VALUES(0,6,8,4,6,256,95,0.15,14.25);
INSERT INTO grade VALUES(0,6,8,4,7,293,74,0.1,7.4);
INSERT INTO grade VALUES(0,6,8,4,8,311,90,0.1,9);
INSERT INTO grade VALUES(0,2,8,5,1,25,81,0.05,4.05);
INSERT INTO grade VALUES(0,2,8,5,2,54,77,0.05,3.85);
INSERT INTO grade VALUES(0,2,8,5,3,69,91,0.05,4.55);
INSERT INTO grade VALUES(0,2,8,5,4,144,91,0.25,22.75);
INSERT INTO grade VALUES(0,2,8,5,5,151,94,0.25,23.5);
INSERT INTO grade VALUES(0,2,8,5,6,183,100,0.15,15);
INSERT INTO grade VALUES(0,2,8,5,7,238,90,0.1,9);
INSERT INTO grade VALUES(0,1,8,6,1,28,93,0.05,4.65);
INSERT INTO grade VALUES(0,1,8,6,2,86,87,0.05,4.35);
INSERT INTO grade VALUES(0,1,8,6,3,143,77,0.05,3.85);
INSERT INTO grade VALUES(0,1,8,6,4,145,78,0.25,19.5);
INSERT INTO grade VALUES(0,1,8,6,5,158,80,0.25,20);
INSERT INTO grade VALUES(0,1,8,9,2,222,90,0.05,4.5);
INSERT INTO grade VALUES(0,1,8,9,3,277,99,0.05,4.95);
INSERT INTO grade VALUES(0,1,8,9,1,364,70,0.05,3.5);
INSERT INTO grade VALUES(0,1,8,7,6,220,80,0.15,12);
INSERT INTO grade VALUES(0,1,8,7,7,251,90,0.1,9);
INSERT INTO grade VALUES(0,1,8,7,8,278,83,0.1,8.3);
INSERT INTO grade VALUES(0,1,9,1,1,28,73,0.05,3.65);
INSERT INTO grade VALUES(0,1,9,1,2,87,99,0.05,4.95);
INSERT INTO grade VALUES(0,1,9,1,3,95,72,0.05,3.6);
INSERT INTO grade VALUES(0,1,9,1,4,136,84,0.25,21);
INSERT INTO grade VALUES(0,1,9,1,5,226,83,0.25,20.75);
INSERT INTO grade VALUES(0,1,9,1,6,320,81,0.15,12.15);
INSERT INTO grade VALUES(0,1,9,2,1,18,74,0.05,3.7);
INSERT INTO grade VALUES(0,1,9,2,2,99,91,0.05,4.55);
INSERT INTO grade VALUES(0,1,9,2,3,193,95,0.05,4.75);
INSERT INTO grade VALUES(0,4,9,3,1,81,96,0.05,4.8);
INSERT INTO grade VALUES(0,4,9,3,2,126,78,0.05,3.9);
INSERT INTO grade VALUES(0,4,9,3,3,230,83,0.05,4.15);
INSERT INTO grade VALUES(0,4,9,3,4,242,88,0.25,22);
INSERT INTO grade VALUES(0,3,9,4,1,37,83,0.05,4.15);
INSERT INTO grade VALUES(0,3,9,4,2,187,70,0.05,3.5);
INSERT INTO grade VALUES(0,3,9,4,3,278,92,0.05,4.6);
INSERT INTO grade VALUES(0,3,9,4,4,341,97,0.25,24.25);
INSERT INTO grade VALUES(0,3,9,4,5,363,95,0.25,23.75);
INSERT INTO grade VALUES(0,2,9,5,1,17,93,0.05,4.65);
INSERT INTO grade VALUES(0,2,9,5,2,85,84,0.05,4.2);
INSERT INTO grade VALUES(0,2,9,5,3,149,99,0.05,4.95);
INSERT INTO grade VALUES(0,2,9,5,4,150,83,0.25,20.75);
INSERT INTO grade VALUES(0,2,9,5,5,247,79,0.25,19.75);
INSERT INTO grade VALUES(0,2,9,5,6,320,78,0.15,11.7);
INSERT INTO grade VALUES(0,2,9,5,7,337,73,0.1,7.3);
INSERT INTO grade VALUES(0,6,9,6,1,97,95,0.05,4.75);
INSERT INTO grade VALUES(0,6,9,6,2,161,96,0.05,4.8);
INSERT INTO grade VALUES(0,2,9,9,1,18,93,0.05,4.65);
INSERT INTO grade VALUES(0,2,9,9,2,28,77,0.05,3.85);
INSERT INTO grade VALUES(0,2,9,9,3,234,78,0.05,3.9);
INSERT INTO grade VALUES(0,2,9,9,4,292,92,0.25,23);
INSERT INTO grade VALUES(0,2,9,9,5,295,92,0.25,23);
INSERT INTO grade VALUES(0,2,9,9,6,349,80,0.15,12);
INSERT INTO grade VALUES(0,6,9,6,3,206,73,0.05,3.65);
INSERT INTO grade VALUES(0,6,9,7,4,226,70,0.25,17.5);
INSERT INTO grade VALUES(0,6,9,7,5,304,75,0.25,18.75);
INSERT INTO grade VALUES(0,6,9,7,6,325,99,0.15,14.85);
INSERT INTO grade VALUES(0,6,9,7,7,353,92,0.1,9.2);
INSERT INTO grade VALUES(0,1,10,1,1,11,78,0.05,3.9);
INSERT INTO grade VALUES(0,1,10,1,2,83,86,0.05,4.3);
INSERT INTO grade VALUES(0,1,10,1,3,119,79,0.05,3.95);
INSERT INTO grade VALUES(0,1,10,1,4,134,84,0.25,21);
INSERT INTO grade VALUES(0,1,10,1,5,173,95,0.25,23.75);
INSERT INTO grade VALUES(0,1,10,1,6,184,95,0.15,14.25);
INSERT INTO grade VALUES(0,1,10,1,7,302,96,0.1,9.6);
INSERT INTO grade VALUES(0,3,10,2,2,44,93,0.05,4.65);
INSERT INTO grade VALUES(0,3,10,2,3,101,75,0.05,3.75);
INSERT INTO grade VALUES(0,3,10,2,4,116,77,0.25,19.25);
INSERT INTO grade VALUES(0,3,10,2,5,276,79,0.25,19.75);
INSERT INTO grade VALUES(0,3,10,2,1,317,75,0.05,3.75);
INSERT INTO grade VALUES(0,3,10,2,6,339,99,0.15,14.85);
INSERT INTO grade VALUES(0,3,10,2,7,361,80,0.1,8);
INSERT INTO grade VALUES(0,2,10,3,1,134,86,0.05,4.3);
INSERT INTO grade VALUES(0,2,10,3,2,201,100,0.05,5);
INSERT INTO grade VALUES(0,2,10,3,3,227,100,0.05,5);
INSERT INTO grade VALUES(0,4,10,4,1,31,88,0.05,4.4);
INSERT INTO grade VALUES(0,4,10,4,2,83,97,0.05,4.85);
INSERT INTO grade VALUES(0,4,10,4,3,104,72,0.05,3.6);
INSERT INTO grade VALUES(0,4,10,4,4,153,77,0.25,19.25);
INSERT INTO grade VALUES(0,4,10,4,5,189,91,0.25,22.75);
INSERT INTO grade VALUES(0,4,10,4,6,212,96,0.15,14.4);
INSERT INTO grade VALUES(0,4,10,4,7,222,75,0.1,7.5);
INSERT INTO grade VALUES(0,4,10,4,8,249,87,0.1,8.7);
INSERT INTO grade VALUES(0,6,10,5,1,12,82,0.05,4.1);
INSERT INTO grade VALUES(0,6,10,5,2,86,70,0.05,3.5);
INSERT INTO grade VALUES(0,6,10,5,3,268,71,0.05,3.55);
INSERT INTO grade VALUES(0,1,10,6,1,50,87,0.05,4.35);
INSERT INTO grade VALUES(0,1,10,6,2,135,73,0.05,3.65);
INSERT INTO grade VALUES(0,1,10,6,3,170,91,0.05,4.55);
INSERT INTO grade VALUES(0,1,10,6,4,178,81,0.25,20.25);
INSERT INTO grade VALUES(0,1,10,6,5,194,84,0.25,21);
INSERT INTO grade VALUES(0,6,10,9,3,32,87,0.05,4.35);
INSERT INTO grade VALUES(0,6,10,9,4,212,74,0.25,18.5);
INSERT INTO grade VALUES(0,6,10,9,1,255,100,0.05,5);
INSERT INTO grade VALUES(0,6,10,9,2,295,85,0.05,4.25);
INSERT INTO grade VALUES(0,6,10,9,5,323,85,0.25,21.25);
INSERT INTO grade VALUES(0,1,10,6,6,201,81,0.15,12.15);
INSERT INTO grade VALUES(0,1,10,7,7,222,88,0.1,8.8);
INSERT INTO grade VALUES(0,1,10,7,8,316,75,0.1,7.5);
INSERT INTO grade VALUES(0,1,11,1,1,49,99,0.05,4.95);
INSERT INTO grade VALUES(0,1,11,1,2,80,79,0.05,3.95);
INSERT INTO grade VALUES(0,1,11,1,3,84,94,0.05,4.7);
INSERT INTO grade VALUES(0,1,11,1,4,138,80,0.25,20);
INSERT INTO grade VALUES(0,1,11,1,5,188,95,0.25,23.75);
INSERT INTO grade VALUES(0,1,11,1,6,195,97,0.15,14.55);
INSERT INTO grade VALUES(0,1,11,1,7,327,100,0.1,10);
INSERT INTO grade VALUES(0,1,11,1,8,342,72,0.1,7.2);
INSERT INTO grade VALUES(0,4,11,2,1,43,74,0.05,3.7);
INSERT INTO grade VALUES(0,4,11,2,2,69,73,0.05,3.65);
INSERT INTO grade VALUES(0,4,11,2,3,91,92,0.05,4.6);
INSERT INTO grade VALUES(0,4,11,2,4,120,72,0.25,18);
INSERT INTO grade VALUES(0,4,11,2,5,179,72,0.25,18);
INSERT INTO grade VALUES(0,6,11,3,2,127,99,0.05,4.95);
INSERT INTO grade VALUES(0,6,11,3,3,215,97,0.05,4.85);
INSERT INTO grade VALUES(0,6,11,3,4,276,86,0.25,21.5);
INSERT INTO grade VALUES(0,6,11,3,1,354,75,0.05,3.75);
INSERT INTO grade VALUES(0,6,11,3,5,365,86,0.25,21.5);
INSERT INTO grade VALUES(0,1,11,4,1,19,99,0.05,4.95);
INSERT INTO grade VALUES(0,1,11,4,2,60,93,0.05,4.65);
INSERT INTO grade VALUES(0,1,11,4,3,83,84,0.05,4.2);
INSERT INTO grade VALUES(0,1,11,4,4,175,82,0.25,20.5);
INSERT INTO grade VALUES(0,1,11,4,5,190,99,0.25,24.75);
INSERT INTO grade VALUES(0,1,11,4,6,201,85,0.15,12.75);
INSERT INTO grade VALUES(0,1,11,4,7,214,86,0.1,8.6);
INSERT INTO grade VALUES(0,1,11,4,8,299,72,0.1,7.2);
INSERT INTO grade VALUES(0,1,11,5,1,6,81,0.05,4.05);
INSERT INTO grade VALUES(0,1,11,5,2,35,73,0.05,3.65);
INSERT INTO grade VALUES(0,1,11,5,3,95,97,0.05,4.85);
INSERT INTO grade VALUES(0,1,11,5,4,288,82,0.25,20.5);
INSERT INTO grade VALUES(0,2,11,6,1,42,74,0.05,3.7);
INSERT INTO grade VALUES(0,2,11,6,2,71,81,0.05,4.05);
INSERT INTO grade VALUES(0,2,11,6,3,84,83,0.05,4.15);
INSERT INTO grade VALUES(0,3,11,9,2,91,86,0.05,4.3);
INSERT INTO grade VALUES(0,3,11,9,3,127,84,0.05,4.2);
INSERT INTO grade VALUES(0,3,11,9,4,148,71,0.25,17.75);
INSERT INTO grade VALUES(0,3,11,9,5,263,84,0.25,21);
INSERT INTO grade VALUES(0,3,11,9,6,283,72,0.15,10.8);
INSERT INTO grade VALUES(0,3,11,9,7,291,100,0.1,10);
INSERT INTO grade VALUES(0,3,11,9,1,328,90,0.05,4.5);
INSERT INTO grade VALUES(0,3,11,9,8,353,98,0.1,9.8);
INSERT INTO grade VALUES(0,2,11,7,4,288,99,0.25,24.75);
INSERT INTO grade VALUES(0,2,11,7,5,292,73,0.25,18.25);
INSERT INTO grade VALUES(0,2,11,7,6,358,81,0.15,12.15);
INSERT INTO grade VALUES(0,6,12,1,1,73,86,0.05,4.3);
INSERT INTO grade VALUES(0,6,12,1,2,186,97,0.05,4.85);
INSERT INTO grade VALUES(0,6,12,1,3,205,75,0.05,3.75);
INSERT INTO grade VALUES(0,6,12,1,4,224,98,0.25,24.5);
INSERT INTO grade VALUES(0,6,12,1,5,327,92,0.25,23);
INSERT INTO grade VALUES(0,6,12,1,6,331,70,0.15,10.5);
INSERT INTO grade VALUES(0,6,12,1,7,344,79,0.1,7.9);
INSERT INTO grade VALUES(0,2,12,2,3,101,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,12,2,1,337,91,0.05,4.55);
INSERT INTO grade VALUES(0,2,12,2,2,357,72,0.05,3.6);
INSERT INTO grade VALUES(0,2,12,3,1,2,100,0.05,5);
INSERT INTO grade VALUES(0,2,12,3,2,39,99,0.05,4.95);
INSERT INTO grade VALUES(0,2,12,3,3,122,80,0.05,4);
INSERT INTO grade VALUES(0,2,12,3,4,136,75,0.25,18.75);
INSERT INTO grade VALUES(0,2,12,3,5,171,74,0.25,18.5);
INSERT INTO grade VALUES(0,2,12,3,6,208,74,0.15,11.1);
INSERT INTO grade VALUES(0,2,12,3,7,284,96,0.1,9.6);
INSERT INTO grade VALUES(0,2,12,3,8,344,76,0.1,7.6);
INSERT INTO grade VALUES(0,2,12,4,1,110,89,0.05,4.45);
INSERT INTO grade VALUES(0,2,12,4,2,151,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,12,4,3,237,100,0.05,5);
INSERT INTO grade VALUES(0,2,12,4,4,294,98,0.25,24.5);
INSERT INTO grade VALUES(0,2,12,4,5,336,92,0.25,23);
INSERT INTO grade VALUES(0,1,12,5,1,64,79,0.05,3.95);
INSERT INTO grade VALUES(0,1,12,5,2,85,99,0.05,4.95);
INSERT INTO grade VALUES(0,1,12,5,3,115,91,0.05,4.55);
INSERT INTO grade VALUES(0,1,12,5,4,253,90,0.25,22.5);
INSERT INTO grade VALUES(0,1,12,5,5,285,83,0.25,20.75);
INSERT INTO grade VALUES(0,1,12,5,6,342,79,0.15,11.85);
INSERT INTO grade VALUES(0,4,12,6,1,17,85,0.05,4.25);
INSERT INTO grade VALUES(0,4,12,6,2,25,71,0.05,3.55);
INSERT INTO grade VALUES(0,4,12,6,3,50,93,0.05,4.65);
INSERT INTO grade VALUES(0,4,12,6,4,151,82,0.25,20.5);
INSERT INTO grade VALUES(0,4,12,6,5,158,99,0.25,24.75);
INSERT INTO grade VALUES(0,4,12,6,6,182,88,0.15,13.2);
INSERT INTO grade VALUES(0,3,12,9,1,183,97,0.05,4.85);
INSERT INTO grade VALUES(0,3,12,9,2,319,77,0.05,3.85);
INSERT INTO grade VALUES(0,4,12,7,7,219,78,0.1,7.8);
INSERT INTO grade VALUES(0,4,12,7,8,334,90,0.1,9);
INSERT INTO grade VALUES(0,6,13,1,1,28,93,0.05,4.65);
INSERT INTO grade VALUES(0,6,13,1,2,130,74,0.05,3.7);
INSERT INTO grade VALUES(0,6,13,1,3,172,88,0.05,4.4);
INSERT INTO grade VALUES(0,6,13,1,4,218,86,0.25,21.5);
INSERT INTO grade VALUES(0,6,13,1,5,245,89,0.25,22.25);
INSERT INTO grade VALUES(0,6,13,1,6,323,77,0.15,11.55);
INSERT INTO grade VALUES(0,1,13,2,3,150,77,0.05,3.85);
INSERT INTO grade VALUES(0,1,13,2,4,221,77,0.25,19.25);
INSERT INTO grade VALUES(0,1,13,2,1,328,71,0.05,3.55);
INSERT INTO grade VALUES(0,1,13,2,2,354,81,0.05,4.05);
INSERT INTO grade VALUES(0,2,13,3,1,217,72,0.05,3.6);
INSERT INTO grade VALUES(0,2,13,3,2,317,81,0.05,4.05);
INSERT INTO grade VALUES(0,6,13,4,1,29,87,0.05,4.35);
INSERT INTO grade VALUES(0,6,13,4,2,32,83,0.05,4.15);
INSERT INTO grade VALUES(0,6,13,4,3,122,94,0.05,4.7);
INSERT INTO grade VALUES(0,6,13,4,4,324,96,0.25,24);
INSERT INTO grade VALUES(0,6,13,4,5,355,72,0.25,18);
INSERT INTO grade VALUES(0,1,13,5,1,56,72,0.05,3.6);
INSERT INTO grade VALUES(0,1,13,5,2,74,77,0.05,3.85);
INSERT INTO grade VALUES(0,1,13,5,3,323,77,0.05,3.85);
INSERT INTO grade VALUES(0,1,13,5,4,329,84,0.25,21);
INSERT INTO grade VALUES(0,2,13,6,1,5,70,0.05,3.5);
INSERT INTO grade VALUES(0,2,13,6,2,43,84,0.05,4.2);
INSERT INTO grade VALUES(0,2,13,6,3,75,85,0.05,4.25);
INSERT INTO grade VALUES(0,2,13,6,4,144,90,0.25,22.5);
INSERT INTO grade VALUES(0,2,13,9,1,120,92,0.05,4.6);
INSERT INTO grade VALUES(0,2,13,9,2,169,85,0.05,4.25);
INSERT INTO grade VALUES(0,2,13,9,3,169,82,0.05,4.1);
INSERT INTO grade VALUES(0,2,13,9,4,337,80,0.25,20);
INSERT INTO grade VALUES(0,2,13,7,5,226,75,0.25,18.75);
INSERT INTO grade VALUES(0,2,13,7,6,245,80,0.15,12);
INSERT INTO grade VALUES(0,2,13,7,7,288,71,0.1,7.1);
INSERT INTO grade VALUES(0,2,13,7,8,290,94,0.1,9.4);
INSERT INTO grade VALUES(0,6,14,1,1,11,91,0.05,4.55);
INSERT INTO grade VALUES(0,6,14,1,2,35,71,0.05,3.55);
INSERT INTO grade VALUES(0,6,14,1,3,100,87,0.05,4.35);
INSERT INTO grade VALUES(0,6,14,1,4,126,84,0.25,21);
INSERT INTO grade VALUES(0,6,14,1,5,251,100,0.25,25);
INSERT INTO grade VALUES(0,6,14,1,6,254,98,0.15,14.7);
INSERT INTO grade VALUES(0,6,14,1,7,282,78,0.1,7.8);
INSERT INTO grade VALUES(0,6,14,1,8,288,89,0.1,8.9);
INSERT INTO grade VALUES(0,2,14,2,3,106,95,0.05,4.75);
INSERT INTO grade VALUES(0,2,14,2,4,279,91,0.25,22.75);
INSERT INTO grade VALUES(0,2,14,2,5,284,90,0.25,22.5);
INSERT INTO grade VALUES(0,2,14,2,1,311,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,14,2,2,312,72,0.05,3.6);
INSERT INTO grade VALUES(0,2,14,3,2,68,85,0.05,4.25);
INSERT INTO grade VALUES(0,2,14,3,3,82,71,0.05,3.55);
INSERT INTO grade VALUES(0,2,14,3,4,138,87,0.25,21.75);
INSERT INTO grade VALUES(0,2,14,3,5,202,91,0.25,22.75);
INSERT INTO grade VALUES(0,2,14,3,1,291,71,0.05,3.55);
INSERT INTO grade VALUES(0,2,14,3,6,299,70,0.15,10.5);
INSERT INTO grade VALUES(0,2,14,3,7,310,74,0.1,7.4);
INSERT INTO grade VALUES(0,3,14,4,1,50,85,0.05,4.25);
INSERT INTO grade VALUES(0,3,14,4,2,98,80,0.05,4);
INSERT INTO grade VALUES(0,3,14,4,3,129,96,0.05,4.8);
INSERT INTO grade VALUES(0,3,14,4,4,157,81,0.25,20.25);
INSERT INTO grade VALUES(0,3,14,4,5,198,100,0.25,25);
INSERT INTO grade VALUES(0,3,14,4,6,201,85,0.15,12.75);
INSERT INTO grade VALUES(0,3,14,4,7,246,94,0.1,9.4);
INSERT INTO grade VALUES(0,3,14,4,8,257,99,0.1,9.9);
INSERT INTO grade VALUES(0,4,14,5,1,294,81,0.05,4.05);
INSERT INTO grade VALUES(0,4,14,5,2,315,80,0.05,4);
INSERT INTO grade VALUES(0,3,14,6,1,2,97,0.05,4.85);
INSERT INTO grade VALUES(0,3,14,6,2,190,79,0.05,3.95);
INSERT INTO grade VALUES(0,3,14,6,3,200,86,0.05,4.3);
INSERT INTO grade VALUES(0,4,14,9,1,23,71,0.05,3.55);
INSERT INTO grade VALUES(0,4,14,9,2,73,82,0.05,4.1);
INSERT INTO grade VALUES(0,4,14,9,3,80,87,0.05,4.35);
INSERT INTO grade VALUES(0,4,14,9,4,96,72,0.25,18);
INSERT INTO grade VALUES(0,4,14,9,5,120,80,0.25,20);
INSERT INTO grade VALUES(0,4,14,9,6,289,98,0.15,14.7);
INSERT INTO grade VALUES(0,4,14,9,7,303,95,0.1,9.5);
INSERT INTO grade VALUES(0,3,14,7,4,220,74,0.25,18.5);
INSERT INTO grade VALUES(0,3,14,7,5,223,74,0.25,18.5);
INSERT INTO grade VALUES(0,3,14,7,6,234,88,0.15,13.2);
INSERT INTO grade VALUES(0,3,14,7,7,292,82,0.1,8.2);
INSERT INTO grade VALUES(0,3,14,7,8,294,76,0.1,7.6);
INSERT INTO grade VALUES(0,3,15,1,1,71,93,0.05,4.65);
INSERT INTO grade VALUES(0,3,15,1,2,72,93,0.05,4.65);
INSERT INTO grade VALUES(0,3,15,1,3,90,73,0.05,3.65);
INSERT INTO grade VALUES(0,3,15,1,4,119,92,0.25,23);
INSERT INTO grade VALUES(0,3,15,1,5,357,96,0.25,24);
INSERT INTO grade VALUES(0,1,15,2,1,140,78,0.05,3.9);
INSERT INTO grade VALUES(0,1,15,2,2,305,93,0.05,4.65);
INSERT INTO grade VALUES(0,1,15,2,3,335,84,0.05,4.2);
INSERT INTO grade VALUES(0,1,15,2,4,354,85,0.25,21.25);
INSERT INTO grade VALUES(0,4,15,3,1,12,82,0.05,4.1);
INSERT INTO grade VALUES(0,4,15,3,2,39,81,0.05,4.05);
INSERT INTO grade VALUES(0,4,15,3,3,90,88,0.05,4.4);
INSERT INTO grade VALUES(0,4,15,3,4,93,100,0.25,25);
INSERT INTO grade VALUES(0,4,15,3,5,97,91,0.25,22.75);
INSERT INTO grade VALUES(0,4,15,3,6,111,82,0.15,12.3);
INSERT INTO grade VALUES(0,4,15,3,7,137,91,0.1,9.1);
INSERT INTO grade VALUES(0,4,15,3,8,149,90,0.1,9);
INSERT INTO grade VALUES(0,1,15,4,1,40,79,0.05,3.95);
INSERT INTO grade VALUES(0,1,15,4,2,47,99,0.05,4.95);
INSERT INTO grade VALUES(0,1,15,4,3,109,70,0.05,3.5);
INSERT INTO grade VALUES(0,1,15,4,4,114,85,0.25,21.25);
INSERT INTO grade VALUES(0,1,15,4,5,213,91,0.25,22.75);
INSERT INTO grade VALUES(0,1,15,4,6,308,81,0.15,12.15);
INSERT INTO grade VALUES(0,1,15,4,7,320,80,0.1,8);
INSERT INTO grade VALUES(0,1,15,4,8,340,77,0.1,7.7);
INSERT INTO grade VALUES(0,3,15,5,2,155,70,0.05,3.5);
INSERT INTO grade VALUES(0,3,15,5,3,164,82,0.05,4.1);
INSERT INTO grade VALUES(0,3,15,5,4,187,83,0.25,20.75);
INSERT INTO grade VALUES(0,3,15,5,5,260,96,0.25,24);
INSERT INTO grade VALUES(0,3,15,5,6,280,93,0.15,13.95);
INSERT INTO grade VALUES(0,3,15,5,1,361,78,0.05,3.9);
INSERT INTO grade VALUES(0,6,15,6,1,33,77,0.05,3.85);
INSERT INTO grade VALUES(0,6,15,6,2,38,76,0.05,3.8);
INSERT INTO grade VALUES(0,6,15,6,3,130,96,0.05,4.8);
INSERT INTO grade VALUES(0,2,15,9,1,64,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,15,9,2,111,88,0.05,4.4);
INSERT INTO grade VALUES(0,2,15,9,3,193,79,0.05,3.95);
INSERT INTO grade VALUES(0,2,15,9,4,236,87,0.25,21.75);
INSERT INTO grade VALUES(0,6,15,7,4,285,76,0.25,19);
INSERT INTO grade VALUES(0,6,15,7,5,349,81,0.25,20.25);
INSERT INTO grade VALUES(0,2,16,1,1,15,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,16,1,2,27,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,16,1,3,38,93,0.05,4.65);
INSERT INTO grade VALUES(0,2,16,1,4,161,88,0.25,22);
INSERT INTO grade VALUES(0,2,16,1,5,206,98,0.25,24.5);
INSERT INTO grade VALUES(0,2,16,1,6,214,75,0.15,11.25);
INSERT INTO grade VALUES(0,2,16,1,7,220,86,0.1,8.6);
INSERT INTO grade VALUES(0,2,16,1,8,225,93,0.1,9.3);
INSERT INTO grade VALUES(0,4,16,2,1,41,75,0.05,3.75);
INSERT INTO grade VALUES(0,4,16,2,2,94,95,0.05,4.75);
INSERT INTO grade VALUES(0,4,16,2,3,118,70,0.05,3.5);
INSERT INTO grade VALUES(0,4,16,2,4,135,86,0.25,21.5);
INSERT INTO grade VALUES(0,4,16,2,5,198,93,0.25,23.25);
INSERT INTO grade VALUES(0,4,16,2,6,272,86,0.15,12.9);
INSERT INTO grade VALUES(0,3,16,3,6,22,85,0.15,12.75);
INSERT INTO grade VALUES(0,3,16,3,7,31,70,0.1,7);
INSERT INTO grade VALUES(0,3,16,3,8,42,91,0.1,9.1);
INSERT INTO grade VALUES(0,3,16,3,1,246,98,0.05,4.9);
INSERT INTO grade VALUES(0,3,16,3,2,252,80,0.05,4);
INSERT INTO grade VALUES(0,3,16,3,3,295,78,0.05,3.9);
INSERT INTO grade VALUES(0,3,16,3,4,309,76,0.25,19);
INSERT INTO grade VALUES(0,3,16,3,5,319,89,0.25,22.25);
INSERT INTO grade VALUES(0,2,16,4,1,6,81,0.05,4.05);
INSERT INTO grade VALUES(0,2,16,4,2,17,91,0.05,4.55);
INSERT INTO grade VALUES(0,2,16,4,3,29,97,0.05,4.85);
INSERT INTO grade VALUES(0,2,16,4,4,46,73,0.25,18.25);
INSERT INTO grade VALUES(0,2,16,4,5,65,76,0.25,19);
INSERT INTO grade VALUES(0,2,16,4,6,130,81,0.15,12.15);
INSERT INTO grade VALUES(0,2,16,4,7,205,76,0.1,7.6);
INSERT INTO grade VALUES(0,2,16,4,8,225,98,0.1,9.8);
INSERT INTO grade VALUES(0,4,16,5,2,9,90,0.05,4.5);
INSERT INTO grade VALUES(0,4,16,5,3,141,84,0.05,4.2);
INSERT INTO grade VALUES(0,4,16,5,4,279,93,0.25,23.25);
INSERT INTO grade VALUES(0,4,16,5,1,288,76,0.05,3.8);
INSERT INTO grade VALUES(0,4,16,5,5,304,97,0.25,24.25);
INSERT INTO grade VALUES(0,6,16,6,1,26,73,0.05,3.65);
INSERT INTO grade VALUES(0,6,16,6,2,32,74,0.05,3.7);
INSERT INTO grade VALUES(0,6,16,6,3,132,93,0.05,4.65);
INSERT INTO grade VALUES(0,6,16,6,4,146,92,0.25,23);
INSERT INTO grade VALUES(0,1,16,9,1,14,84,0.05,4.2);
INSERT INTO grade VALUES(0,1,16,9,2,154,74,0.05,3.7);
INSERT INTO grade VALUES(0,1,16,9,3,259,71,0.05,3.55);
INSERT INTO grade VALUES(0,6,16,7,5,244,90,0.25,22.5);
INSERT INTO grade VALUES(0,6,16,7,6,282,83,0.15,12.45);
INSERT INTO grade VALUES(0,6,16,7,7,293,85,0.1,8.5);
INSERT INTO grade VALUES(0,6,16,7,8,326,70,0.1,7);
INSERT INTO grade VALUES(0,2,17,1,1,8,91,0.05,4.55);
INSERT INTO grade VALUES(0,2,17,1,2,12,75,0.05,3.75);
INSERT INTO grade VALUES(0,2,17,1,3,52,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,17,1,4,235,99,0.25,24.75);
INSERT INTO grade VALUES(0,2,17,1,5,236,91,0.25,22.75);
INSERT INTO grade VALUES(0,2,17,1,6,245,81,0.15,12.15);
INSERT INTO grade VALUES(0,2,17,1,7,288,92,0.1,9.2);
INSERT INTO grade VALUES(0,2,17,1,8,305,73,0.1,7.3);
INSERT INTO grade VALUES(0,3,17,2,1,151,81,0.05,4.05);
INSERT INTO grade VALUES(0,3,17,2,2,165,79,0.05,3.95);
INSERT INTO grade VALUES(0,3,17,2,3,293,92,0.05,4.6);
INSERT INTO grade VALUES(0,3,17,2,4,300,89,0.25,22.25);
INSERT INTO grade VALUES(0,4,17,3,1,43,73,0.05,3.65);
INSERT INTO grade VALUES(0,4,17,3,2,88,90,0.05,4.5);
INSERT INTO grade VALUES(0,4,17,3,3,141,96,0.05,4.8);
INSERT INTO grade VALUES(0,4,17,3,4,269,89,0.25,22.25);
INSERT INTO grade VALUES(0,4,17,3,5,274,84,0.25,21);
INSERT INTO grade VALUES(0,4,17,3,6,356,87,0.15,13.05);
INSERT INTO grade VALUES(0,3,17,4,1,61,89,0.05,4.45);
INSERT INTO grade VALUES(0,3,17,4,2,139,98,0.05,4.9);
INSERT INTO grade VALUES(0,3,17,4,3,200,90,0.05,4.5);
INSERT INTO grade VALUES(0,3,17,4,4,354,80,0.25,20);
INSERT INTO grade VALUES(0,1,17,5,1,46,78,0.05,3.9);
INSERT INTO grade VALUES(0,1,17,5,2,272,86,0.05,4.3);
INSERT INTO grade VALUES(0,1,17,5,3,296,78,0.05,3.9);
INSERT INTO grade VALUES(0,2,17,6,1,21,80,0.05,4);
INSERT INTO grade VALUES(0,2,17,6,2,62,71,0.05,3.55);
INSERT INTO grade VALUES(0,2,17,6,3,104,74,0.05,3.7);
INSERT INTO grade VALUES(0,2,17,6,4,119,76,0.25,19);
INSERT INTO grade VALUES(0,2,17,6,5,199,96,0.25,24);
INSERT INTO grade VALUES(0,1,17,9,1,81,97,0.05,4.85);
INSERT INTO grade VALUES(0,1,17,9,2,112,96,0.05,4.8);
INSERT INTO grade VALUES(0,1,17,9,3,130,96,0.05,4.8);
INSERT INTO grade VALUES(0,1,17,9,4,226,91,0.25,22.75);
INSERT INTO grade VALUES(0,1,17,9,5,236,77,0.25,19.25);
INSERT INTO grade VALUES(0,2,17,7,6,309,84,0.15,12.6);
INSERT INTO grade VALUES(0,4,18,1,1,30,94,0.05,4.7);
INSERT INTO grade VALUES(0,4,18,1,2,32,80,0.05,4);
INSERT INTO grade VALUES(0,4,18,1,3,97,84,0.05,4.2);
INSERT INTO grade VALUES(0,4,18,1,4,143,78,0.25,19.5);
INSERT INTO grade VALUES(0,4,18,1,5,216,75,0.25,18.75);
INSERT INTO grade VALUES(0,4,18,1,6,310,73,0.15,10.95);
INSERT INTO grade VALUES(0,6,18,2,1,48,80,0.05,4);
INSERT INTO grade VALUES(0,6,18,2,2,58,76,0.05,3.8);
INSERT INTO grade VALUES(0,6,18,2,3,126,91,0.05,4.55);
INSERT INTO grade VALUES(0,6,18,2,4,170,100,0.25,25);
INSERT INTO grade VALUES(0,6,18,2,5,261,85,0.25,21.25);
INSERT INTO grade VALUES(0,6,18,2,6,277,91,0.15,13.65);
INSERT INTO grade VALUES(0,6,18,2,7,278,93,0.1,9.3);
INSERT INTO grade VALUES(0,1,18,3,1,77,84,0.05,4.2);
INSERT INTO grade VALUES(0,1,18,3,2,104,92,0.05,4.6);
INSERT INTO grade VALUES(0,1,18,3,3,248,78,0.05,3.9);
INSERT INTO grade VALUES(0,6,18,4,1,57,82,0.05,4.1);
INSERT INTO grade VALUES(0,6,18,4,2,62,90,0.05,4.5);
INSERT INTO grade VALUES(0,6,18,4,3,96,78,0.05,3.9);
INSERT INTO grade VALUES(0,6,18,4,4,108,80,0.25,20);
INSERT INTO grade VALUES(0,6,18,4,5,314,84,0.25,21);
INSERT INTO grade VALUES(0,2,18,5,1,37,77,0.05,3.85);
INSERT INTO grade VALUES(0,2,18,5,2,92,83,0.05,4.15);
INSERT INTO grade VALUES(0,2,18,5,3,264,98,0.05,4.9);
INSERT INTO grade VALUES(0,2,18,5,4,315,83,0.25,20.75);
INSERT INTO grade VALUES(0,2,18,5,5,324,75,0.25,18.75);
INSERT INTO grade VALUES(0,2,18,5,6,343,82,0.15,12.3);
INSERT INTO grade VALUES(0,2,18,5,7,348,78,0.1,7.8);
INSERT INTO grade VALUES(0,4,18,6,1,45,89,0.05,4.45);
INSERT INTO grade VALUES(0,4,18,6,2,103,84,0.05,4.2);
INSERT INTO grade VALUES(0,4,18,6,3,133,71,0.05,3.55);
INSERT INTO grade VALUES(0,4,18,6,4,181,73,0.25,18.25);
INSERT INTO grade VALUES(0,2,18,9,1,63,74,0.05,3.7);
INSERT INTO grade VALUES(0,2,18,9,2,75,84,0.05,4.2);
INSERT INTO grade VALUES(0,2,18,9,3,146,74,0.05,3.7);
INSERT INTO grade VALUES(0,2,18,9,4,179,78,0.25,19.5);
INSERT INTO grade VALUES(0,2,18,9,5,196,78,0.25,19.5);
INSERT INTO grade VALUES(0,2,18,9,6,198,87,0.15,13.05);
INSERT INTO grade VALUES(0,2,18,9,7,252,99,0.1,9.9);
INSERT INTO grade VALUES(0,2,18,9,8,274,80,0.1,8);
INSERT INTO grade VALUES(0,4,18,7,5,214,94,0.25,23.5);
INSERT INTO grade VALUES(0,4,18,7,6,223,85,0.15,12.75);
INSERT INTO grade VALUES(0,4,18,7,7,250,72,0.1,7.2);
INSERT INTO grade VALUES(0,4,18,7,8,289,77,0.1,7.7);
INSERT INTO grade VALUES(0,1,19,1,1,27,88,0.05,4.4);
INSERT INTO grade VALUES(0,1,19,1,2,184,78,0.05,3.9);
INSERT INTO grade VALUES(0,1,19,1,3,241,100,0.05,5);
INSERT INTO grade VALUES(0,1,19,1,4,252,72,0.25,18);
INSERT INTO grade VALUES(0,1,19,2,5,73,77,0.25,19.25);
INSERT INTO grade VALUES(0,1,19,2,1,280,98,0.05,4.9);
INSERT INTO grade VALUES(0,1,19,2,6,293,80,0.15,12);
INSERT INTO grade VALUES(0,1,19,2,7,319,80,0.1,8);
INSERT INTO grade VALUES(0,1,19,2,8,323,84,0.1,8.4);
INSERT INTO grade VALUES(0,1,19,2,2,336,71,0.05,3.55);
INSERT INTO grade VALUES(0,1,19,2,3,340,70,0.05,3.5);
INSERT INTO grade VALUES(0,1,19,2,4,346,71,0.25,17.75);
INSERT INTO grade VALUES(0,3,19,3,1,30,87,0.05,4.35);
INSERT INTO grade VALUES(0,3,19,3,2,62,88,0.05,4.4);
INSERT INTO grade VALUES(0,3,19,3,3,190,80,0.05,4);
INSERT INTO grade VALUES(0,3,19,3,4,244,99,0.25,24.75);
INSERT INTO grade VALUES(0,3,19,3,5,267,100,0.25,25);
INSERT INTO grade VALUES(0,3,19,3,6,271,82,0.15,12.3);
INSERT INTO grade VALUES(0,3,19,3,7,274,71,0.1,7.1);
INSERT INTO grade VALUES(0,4,19,4,1,59,82,0.05,4.1);
INSERT INTO grade VALUES(0,4,19,4,2,103,78,0.05,3.9);
INSERT INTO grade VALUES(0,4,19,4,3,127,81,0.05,4.05);
INSERT INTO grade VALUES(0,4,19,4,4,129,76,0.25,19);
INSERT INTO grade VALUES(0,4,19,4,5,155,73,0.25,18.25);
INSERT INTO grade VALUES(0,4,19,4,6,234,95,0.15,14.25);
INSERT INTO grade VALUES(0,4,19,4,7,287,99,0.1,9.9);
INSERT INTO grade VALUES(0,1,19,5,1,47,97,0.05,4.85);
INSERT INTO grade VALUES(0,1,19,5,2,163,100,0.05,5);
INSERT INTO grade VALUES(0,1,19,5,3,296,93,0.05,4.65);
INSERT INTO grade VALUES(0,1,19,5,4,309,94,0.25,23.5);
INSERT INTO grade VALUES(0,6,19,6,1,10,84,0.05,4.2);
INSERT INTO grade VALUES(0,6,19,6,2,25,84,0.05,4.2);
INSERT INTO grade VALUES(0,6,19,6,3,79,72,0.05,3.6);
INSERT INTO grade VALUES(0,6,19,6,4,141,77,0.25,19.25);
INSERT INTO grade VALUES(0,6,19,6,5,162,98,0.25,24.5);
INSERT INTO grade VALUES(0,6,19,6,6,178,82,0.15,12.3);
INSERT INTO grade VALUES(0,6,19,6,7,187,79,0.1,7.9);
INSERT INTO grade VALUES(0,3,19,9,1,161,94,0.05,4.7);
INSERT INTO grade VALUES(0,3,19,9,2,339,83,0.05,4.15);
INSERT INTO grade VALUES(0,6,19,7,8,271,92,0.1,9.2);
INSERT INTO grade VALUES(0,3,20,1,1,60,95,0.05,4.75);
INSERT INTO grade VALUES(0,3,20,1,2,131,75,0.05,3.75);
INSERT INTO grade VALUES(0,3,20,1,3,305,80,0.05,4);
INSERT INTO grade VALUES(0,3,20,1,4,309,72,0.25,18);
INSERT INTO grade VALUES(0,3,20,1,5,312,87,0.25,21.75);
INSERT INTO grade VALUES(0,3,20,2,1,228,72,0.05,3.6);
INSERT INTO grade VALUES(0,3,20,2,2,330,83,0.05,4.15);
INSERT INTO grade VALUES(0,4,20,3,1,23,97,0.05,4.85);
INSERT INTO grade VALUES(0,4,20,3,2,148,78,0.05,3.9);
INSERT INTO grade VALUES(0,4,20,3,3,162,78,0.05,3.9);
INSERT INTO grade VALUES(0,4,20,3,4,296,92,0.25,23);
INSERT INTO grade VALUES(0,6,20,4,1,58,77,0.05,3.85);
INSERT INTO grade VALUES(0,6,20,4,2,98,74,0.05,3.7);
INSERT INTO grade VALUES(0,6,20,4,3,147,79,0.05,3.95);
INSERT INTO grade VALUES(0,6,20,4,4,153,79,0.25,19.75);
INSERT INTO grade VALUES(0,6,20,4,5,171,93,0.25,23.25);
INSERT INTO grade VALUES(0,6,20,4,6,275,74,0.15,11.1);
INSERT INTO grade VALUES(0,6,20,4,7,289,74,0.1,7.4);
INSERT INTO grade VALUES(0,6,20,4,8,292,95,0.1,9.5);
INSERT INTO grade VALUES(0,1,20,5,1,85,86,0.05,4.3);
INSERT INTO grade VALUES(0,1,20,5,2,142,83,0.05,4.15);
INSERT INTO grade VALUES(0,1,20,5,3,147,70,0.05,3.5);
INSERT INTO grade VALUES(0,1,20,5,4,150,79,0.25,19.75);
INSERT INTO grade VALUES(0,1,20,5,5,276,98,0.25,24.5);
INSERT INTO grade VALUES(0,1,20,5,6,291,90,0.15,13.5);
INSERT INTO grade VALUES(0,1,20,5,7,359,93,0.1,9.3);
INSERT INTO grade VALUES(0,2,20,6,1,47,81,0.05,4.05);
INSERT INTO grade VALUES(0,2,20,6,2,187,100,0.05,5);
INSERT INTO grade VALUES(0,4,20,9,3,174,81,0.05,4.05);
INSERT INTO grade VALUES(0,4,20,9,4,182,99,0.25,24.75);
INSERT INTO grade VALUES(0,4,20,9,5,204,84,0.25,21);
INSERT INTO grade VALUES(0,4,20,9,1,300,87,0.05,4.35);
INSERT INTO grade VALUES(0,4,20,9,2,353,76,0.05,3.8);
INSERT INTO grade VALUES(0,2,20,7,3,344,97,0.05,4.85);
INSERT INTO grade VALUES(0,4,21,1,1,109,78,0.05,3.9);
INSERT INTO grade VALUES(0,4,21,1,2,113,93,0.05,4.65);
INSERT INTO grade VALUES(0,4,21,1,6,156,76,0.15,11.4);
INSERT INTO grade VALUES(0,4,21,1,7,181,76,0.1,7.6);
INSERT INTO grade VALUES(0,4,21,1,8,228,77,0.1,7.7);
INSERT INTO grade VALUES(0,4,21,1,3,247,87,0.05,4.35);
INSERT INTO grade VALUES(0,4,21,1,4,317,72,0.25,18);
INSERT INTO grade VALUES(0,4,21,1,5,352,100,0.25,25);
INSERT INTO grade VALUES(0,3,21,2,4,83,70,0.25,17.5);
INSERT INTO grade VALUES(0,3,21,2,5,154,97,0.25,24.25);
INSERT INTO grade VALUES(0,3,21,2,1,340,81,0.05,4.05);
INSERT INTO grade VALUES(0,3,21,2,2,361,79,0.05,3.95);
INSERT INTO grade VALUES(0,3,21,2,3,365,97,0.05,4.85);
INSERT INTO grade VALUES(0,6,21,3,3,66,90,0.05,4.5);
INSERT INTO grade VALUES(0,6,21,3,4,109,87,0.25,21.75);
INSERT INTO grade VALUES(0,6,21,3,5,122,74,0.25,18.5);
INSERT INTO grade VALUES(0,6,21,3,1,244,76,0.05,3.8);
INSERT INTO grade VALUES(0,6,21,3,6,293,100,0.15,15);
INSERT INTO grade VALUES(0,6,21,3,2,298,88,0.05,4.4);
INSERT INTO grade VALUES(0,6,21,3,7,340,99,0.1,9.9);
INSERT INTO grade VALUES(0,6,21,3,8,353,76,0.1,7.6);
INSERT INTO grade VALUES(0,1,21,4,1,6,80,0.05,4);
INSERT INTO grade VALUES(0,1,21,4,2,15,88,0.05,4.4);
INSERT INTO grade VALUES(0,1,21,4,3,45,94,0.05,4.7);
INSERT INTO grade VALUES(0,1,21,4,4,48,72,0.25,18);
INSERT INTO grade VALUES(0,1,21,4,5,78,76,0.25,19);
INSERT INTO grade VALUES(0,1,21,4,6,98,93,0.15,13.95);
INSERT INTO grade VALUES(0,1,21,4,7,167,87,0.1,8.7);
INSERT INTO grade VALUES(0,1,21,4,8,192,91,0.1,9.1);
INSERT INTO grade VALUES(0,2,21,5,1,2,75,0.05,3.75);
INSERT INTO grade VALUES(0,2,21,5,2,5,71,0.05,3.55);
INSERT INTO grade VALUES(0,2,21,5,3,86,80,0.05,4);
INSERT INTO grade VALUES(0,2,21,5,4,221,79,0.25,19.75);
INSERT INTO grade VALUES(0,1,21,6,1,41,75,0.05,3.75);
INSERT INTO grade VALUES(0,1,21,6,2,46,99,0.05,4.95);
INSERT INTO grade VALUES(0,1,21,6,3,110,73,0.05,3.65);
INSERT INTO grade VALUES(0,1,21,6,4,140,87,0.25,21.75);
INSERT INTO grade VALUES(0,1,21,6,5,188,94,0.25,23.5);
INSERT INTO grade VALUES(0,3,21,9,6,40,95,0.15,14.25);
INSERT INTO grade VALUES(0,3,21,9,7,85,74,0.1,7.4);
INSERT INTO grade VALUES(0,3,21,9,8,92,95,0.1,9.5);
INSERT INTO grade VALUES(0,3,21,9,1,216,97,0.05,4.85);
INSERT INTO grade VALUES(0,3,21,9,2,263,73,0.05,3.65);
INSERT INTO grade VALUES(0,3,21,9,3,303,96,0.05,4.8);
INSERT INTO grade VALUES(0,3,21,9,4,316,87,0.25,21.75);
INSERT INTO grade VALUES(0,3,21,9,5,317,100,0.25,25);
INSERT INTO grade VALUES(0,1,21,7,6,216,71,0.15,10.65);
INSERT INTO grade VALUES(0,1,21,7,7,230,80,0.1,8);
INSERT INTO grade VALUES(0,1,21,7,8,322,98,0.1,9.8);
INSERT INTO grade VALUES(0,6,22,1,1,127,77,0.05,3.85);
INSERT INTO grade VALUES(0,6,22,1,2,270,98,0.05,4.9);
INSERT INTO grade VALUES(0,3,22,2,4,15,85,0.25,21.25);
INSERT INTO grade VALUES(0,3,22,2,5,101,79,0.25,19.75);
INSERT INTO grade VALUES(0,3,22,2,6,143,79,0.15,11.85);
INSERT INTO grade VALUES(0,3,22,2,7,229,83,0.1,8.3);
INSERT INTO grade VALUES(0,3,22,2,8,301,100,0.1,10);
INSERT INTO grade VALUES(0,3,22,2,1,319,77,0.05,3.85);
INSERT INTO grade VALUES(0,3,22,2,2,347,75,0.05,3.75);
INSERT INTO grade VALUES(0,3,22,2,3,359,83,0.05,4.15);
INSERT INTO grade VALUES(0,4,22,3,1,41,76,0.05,3.8);
INSERT INTO grade VALUES(0,4,22,3,2,52,83,0.05,4.15);
INSERT INTO grade VALUES(0,4,22,3,3,192,85,0.05,4.25);
INSERT INTO grade VALUES(0,4,22,4,1,9,88,0.05,4.4);
INSERT INTO grade VALUES(0,4,22,4,2,25,81,0.05,4.05);
INSERT INTO grade VALUES(0,4,22,4,3,71,73,0.05,3.65);
INSERT INTO grade VALUES(0,4,22,4,4,129,71,0.25,17.75);
INSERT INTO grade VALUES(0,4,22,4,5,195,88,0.25,22);
INSERT INTO grade VALUES(0,4,22,4,6,326,83,0.15,12.45);
INSERT INTO grade VALUES(0,3,22,5,1,118,92,0.05,4.6);
INSERT INTO grade VALUES(0,3,22,5,2,240,76,0.05,3.8);
INSERT INTO grade VALUES(0,3,22,5,3,251,82,0.05,4.1);
INSERT INTO grade VALUES(0,2,22,6,1,41,87,0.05,4.35);
INSERT INTO grade VALUES(0,2,22,6,2,60,71,0.05,3.55);
INSERT INTO grade VALUES(0,2,22,6,3,81,76,0.05,3.8);
INSERT INTO grade VALUES(0,2,22,6,4,88,100,0.25,25);
INSERT INTO grade VALUES(0,2,22,6,5,160,89,0.25,22.25);
INSERT INTO grade VALUES(0,2,22,6,6,182,90,0.15,13.5);
INSERT INTO grade VALUES(0,2,22,6,7,192,77,0.1,7.7);
INSERT INTO grade VALUES(0,2,22,9,1,66,78,0.05,3.9);
INSERT INTO grade VALUES(0,2,22,9,2,171,82,0.05,4.1);
INSERT INTO grade VALUES(0,2,22,9,3,237,94,0.05,4.7);
INSERT INTO grade VALUES(0,2,22,9,4,305,79,0.25,19.75);
INSERT INTO grade VALUES(0,2,22,9,5,323,99,0.25,24.75);
INSERT INTO grade VALUES(0,2,22,9,6,334,86,0.15,12.9);
INSERT INTO grade VALUES(0,2,22,7,8,307,75,0.1,7.5);
INSERT INTO grade VALUES(0,1,23,1,1,15,79,0.05,3.95);
INSERT INTO grade VALUES(0,1,23,1,2,34,77,0.05,3.85);
INSERT INTO grade VALUES(0,1,23,1,3,149,82,0.05,4.1);
INSERT INTO grade VALUES(0,1,23,1,4,217,77,0.25,19.25);
INSERT INTO grade VALUES(0,1,23,1,5,295,82,0.25,20.5);
INSERT INTO grade VALUES(0,6,23,2,2,10,78,0.05,3.9);
INSERT INTO grade VALUES(0,6,23,2,3,177,92,0.05,4.6);
INSERT INTO grade VALUES(0,6,23,2,1,320,80,0.05,4);
INSERT INTO grade VALUES(0,6,23,2,4,352,83,0.25,20.75);
INSERT INTO grade VALUES(0,6,23,3,1,122,72,0.05,3.6);
INSERT INTO grade VALUES(0,1,23,4,1,13,74,0.05,3.7);
INSERT INTO grade VALUES(0,1,23,4,2,30,80,0.05,4);
INSERT INTO grade VALUES(0,1,23,4,3,149,76,0.05,3.8);
INSERT INTO grade VALUES(0,1,23,4,4,207,88,0.25,22);
INSERT INTO grade VALUES(0,1,23,4,5,219,92,0.25,23);
INSERT INTO grade VALUES(0,1,23,4,6,248,86,0.15,12.9);
INSERT INTO grade VALUES(0,1,23,4,7,342,89,0.1,8.9);
INSERT INTO grade VALUES(0,4,23,5,1,61,79,0.05,3.95);
INSERT INTO grade VALUES(0,4,23,5,2,88,83,0.05,4.15);
INSERT INTO grade VALUES(0,4,23,5,3,106,83,0.05,4.15);
INSERT INTO grade VALUES(0,4,23,5,4,126,71,0.25,17.75);
INSERT INTO grade VALUES(0,4,23,5,5,235,100,0.25,25);
INSERT INTO grade VALUES(0,4,23,5,6,272,100,0.15,15);
INSERT INTO grade VALUES(0,4,23,5,7,360,86,0.1,8.6);
INSERT INTO grade VALUES(0,2,23,6,1,34,71,0.05,3.55);
INSERT INTO grade VALUES(0,2,23,6,2,42,86,0.05,4.3);
INSERT INTO grade VALUES(0,2,23,6,3,54,86,0.05,4.3);
INSERT INTO grade VALUES(0,2,23,6,4,72,100,0.25,25);
INSERT INTO grade VALUES(0,6,23,9,1,73,78,0.05,3.9);
INSERT INTO grade VALUES(0,6,23,9,2,102,84,0.05,4.2);
INSERT INTO grade VALUES(0,6,23,9,3,157,100,0.05,5);
INSERT INTO grade VALUES(0,6,23,9,4,221,92,0.25,23);
INSERT INTO grade VALUES(0,6,23,9,5,225,78,0.25,19.5);
INSERT INTO grade VALUES(0,6,23,9,6,315,82,0.15,12.3);
INSERT INTO grade VALUES(0,6,23,9,7,344,86,0.1,8.6);
INSERT INTO grade VALUES(0,2,23,7,5,237,81,0.25,20.25);
INSERT INTO grade VALUES(0,2,23,7,6,247,86,0.15,12.9);
INSERT INTO grade VALUES(0,2,23,7,7,264,76,0.1,7.6);
INSERT INTO grade VALUES(0,2,23,7,8,269,97,0.1,9.7);
INSERT INTO grade VALUES(0,2,24,1,1,294,99,0.05,4.95);
INSERT INTO grade VALUES(0,2,24,1,2,326,71,0.05,3.55);
INSERT INTO grade VALUES(0,2,24,1,3,337,81,0.05,4.05);
INSERT INTO grade VALUES(0,2,24,1,4,347,82,0.25,20.5);
INSERT INTO grade VALUES(0,2,24,2,1,2,79,0.05,3.95);
INSERT INTO grade VALUES(0,2,24,2,2,9,90,0.05,4.5);
INSERT INTO grade VALUES(0,2,24,2,3,21,87,0.05,4.35);
INSERT INTO grade VALUES(0,2,24,2,4,94,94,0.25,23.5);
INSERT INTO grade VALUES(0,2,24,2,5,125,75,0.25,18.75);
INSERT INTO grade VALUES(0,2,24,2,6,150,84,0.15,12.6);
INSERT INTO grade VALUES(0,2,24,2,7,233,84,0.1,8.4);
INSERT INTO grade VALUES(0,3,24,3,1,24,95,0.05,4.75);
INSERT INTO grade VALUES(0,3,24,3,2,150,75,0.05,3.75);
INSERT INTO grade VALUES(0,3,24,3,3,182,100,0.05,5);
INSERT INTO grade VALUES(0,3,24,3,4,191,71,0.25,17.75);
INSERT INTO grade VALUES(0,3,24,3,5,218,95,0.25,23.75);
INSERT INTO grade VALUES(0,3,24,3,6,342,87,0.15,13.05);
INSERT INTO grade VALUES(0,3,24,4,1,8,83,0.05,4.15);
INSERT INTO grade VALUES(0,3,24,4,2,36,96,0.05,4.8);
INSERT INTO grade VALUES(0,3,24,4,3,52,93,0.05,4.65);
INSERT INTO grade VALUES(0,3,24,4,4,84,99,0.25,24.75);
INSERT INTO grade VALUES(0,3,24,4,5,104,100,0.25,25);
INSERT INTO grade VALUES(0,3,24,4,6,109,71,0.15,10.65);
INSERT INTO grade VALUES(0,3,24,4,7,228,74,0.1,7.4);
INSERT INTO grade VALUES(0,3,24,4,8,266,92,0.1,9.2);
INSERT INTO grade VALUES(0,1,24,5,1,69,75,0.05,3.75);
INSERT INTO grade VALUES(0,1,24,5,2,88,80,0.05,4);
INSERT INTO grade VALUES(0,1,24,5,3,136,92,0.05,4.6);
INSERT INTO grade VALUES(0,1,24,5,4,188,94,0.25,23.5);
INSERT INTO grade VALUES(0,1,24,5,5,223,82,0.25,20.5);
INSERT INTO grade VALUES(0,1,24,5,6,364,94,0.15,14.1);
INSERT INTO grade VALUES(0,4,24,6,1,9,84,0.05,4.2);
INSERT INTO grade VALUES(0,4,24,6,2,91,99,0.05,4.95);
INSERT INTO grade VALUES(0,4,24,6,3,121,77,0.05,3.85);
INSERT INTO grade VALUES(0,4,24,6,4,177,93,0.25,23.25);
INSERT INTO grade VALUES(0,6,24,9,3,46,92,0.05,4.6);
INSERT INTO grade VALUES(0,6,24,9,4,129,72,0.25,18);
INSERT INTO grade VALUES(0,6,24,9,5,147,99,0.25,24.75);
INSERT INTO grade VALUES(0,6,24,9,6,171,74,0.15,11.1);
INSERT INTO grade VALUES(0,6,24,9,7,183,98,0.1,9.8);
INSERT INTO grade VALUES(0,6,24,9,1,281,98,0.05,4.9);
INSERT INTO grade VALUES(0,6,24,9,8,289,95,0.1,9.5);
INSERT INTO grade VALUES(0,6,24,9,2,363,77,0.05,3.85);
INSERT INTO grade VALUES(0,4,24,7,5,283,76,0.25,19);
INSERT INTO grade VALUES(0,4,24,7,6,330,78,0.15,11.7);
INSERT INTO grade VALUES(0,4,24,7,7,359,88,0.1,8.8);


# create payment table #########################################

CREATE TABLE payment
(
    payment_id    INT           NOT NULL PRIMARY KEY AUTO_INCREMENT,
    date_id       INT           NOT NULL,
    instructor_id INT           NOT NULL,
    course_id     INT           NOT NULL,
    state_code    CHAR(2)       NOT NULL,
    gross_pay     DECIMAL(6,2)  NOT NULL,
    tax           DECIMAL(6,2)  NOT NULL,
    net_pay       DECIMAL(6,2)  NOT NULL,

    CONSTRAINT date_fk2       FOREIGN KEY (date_id)       REFERENCES dates      (date_id),
    CONSTRAINT instructor_fk2 FOREIGN KEY (instructor_id) REFERENCES instructor (instructor_id),
    CONSTRAINT course_fk2     FOREIGN KEY (course_id)     REFERENCES course     (course_id),
    CONSTRAINT state_fk2      FOREIGN KEY (state_code)    REFERENCES state      (state_code)
);

INSERT INTO payment VALUES(0,15,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,15,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,15,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,15,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,15,1,5,'NY',1000,350,650);
INSERT INTO payment VALUES(0,15,1,6,'NY',1000,350,650);
INSERT INTO payment VALUES(0,15,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,15,2,4,'CT',1000,320,680);
INSERT INTO payment VALUES(0,15,2,1,'CT',1000,320,680);
INSERT INTO payment VALUES(0,15,2,5,'CT',1000,320,680);
INSERT INTO payment VALUES(0,15,2,6,'CT',1000,320,680);
INSERT INTO payment VALUES(0,15,2,2,'CT',1000,320,680);
INSERT INTO payment VALUES(0,15,3,4,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,15,3,9,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,15,3,1,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,15,3,3,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,15,3,6,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,15,3,2,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,15,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,15,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,15,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,15,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,15,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,15,4,6,'CT',1000,340,660);
INSERT INTO payment VALUES(0,15,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,15,6,4,'NY',1000,310,690);
INSERT INTO payment VALUES(0,15,6,9,'NY',1000,310,690);
INSERT INTO payment VALUES(0,15,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,15,6,3,'NY',1000,310,690);
INSERT INTO payment VALUES(0,15,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,15,6,6,'NY',1000,310,690);
INSERT INTO payment VALUES(0,15,6,2,'NY',1000,310,690);
INSERT INTO payment VALUES(0,46,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,46,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,46,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,46,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,46,1,5,'NY',1000,350,650);
INSERT INTO payment VALUES(0,46,1,6,'NY',1000,350,650);
INSERT INTO payment VALUES(0,46,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,46,2,4,'CT',1000,320,680);
INSERT INTO payment VALUES(0,46,2,9,'CT',1000,320,680);
INSERT INTO payment VALUES(0,46,2,1,'CT',1000,320,680);
INSERT INTO payment VALUES(0,46,2,5,'CT',1000,320,680);
INSERT INTO payment VALUES(0,46,2,6,'CT',1000,320,680);
INSERT INTO payment VALUES(0,46,2,2,'CT',1000,320,680);
INSERT INTO payment VALUES(0,46,3,4,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,46,3,9,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,46,3,1,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,46,3,3,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,46,3,5,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,46,3,6,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,46,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,46,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,46,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,46,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,46,4,6,'CT',1000,340,660);
INSERT INTO payment VALUES(0,46,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,46,6,4,'NY',1000,310,690);
INSERT INTO payment VALUES(0,46,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,46,6,3,'NY',1000,310,690);
INSERT INTO payment VALUES(0,46,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,46,6,6,'NY',1000,310,690);
INSERT INTO payment VALUES(0,46,6,2,'NY',1000,310,690);
INSERT INTO payment VALUES(0,74,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,74,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,74,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,74,1,5,'NY',1000,350,650);
INSERT INTO payment VALUES(0,74,1,6,'NY',1000,350,650);
INSERT INTO payment VALUES(0,74,2,4,'CT',1000,320,680);
INSERT INTO payment VALUES(0,74,2,6,'CT',1000,320,680);
INSERT INTO payment VALUES(0,74,2,1,'CT',1000,320,680);
INSERT INTO payment VALUES(0,74,2,3,'CT',1000,320,680);
INSERT INTO payment VALUES(0,74,2,5,'CT',1000,320,680);
INSERT INTO payment VALUES(0,74,2,6,'CT',1000,320,680);
INSERT INTO payment VALUES(0,74,2,2,'CT',1000,320,680);
INSERT INTO payment VALUES(0,74,3,4,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,74,3,6,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,74,3,1,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,74,3,5,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,74,3,6,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,74,3,2,'NJ',1000,330,670);
INSERT INTO payment VALUES(0,74,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,74,4,6,'CT',1000,340,660);
INSERT INTO payment VALUES(0,74,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,74,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,74,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,74,4,6,'CT',1000,340,660);
INSERT INTO payment VALUES(0,74,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,74,6,4,'NY',1000,310,690);
INSERT INTO payment VALUES(0,74,6,6,'NY',1000,310,690);
INSERT INTO payment VALUES(0,74,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,74,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,74,6,6,'NY',1000,310,690);
INSERT INTO payment VALUES(0,105,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,105,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,105,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,105,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,105,1,5,'NY',1000,350,650);
INSERT INTO payment VALUES(0,105,1,6,'NY',1000,350,650);
INSERT INTO payment VALUES(0,105,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,105,2,4,'CT',1000,320,680);
INSERT INTO payment VALUES(0,105,2,9,'CT',1000,320,680);
INSERT INTO payment VALUES(0,105,2,5,'CT',1000,320,680);
INSERT INTO payment VALUES(0,105,2,6,'CT',1000,320,680);
INSERT INTO payment VALUES(0,105,3,4,'NY',1000,330,670);
INSERT INTO payment VALUES(0,105,3,9,'NY',1000,330,670);
INSERT INTO payment VALUES(0,105,3,1,'NY',1000,330,670);
INSERT INTO payment VALUES(0,105,3,3,'NY',1000,330,670);
INSERT INTO payment VALUES(0,105,3,5,'NY',1000,330,670);
INSERT INTO payment VALUES(0,105,3,2,'NY',1000,330,670);
INSERT INTO payment VALUES(0,105,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,105,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,105,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,105,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,105,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,105,4,6,'CT',1000,340,660);
INSERT INTO payment VALUES(0,105,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,105,6,4,'NY',1000,310,690);
INSERT INTO payment VALUES(0,105,6,9,'NY',1000,310,690);
INSERT INTO payment VALUES(0,105,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,105,6,3,'NY',1000,310,690);
INSERT INTO payment VALUES(0,105,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,105,6,6,'NY',1000,310,690);
INSERT INTO payment VALUES(0,105,6,2,'NY',1000,310,690);
INSERT INTO payment VALUES(0,135,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,135,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,135,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,135,1,5,'NY',1000,350,650);
INSERT INTO payment VALUES(0,135,1,6,'NY',1000,350,650);
INSERT INTO payment VALUES(0,135,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,135,2,4,'CT',1000,320,680);
INSERT INTO payment VALUES(0,135,2,1,'CT',1000,320,680);
INSERT INTO payment VALUES(0,135,2,3,'CT',1000,320,680);
INSERT INTO payment VALUES(0,135,2,5,'CT',1000,320,680);
INSERT INTO payment VALUES(0,135,2,2,'CT',1000,320,680);
INSERT INTO payment VALUES(0,135,3,4,'NY',1000,330,670);
INSERT INTO payment VALUES(0,135,3,9,'NY',1000,330,670);
INSERT INTO payment VALUES(0,135,3,1,'NY',1000,330,670);
INSERT INTO payment VALUES(0,135,3,3,'NY',1000,330,670);
INSERT INTO payment VALUES(0,135,3,5,'NY',1000,330,670);
INSERT INTO payment VALUES(0,135,3,6,'NY',1000,330,670);
INSERT INTO payment VALUES(0,135,3,2,'NY',1000,330,670);
INSERT INTO payment VALUES(0,135,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,135,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,135,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,135,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,135,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,135,4,6,'CT',1000,340,660);
INSERT INTO payment VALUES(0,135,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,135,6,4,'NY',1000,310,690);
INSERT INTO payment VALUES(0,135,6,9,'NY',1000,310,690);
INSERT INTO payment VALUES(0,135,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,135,6,3,'NY',1000,310,690);
INSERT INTO payment VALUES(0,135,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,135,6,6,'NY',1000,310,690);
INSERT INTO payment VALUES(0,135,6,2,'NY',1000,310,690);
INSERT INTO payment VALUES(0,166,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,166,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,166,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,166,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,166,1,6,'NY',1000,350,650);
INSERT INTO payment VALUES(0,166,2,4,'CT',1000,320,680);
INSERT INTO payment VALUES(0,166,2,9,'CT',1000,320,680);
INSERT INTO payment VALUES(0,166,2,1,'CT',1000,320,680);
INSERT INTO payment VALUES(0,166,2,3,'CT',1000,320,680);
INSERT INTO payment VALUES(0,166,2,5,'CT',1000,320,680);
INSERT INTO payment VALUES(0,166,2,6,'CT',1000,320,680);
INSERT INTO payment VALUES(0,166,2,2,'CT',1000,320,680);
INSERT INTO payment VALUES(0,166,3,4,'NY',1000,330,670);
INSERT INTO payment VALUES(0,166,3,9,'NY',1000,330,670);
INSERT INTO payment VALUES(0,166,3,1,'NY',1000,330,670);
INSERT INTO payment VALUES(0,166,3,3,'NY',1000,330,670);
INSERT INTO payment VALUES(0,166,3,5,'NY',1000,330,670);
INSERT INTO payment VALUES(0,166,3,6,'NY',1000,330,670);
INSERT INTO payment VALUES(0,166,3,2,'NY',1000,330,670);
INSERT INTO payment VALUES(0,166,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,166,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,166,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,166,4,6,'CT',1000,340,660);
INSERT INTO payment VALUES(0,166,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,166,6,4,'NY',1000,310,690);
INSERT INTO payment VALUES(0,166,6,9,'NY',1000,310,690);
INSERT INTO payment VALUES(0,166,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,166,6,3,'NY',1000,310,690);
INSERT INTO payment VALUES(0,166,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,166,6,6,'NY',1000,310,690);
INSERT INTO payment VALUES(0,166,6,2,'NY',1000,310,690);
INSERT INTO payment VALUES(0,196,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,196,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,196,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,196,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,196,1,5,'NY',1000,350,650);
INSERT INTO payment VALUES(0,196,1,6,'NY',1000,350,650);
INSERT INTO payment VALUES(0,196,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,196,2,4,'CT',1000,320,680);
INSERT INTO payment VALUES(0,196,2,9,'CT',1000,320,680);
INSERT INTO payment VALUES(0,196,2,1,'CT',1000,320,680);
INSERT INTO payment VALUES(0,196,2,5,'CT',1000,320,680);
INSERT INTO payment VALUES(0,196,2,6,'CT',1000,320,680);
INSERT INTO payment VALUES(0,196,3,4,'NY',1000,330,670);
INSERT INTO payment VALUES(0,196,3,9,'NY',1000,330,670);
INSERT INTO payment VALUES(0,196,3,1,'NY',1000,330,670);
INSERT INTO payment VALUES(0,196,3,3,'NY',1000,330,670);
INSERT INTO payment VALUES(0,196,3,5,'NY',1000,330,670);
INSERT INTO payment VALUES(0,196,3,6,'NY',1000,330,670);
INSERT INTO payment VALUES(0,196,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,196,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,196,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,196,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,196,4,6,'CT',1000,340,660);
INSERT INTO payment VALUES(0,196,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,196,6,9,'NY',1000,310,690);
INSERT INTO payment VALUES(0,196,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,196,6,3,'NY',1000,310,690);
INSERT INTO payment VALUES(0,196,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,196,6,6,'NY',1000,310,690);
INSERT INTO payment VALUES(0,196,6,2,'NY',1000,310,690);
INSERT INTO payment VALUES(0,227,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,227,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,227,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,227,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,227,1,7,'NY',1000,350,650);
INSERT INTO payment VALUES(0,227,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,227,2,4,'CT',1000,320,680);
INSERT INTO payment VALUES(0,227,2,9,'CT',1000,320,680);
INSERT INTO payment VALUES(0,227,2,1,'CT',1000,320,680);
INSERT INTO payment VALUES(0,227,2,3,'CT',1000,320,680);
INSERT INTO payment VALUES(0,227,2,5,'CT',1000,320,680);
INSERT INTO payment VALUES(0,227,2,7,'CT',1000,320,680);
INSERT INTO payment VALUES(0,227,3,4,'NY',1000,330,670);
INSERT INTO payment VALUES(0,227,3,9,'NY',1000,330,670);
INSERT INTO payment VALUES(0,227,3,1,'NY',1000,330,670);
INSERT INTO payment VALUES(0,227,3,3,'NY',1000,330,670);
INSERT INTO payment VALUES(0,227,3,7,'NY',1000,330,670);
INSERT INTO payment VALUES(0,227,3,2,'NY',1000,330,670);
INSERT INTO payment VALUES(0,227,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,227,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,227,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,227,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,227,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,227,4,7,'CT',1000,340,660);
INSERT INTO payment VALUES(0,227,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,227,6,4,'NY',1000,310,690);
INSERT INTO payment VALUES(0,227,6,9,'NY',1000,310,690);
INSERT INTO payment VALUES(0,227,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,227,6,3,'NY',1000,310,690);
INSERT INTO payment VALUES(0,227,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,227,6,7,'NY',1000,310,690);
INSERT INTO payment VALUES(0,227,6,2,'NY',1000,310,690);
INSERT INTO payment VALUES(0,258,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,258,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,258,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,258,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,258,2,4,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,258,2,9,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,258,2,1,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,258,2,5,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,258,2,7,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,258,2,2,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,258,3,4,'NY',1000,330,670);
INSERT INTO payment VALUES(0,258,3,9,'NY',1000,330,670);
INSERT INTO payment VALUES(0,258,3,1,'NY',1000,330,670);
INSERT INTO payment VALUES(0,258,3,3,'NY',1000,330,670);
INSERT INTO payment VALUES(0,258,3,5,'NY',1000,330,670);
INSERT INTO payment VALUES(0,258,3,7,'NY',1000,330,670);
INSERT INTO payment VALUES(0,258,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,258,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,258,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,258,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,258,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,258,4,7,'CT',1000,340,660);
INSERT INTO payment VALUES(0,258,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,258,6,4,'NY',1000,310,690);
INSERT INTO payment VALUES(0,258,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,258,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,258,6,7,'NY',1000,310,690);
INSERT INTO payment VALUES(0,288,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,288,1,7,'NY',1000,350,650);
INSERT INTO payment VALUES(0,288,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,288,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,288,1,5,'NY',1000,350,650);
INSERT INTO payment VALUES(0,288,1,7,'NY',1000,350,650);
INSERT INTO payment VALUES(0,288,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,288,2,4,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,288,2,9,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,288,2,1,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,288,2,3,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,288,2,5,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,288,2,7,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,288,2,2,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,288,3,4,'NY',1000,330,670);
INSERT INTO payment VALUES(0,288,3,9,'NY',1000,330,670);
INSERT INTO payment VALUES(0,288,3,1,'NY',1000,330,670);
INSERT INTO payment VALUES(0,288,3,3,'NY',1000,330,670);
INSERT INTO payment VALUES(0,288,3,5,'NY',1000,330,670);
INSERT INTO payment VALUES(0,288,3,7,'NY',1000,330,670);
INSERT INTO payment VALUES(0,288,3,2,'NY',1000,330,670);
INSERT INTO payment VALUES(0,288,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,288,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,288,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,288,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,288,4,7,'CT',1000,340,660);
INSERT INTO payment VALUES(0,288,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,288,6,4,'NY',1000,310,690);
INSERT INTO payment VALUES(0,288,6,9,'NY',1000,310,690);
INSERT INTO payment VALUES(0,288,6,1,'NY',1000,310,690);
INSERT INTO payment VALUES(0,288,6,3,'NY',1000,310,690);
INSERT INTO payment VALUES(0,288,6,5,'NY',1000,310,690);
INSERT INTO payment VALUES(0,288,6,7,'NY',1000,310,690);
INSERT INTO payment VALUES(0,288,6,2,'NY',1000,310,690);
INSERT INTO payment VALUES(0,319,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,319,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,319,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,319,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,319,1,5,'NY',1000,350,650);
INSERT INTO payment VALUES(0,319,1,7,'NY',1000,350,650);
INSERT INTO payment VALUES(0,319,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,319,2,4,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,319,2,9,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,319,2,1,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,319,2,5,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,319,2,7,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,319,2,2,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,319,3,4,'NY',1000,330,670);
INSERT INTO payment VALUES(0,319,3,9,'NY',1000,330,670);
INSERT INTO payment VALUES(0,319,3,1,'NY',1000,330,670);
INSERT INTO payment VALUES(0,319,3,3,'NY',1000,330,670);
INSERT INTO payment VALUES(0,319,3,5,'NY',1000,330,670);
INSERT INTO payment VALUES(0,319,3,7,'NY',1000,330,670);
INSERT INTO payment VALUES(0,319,3,2,'NY',1000,330,670);
INSERT INTO payment VALUES(0,319,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,319,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,319,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,319,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,319,4,7,'CT',1000,340,660);
INSERT INTO payment VALUES(0,319,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,319,6,4,'PA',1000,310,690);
INSERT INTO payment VALUES(0,319,6,9,'PA',1000,310,690);
INSERT INTO payment VALUES(0,319,6,1,'PA',1000,310,690);
INSERT INTO payment VALUES(0,319,6,3,'PA',1000,310,690);
INSERT INTO payment VALUES(0,319,6,5,'PA',1000,310,690);
INSERT INTO payment VALUES(0,319,6,7,'PA',1000,310,690);
INSERT INTO payment VALUES(0,319,6,2,'PA',1000,310,690);
INSERT INTO payment VALUES(0,349,1,4,'NY',1000,350,650);
INSERT INTO payment VALUES(0,349,1,9,'NY',1000,350,650);
INSERT INTO payment VALUES(0,349,1,1,'NY',1000,350,650);
INSERT INTO payment VALUES(0,349,1,3,'NY',1000,350,650);
INSERT INTO payment VALUES(0,349,1,5,'NY',1000,350,650);
INSERT INTO payment VALUES(0,349,1,7,'NY',1000,350,650);
INSERT INTO payment VALUES(0,349,1,2,'NY',1000,350,650);
INSERT INTO payment VALUES(0,349,2,4,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,349,2,9,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,349,2,3,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,349,2,5,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,349,2,7,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,349,2,2,'NJ',1000,320,680);
INSERT INTO payment VALUES(0,349,3,4,'NY',1000,330,670);
INSERT INTO payment VALUES(0,349,3,9,'NY',1000,330,670);
INSERT INTO payment VALUES(0,349,3,1,'NY',1000,330,670);
INSERT INTO payment VALUES(0,349,3,3,'NY',1000,330,670);
INSERT INTO payment VALUES(0,349,3,5,'NY',1000,330,670);
INSERT INTO payment VALUES(0,349,3,7,'NY',1000,330,670);
INSERT INTO payment VALUES(0,349,3,2,'NY',1000,330,670);
INSERT INTO payment VALUES(0,349,4,4,'CT',1000,340,660);
INSERT INTO payment VALUES(0,349,4,9,'CT',1000,340,660);
INSERT INTO payment VALUES(0,349,4,1,'CT',1000,340,660);
INSERT INTO payment VALUES(0,349,4,3,'CT',1000,340,660);
INSERT INTO payment VALUES(0,349,4,5,'CT',1000,340,660);
INSERT INTO payment VALUES(0,349,4,7,'CT',1000,340,660);
INSERT INTO payment VALUES(0,349,4,2,'CT',1000,340,660);
INSERT INTO payment VALUES(0,349,6,4,'PA',1000,310,690);
INSERT INTO payment VALUES(0,349,6,9,'PA',1000,310,690);
INSERT INTO payment VALUES(0,349,6,1,'PA',1000,310,690);
INSERT INTO payment VALUES(0,349,6,5,'PA',1000,310,690);
INSERT INTO payment VALUES(0,349,6,7,'PA',1000,310,690);
INSERT INTO payment VALUES(0,349,6,2,'PA',1000,310,690);


# create v_key_column view ################################################

CREATE VIEW v_key_column AS
SELECT k.table_name, k.column_name,  
       REPLACE(t.constraint_type,'PRIMARY',' PRIMARY') AS constraint_type,
       k.constraint_name, k.ordinal_position,
       k.referenced_table_name as ref_table_name, k.referenced_column_name as ref_column_name  
FROM information_schema.table_constraints t, information_schema.key_column_usage k 
WHERE t.table_schema    = k.table_schema
  AND t.table_name      = k.table_name
  AND t.constraint_name = k.constraint_name 
ORDER BY 1,3,2,4,5;