Closed marcelinalinaa closed 3 years ago
DROP TABLE extracurricular_score; CREATE TABLE extracurricular_score( student_id CHAR(5) NOT NULL ,academic_year VARCHAR(9) NOT NULL ,semester INTEGER NOT NULL ,input_date DATE NOT NULL ,extracurricular_score INTEGER NOT NULL , PRIMARY KEY(academic_year, semester,student_id) , FOREIGN KEY(student_id) REFERENCES student(student_id) ); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2018/2019',1,'2018-12-10',74); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2018/2019',1,'2018-12-13',88); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2018/2019',1,'2018-12-22',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2018/2019',1,'2018-12-08',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2018/2019',1,'2018-12-03',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2018/2019',2,'2019-07-05',60); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2018/2019',2,'2019-07-08',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2018/2019',2,'2019-07-09',78); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2018/2019',2,'2019-07-11',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2018/2019',2,'2019-07-12',75); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00006','2019/2020',1,'2019-12-11',63); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00007','2019/2020',1,'2019-12-12',79); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00012','2019/2020',1,'2019-12-13',83); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00013','2019/2020',1,'2019-12-14',64); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00014','2019/2020',1,'2019-12-11',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00015','2019/2020',1,'2019-12-11',69); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2019/2020',1,'2019-12-12',78); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2019/2020',1,'2019-12-14',90); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2019/2020',1,'2019-12-11',84); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2019/2020',1,'2019-12-11',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2019/2020',1,'2019-12-12',89); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00008','2019/2020',1,'2019-12-13',75); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00009','2019/2020',1,'2019-12-13',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00010','2019/2020',1,'2019-12-12',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00011','2019/2020',1,'2019-12-11',64); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00006','2019/2020',2,'2020-07-18',70); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00007','2019/2020',2,'2020-07-13',79); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00012','2019/2020',2,'2020-07-13',80); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00013','2019/2020',2,'2020-07-18',61); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00014','2019/2020',2,'2020-07-12',65); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00015','2019/2020',2,'2020-07-12',70); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2019/2020',2,'2020-07-18',71); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2019/2020',2,'2020-07-13',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2019/2020',2,'2020-07-14',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2019/2020',2,'2020-07-11',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2019/2020',2,'2020-07-12',61); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00008','2019/2020',2,'2020-07-18',90); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00009','2019/2020',2,'2020-07-14',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00010','2019/2020',2,'2020-07-11',78); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00011','2019/2020',2,'2020-07-12',82); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2020/2021',1,'2020-12-11',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00006','2020/2021',1,'2020-12-13',89); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00010','2020/2021',1,'2020-12-11',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00011','2020/2021',1,'2020-12-13',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00018','2020/2021',1,'2020-12-14',85); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00020','2020/2021',1,'2020-12-11',85); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00009','2020/2021',1,'2020-12-11',69); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00022','2020/2021',1,'2020-12-11',84); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2020/2021',1,'2020-12-11',81); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00013','2020/2021',1,'2020-12-11',63); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2020/2021',1,'2020-12-13',82); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00016','2020/2021',1,'2020-12-13',88); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00017','2020/2021',1,'2020-12-11',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00019','2020/2021',1,'2020-12-11',72); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2020/2021',1,'2020-12-14',83); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00007','2020/2021',1,'2020-12-13',90); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00008','2020/2021',1,'2020-12-11',67); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00015','2020/2021',1,'2020-12-14',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00021','2020/2021',1,'2020-12-14',85); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00023','2020/2021',1,'2020-12-11',81); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00024','2020/2021',1,'2020-12-11',72); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2020/2021',1,'2020-12-11',72); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00012','2020/2021',1,'2020-12-11',81); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00014','2020/2021',1,'2020-12-14',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00025','2020/2021',1,'2020-12-11',79); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2020/2021',2,'2021-07-10',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00006','2020/2021',2,'2021-07-11',75); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00010','2020/2021',2,'2021-07-10',62); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00011','2020/2021',2,'2021-07-11',82); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00018','2020/2021',2,'2021-07-12',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00020','2020/2021',2,'2021-07-09',71); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00009','2020/2021',2,'2021-07-09',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00022','2020/2021',2,'2021-07-09',79); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2020/2021',2,'2021-07-09',61); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00013','2020/2021',2,'2021-07-09',71); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2020/2021',2,'2021-07-11',88); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00016','2020/2021',2,'2021-07-11',84); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00017','2020/2021',2,'2021-07-09',70); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00019','2020/2021',2,'2021-07-10',63); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2020/2021',2,'2021-07-12',88); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00007','2020/2021',2,'2021-07-11',84); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00008','2020/2021',2,'2021-07-09',63); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00015','2020/2021',2,'2021-07-12',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00021','2020/2021',2,'2021-07-12',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00023','2020/2021',2,'2021-07-09',64); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00024','2020/2021',2,'2021-07-11',90); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2020/2021',2,'2021-07-11',68); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00012','2020/2021',2,'2021-07-11',74); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00014','2020/2021',2,'2021-07-12',81); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00025','2020/2021',2,'2021-07-11',81);
DROP TABLE extracurricular_score; CREATE TABLE extracurricular_score( student_id CHAR(5) NOT NULL ,academic_year VARCHAR(9) NOT NULL ,semester INTEGER NOT NULL ,input_date DATE NOT NULL ,extracurricular_score INTEGER NOT NULL , PRIMARY KEY(academic_year, semester,student_id) , FOREIGN KEY(student_id) REFERENCES student(student_id) ); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2018/2019',1,'2018-12-10',74); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2018/2019',1,'2018-12-13',88); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2018/2019',1,'2018-12-22',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2018/2019',1,'2018-12-08',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2018/2019',1,'2018-12-03',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2018/2019',2,'2019-07-05',60); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2018/2019',2,'2019-07-08',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2018/2019',2,'2019-07-09',78); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2018/2019',2,'2019-07-11',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2018/2019',2,'2019-07-12',75); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00006','2019/2020',1,'2019-12-11',63); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00007','2019/2020',1,'2019-12-12',79); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00012','2019/2020',1,'2019-12-13',83); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00013','2019/2020',1,'2019-12-14',64); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00014','2019/2020',1,'2019-12-11',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00015','2019/2020',1,'2019-12-11',69); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2019/2020',1,'2019-12-12',78); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2019/2020',1,'2019-12-14',90); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2019/2020',1,'2019-12-11',84); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2019/2020',1,'2019-12-11',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2019/2020',1,'2019-12-12',89); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00008','2019/2020',1,'2019-12-13',75); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00009','2019/2020',1,'2019-12-13',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00010','2019/2020',1,'2019-12-12',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00011','2019/2020',1,'2019-12-11',64); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00006','2019/2020',2,'2020-07-18',70); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00007','2019/2020',2,'2020-07-13',79); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00012','2019/2020',2,'2020-07-13',80); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00013','2019/2020',2,'2020-07-18',61); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00014','2019/2020',2,'2020-07-12',65); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00015','2019/2020',2,'2020-07-12',70); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2019/2020',2,'2020-07-18',71); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2019/2020',2,'2020-07-13',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2019/2020',2,'2020-07-14',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2019/2020',2,'2020-07-11',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2019/2020',2,'2020-07-12',61); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00008','2019/2020',2,'2020-07-18',90); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00009','2019/2020',2,'2020-07-14',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00010','2019/2020',2,'2020-07-11',78); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00011','2019/2020',2,'2020-07-12',82); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2020/2021',1,'2020-12-11',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00006','2020/2021',1,'2020-12-13',89); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00010','2020/2021',1,'2020-12-11',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00011','2020/2021',1,'2020-12-13',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00018','2020/2021',1,'2020-12-14',85); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00020','2020/2021',1,'2020-12-11',85); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00009','2020/2021',1,'2020-12-11',69); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00022','2020/2021',1,'2020-12-11',84); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2020/2021',1,'2020-12-11',81); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00013','2020/2021',1,'2020-12-11',63); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2020/2021',1,'2020-12-13',82); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00016','2020/2021',1,'2020-12-13',88); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00017','2020/2021',1,'2020-12-11',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00019','2020/2021',1,'2020-12-11',72); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2020/2021',1,'2020-12-14',83); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00007','2020/2021',1,'2020-12-13',90); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00008','2020/2021',1,'2020-12-11',67); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00015','2020/2021',1,'2020-12-14',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00021','2020/2021',1,'2020-12-14',85); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00023','2020/2021',1,'2020-12-11',81); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00024','2020/2021',1,'2020-12-11',72); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2020/2021',1,'2020-12-11',72); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00012','2020/2021',1,'2020-12-11',81); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00014','2020/2021',1,'2020-12-14',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00025','2020/2021',1,'2020-12-11',79); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00003','2020/2021',2,'2021-07-10',86); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00006','2020/2021',2,'2021-07-11',75); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00010','2020/2021',2,'2021-07-10',62); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00011','2020/2021',2,'2021-07-11',82); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00018','2020/2021',2,'2021-07-12',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00020','2020/2021',2,'2021-07-09',71); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00009','2020/2021',2,'2021-07-09',77); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00022','2020/2021',2,'2021-07-09',79); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00001','2020/2021',2,'2021-07-09',61); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00013','2020/2021',2,'2021-07-09',71); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00004','2020/2021',2,'2021-07-11',88); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00016','2020/2021',2,'2021-07-11',84); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00017','2020/2021',2,'2021-07-09',70); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00019','2020/2021',2,'2021-07-10',63); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00002','2020/2021',2,'2021-07-12',88); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00007','2020/2021',2,'2021-07-11',84); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00008','2020/2021',2,'2021-07-09',63); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00015','2020/2021',2,'2021-07-12',76); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00021','2020/2021',2,'2021-07-12',87); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00023','2020/2021',2,'2021-07-09',64); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00024','2020/2021',2,'2021-07-11',90); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00005','2020/2021',2,'2021-07-11',68); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00012','2020/2021',2,'2021-07-11',74); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00014','2020/2021',2,'2021-07-12',81); INSERT INTO extracurricular_score(student_id,academic_year,semester,input_date,extracurricular_score) VALUES ('00025','2020/2021',2,'2021-07-11',81);