验证中...
片段 1 片段 2
程序媛一枚,有不对的、写的饶的请各方大佬多多指教,这局我就单票挂9。附件为初始化表、数据。
原始数据 复制代码
-- 1.查询学生名称’浮梦‘的编码
SELECT ID FROM student WHERE NAME='浮梦';
-- 2.查询班级名称‘二班’的编码
SELECT ID FROM class C WHERE C.NAME='二班';
-- 3.查询班级名称‘二班’的学生名单
SELECT S.ID,S.NAME FROM student S JOIN class C ON S.CLASSID = C.ID WHERE C.NAME='二班';
-- 4.查询学生名称‘旧梦’所在班级名称
SELECT C.NAME FROM student S LEFT JOIN class C ON S.CLASSID = C.ID WHERE S.NAME='旧梦';
-- 5.查询同班中是名称相同的学生名称、班级
SELECT C.NAME,A.NAME FROM class C JOIN (
SELECT S.CLASSID,S.NAME FROM student S GROUP BY S.CLASSID,S.NAME HAVING COUNT(S.NAME)>1
) A ON C.ID = A.CLASSID;
-- 6.查询名称相同的学生名称、所在班级
SELECT C.NAME,A.NAME FROM (
SELECT S.NAME FROM student S GROUP BY S.NAME HAVING COUNT(S.NAME)>1
) A JOIN student S ON A.NAME = S.NAME JOIN class C ON C.ID = S.CLASSID ORDER BY S.`NAME` ;
-- 7.查询平均分大于等于60的学生名单
SELECT s.* FROM student S join (
SELECT STUDENTID FROM score GROUP BY STUDENTID HAVING avg(score)>=60
) A ON S.ID = A.STUDENTID;
-- 8.查询班级名称’二班‘学科’物理‘的平均分
-- IN
SELECT AVG(SC.SCORE) FROM score SC WHERE SC.SUBJECTID =
(
SELECT ID FROM `subject` WHERE NAME='物理'
) AND STUDENTID IN(
SELECT ID FROM student S WHERE S.CLASSID =
(
SELECT C.ID FROM class C WHERE C.`NAME`='二班'
)
);
-- EXISTS
SELECT AVG(SC.SCORE) FROM score SC WHERE EXISTS(
SELECT ID FROM student S WHERE S.CLASSID =
(
SELECT C.ID FROM class C WHERE C.`NAME`='二班'
) AND SC.STUDENTID = S.ID
) AND SC.SUBJECTID =
(
SELECT ID FROM `subject` WHERE NAME='物理'
);
-- 9.查询班级名称’二班‘的各科及格率
SELECT SU.NAME AS 科目,CONCAT(ROUND(B.PASSRATE*100,2),'%') AS 及格率(百分比) FROM `subject` SU JOIN (
SELECT SC.SUBJECTID,COUNT(CASE WHEN SC.SCORE>=60 THEN STUDENTID END)/COUNT(CASE WHEN SC.SCORE<60 THEN STUDENTID END) AS PASSRATE FROM score SC WHERE SC.STUDENTID IN(
SELECT ID FROM student S WHERE S.CLASSID =
(
SELECT C.ID FROM class C WHERE C.`NAME`='二班'
)
) GROUP BY SC.SUBJECTID
) B ON SU.ID=B.SUBJECTID;
-- 10.查询各班各科的平均分、最高分、最低分、最高分学生名称、最低分学生名称
-- (1)写的有点绕
SELECT A.CLASSID,A.SUBJECTID,A.AVGSCORE '平均分',A.MAXSCORE '最高分',A.CLASSMAXSCORE '最高分学生',A.MINSCORE '最低分',GROUP_CONCAT(B.NAME) '最低分学生'
FROM(
SELECT A.CLASSID,A.SUBJECTID,A.AVGSCORE,A.MAXSCORE,GROUP_CONCAT(B.NAME) CLASSMAXSCORE,A.MINSCORE
FROM (
SELECT SC.SUBJECTID,ST.CLASSID,MAX(SC.SCORE) MAXSCORE,MIN(SC.SCORE) MINSCORE,AVG(SC.SCORE) AVGSCORE FROM score SC,student ST WHERE SC.STUDENTID = ST.ID GROUP BY SC.SUBJECTID,ST.CLASSID
) A,(
SELECT S1.ID,S1.NAME,S1.CLASSID,S2.SCORE,S2.SUBJECTID FROM student S1,score S2 WHERE S1.ID = S2.STUDENTID
) B WHERE A.MAXSCORE = B.SCORE AND A.CLASSID = B.CLASSID AND A.SUBJECTID = B.SUBJECTID
GROUP BY A.CLASSID,A.SUBJECTID
) A,(
SELECT S1.ID,S1.NAME,S1.CLASSID,S2.SCORE,S2.SUBJECTID FROM student S1,score S2 WHERE S1.ID = S2.STUDENTID
) B WHERE A.MINSCORE = B.SCORE AND A.CLASSID = B.CLASSID AND A.SUBJECTID = B.SUBJECTID
GROUP BY A.CLASSID,A.SUBJECTID
ORDER BY A.CLASSID,A.SUBJECTID;
-- 11.查询所有学科都及格(成绩大于等于60)的学生名称
SELECT S1.* FROM STUDENT S1 JOIN(
SELECT S.STUDENTID,count(1) FROM SCORE S WHERE S.SCORE>=60 GROUP BY S.STUDENTID HAVING
COUNT(1) = (SELECT count(1) FROM SUBJECT)
) S2 ON S1.ID = S2.STUDENTID;
-- 12.查询总分最高的学生、以及各科成绩、所在班级、总分
-- GROUP_CONCAT
SELECT S.ID,S.NAME '学生名称',C.NAME '班级',A.sumScore '总分',CONVERT(GROUP_CONCAT(CONCAT_WS('-',S2.NAME,S1.SCORE)) USING utf8) '各科成绩' from student S JOIN
(
SELECT STUDENTID,sum(SCORE) sumScore FROM score GROUP BY STUDENTID ORDER BY sumScore DESC LIMIT 1
) A ON S.ID = A.STUDENTID JOIN class C ON S.CLASSID = C.ID JOIN score S1 ON S.ID = S1.STUDENTID
JOIN SUBJECT S2 ON S1.SUBJECTID = S2.ID GROUP BY S.ID;
-- 13.查询总分前三的学生、以及各科成绩、所在班级
SELECT S.ID,S.NAME '学生名称',C.NAME '班级',A.sumScore '总分',CONVERT(GROUP_CONCAT(CONCAT_WS('-',S2.NAME,S1.SCORE)) USING utf8) '各科成绩' from student S JOIN
(
SELECT STUDENTID,sum(SCORE) sumScore FROM score GROUP BY STUDENTID ORDER BY sumScore DESC LIMIT 3
) A ON S.ID = A.STUDENTID JOIN class C ON S.CLASSID = C.ID JOIN score S1 ON S.ID = S1.STUDENTID
JOIN SUBJECT S2 ON S1.SUBJECTID = S2.ID GROUP BY S.ID;
SQL表、初始化数据.txt
原始数据 复制代码
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237
CREATE TABLE CLASS
(
ID INT(4) COMMENT '编号',
NAME VARCHAR(10) COMMENT '名称'
) COMMENT='班级表';
INSERT INTO CLASS VALUES(1001,'一班');
INSERT INTO CLASS VALUES(1002,'二班');
INSERT INTO CLASS VALUES(1003,'三班');
INSERT INTO CLASS VALUES(1004,'四班');
CREATE TABLE STUDENT
(
ID INT(4) COMMENT '编号',
NAME VARCHAR(10) COMMENT '名称',
CLASSID INT(4) COMMENT '所属班级编号'
) COMMENT='学生表';
INSERT INTO STUDENT VALUES(1,'闭眸',1004);
INSERT INTO STUDENT VALUES(2,'九槑',1001);
INSERT INTO STUDENT VALUES(3,'酒归',1001);
INSERT INTO STUDENT VALUES(4,'夜巷',1002);
INSERT INTO STUDENT VALUES(5,'阑意',1003);
INSERT INTO STUDENT VALUES(6,'饱暖',1004);
INSERT INTO STUDENT VALUES(7,'醉眠',1004);
INSERT INTO STUDENT VALUES(8,'胜算',1004);
INSERT INTO STUDENT VALUES(9,'神秘',1002);
INSERT INTO STUDENT VALUES(10,'诱僧',1003);
INSERT INTO STUDENT VALUES(11,'吹捧',1003);
INSERT INTO STUDENT VALUES(12,'仙风',1004);
INSERT INTO STUDENT VALUES(13,'简信',1003);
INSERT INTO STUDENT VALUES(14,'释怀',1001);
INSERT INTO STUDENT VALUES(15,'梦绕',1001);
INSERT INTO STUDENT VALUES(16,'青山',1002);
INSERT INTO STUDENT VALUES(17,'夜叔',1002);
INSERT INTO STUDENT VALUES(18,'道观',1002);
INSERT INTO STUDENT VALUES(19,'草民',1004);
INSERT INTO STUDENT VALUES(20,'阁楼',1003);
INSERT INTO STUDENT VALUES(21,'清影',1003);
INSERT INTO STUDENT VALUES(22,'仙儿',1004);
INSERT INTO STUDENT VALUES(23,'遮口',1001);
INSERT INTO STUDENT VALUES(24,'人才',1002);
INSERT INTO STUDENT VALUES(25,'绵衫',1001);
INSERT INTO STUDENT VALUES(26,'忌医',1004);
INSERT INTO STUDENT VALUES(27,'驾鹤',1002);
INSERT INTO STUDENT VALUES(28,'雷同',1003);
INSERT INTO STUDENT VALUES(29,'门徒',1002);
INSERT INTO STUDENT VALUES(30,'茶浅',1002);
INSERT INTO STUDENT VALUES(31,'长欢',1003);
INSERT INTO STUDENT VALUES(32,'俗趣',1004);
INSERT INTO STUDENT VALUES(33,'禁忌',1003);
INSERT INTO STUDENT VALUES(34,'知善',1002);
INSERT INTO STUDENT VALUES(35,'服气',1004);
INSERT INTO STUDENT VALUES(36,'酒人',1004);
INSERT INTO STUDENT VALUES(37,'矮狗',1001);
INSERT INTO STUDENT VALUES(38,'喜空',1001);
INSERT INTO STUDENT VALUES(39,'喜挽',1002);
INSERT INTO STUDENT VALUES(40,'鹤渡',1001);
INSERT INTO STUDENT VALUES(41,'深夜',1002);
INSERT INTO STUDENT VALUES(42,'仙度',1001);
INSERT INTO STUDENT VALUES(43,'稳心',1002);
INSERT INTO STUDENT VALUES(44,'凉意',1003);
INSERT INTO STUDENT VALUES(45,'配角',1004);
INSERT INTO STUDENT VALUES(46,'鸢浅',1003);
INSERT INTO STUDENT VALUES(47,'傲寒',1004);
INSERT INTO STUDENT VALUES(48,'若兮',1002);
INSERT INTO STUDENT VALUES(49,'殇璃',1001);
INSERT INTO STUDENT VALUES(50,'予笙',1002);
INSERT INTO STUDENT VALUES(51,'西瑶',1002);
INSERT INTO STUDENT VALUES(52,'入怹',1004);
INSERT INTO STUDENT VALUES(53,'余梦`',1003);
INSERT INTO STUDENT VALUES(54,'凉笙。',1002);
INSERT INTO STUDENT VALUES(55,'嫑怹',1004);
INSERT INTO STUDENT VALUES(56,'后来',1002);
INSERT INTO STUDENT VALUES(57,'忆殇',1002);
INSERT INTO STUDENT VALUES(58,'殇璃',1003);
INSERT INTO STUDENT VALUES(59,'心癌',1003);
INSERT INTO STUDENT VALUES(60,'初心',1004);
INSERT INTO STUDENT VALUES(61,'孤巷',1004);
INSERT INTO STUDENT VALUES(62,'夕颜i',1001);
INSERT INTO STUDENT VALUES(63,'孤惯',1004);
INSERT INTO STUDENT VALUES(64,'离觞',1003);
INSERT INTO STUDENT VALUES(65,'忆梦',1001);
INSERT INTO STUDENT VALUES(66,'颜初*',1002);
INSERT INTO STUDENT VALUES(67,'冷巷',1003);
INSERT INTO STUDENT VALUES(68,'絔離',1001);
INSERT INTO STUDENT VALUES(69,'余烬',1002);
INSERT INTO STUDENT VALUES(70,'╭⌒浅安°',1003);
INSERT INTO STUDENT VALUES(71,'橪书',1001);
INSERT INTO STUDENT VALUES(72,'信愁',1004);
INSERT INTO STUDENT VALUES(73,'陋女',1004);
INSERT INTO STUDENT VALUES(74,'声掩',1002);
INSERT INTO STUDENT VALUES(75,'旧阳',1001);
INSERT INTO STUDENT VALUES(76,'酷腻',1001);
INSERT INTO STUDENT VALUES(77,'眉薄',1002);
INSERT INTO STUDENT VALUES(78,'囍神',1002);
INSERT INTO STUDENT VALUES(79,'北橙',1003);
INSERT INTO STUDENT VALUES(80,'假寐',1004);
INSERT INTO STUDENT VALUES(81,'柚屿',1002);
INSERT INTO STUDENT VALUES(82,'允你',1004);
INSERT INTO STUDENT VALUES(83,'淤浪',1004);
INSERT INTO STUDENT VALUES(84,'散漫',1004);
INSERT INTO STUDENT VALUES(85,'熙攘',1003);
INSERT INTO STUDENT VALUES(86,'吃醋',1003);
INSERT INTO STUDENT VALUES(87,'难笑',1003);
INSERT INTO STUDENT VALUES(88,'醉友',1001);
INSERT INTO STUDENT VALUES(89,'猫九',1003);
INSERT INTO STUDENT VALUES(90,'葜密',1001);
INSERT INTO STUDENT VALUES(91,'淡墨',1003);
INSERT INTO STUDENT VALUES(92,'略暖',1001);
INSERT INTO STUDENT VALUES(93,'婪瘾',1003);
INSERT INTO STUDENT VALUES(94,'森鹿',1003);
INSERT INTO STUDENT VALUES(95,'相许',1003);
INSERT INTO STUDENT VALUES(96,'等灯',1004);
INSERT INTO STUDENT VALUES(97,'尤礼',1002);
INSERT INTO STUDENT VALUES(98,'瑾澜',1003);
INSERT INTO STUDENT VALUES(99,'花夏',1002);
INSERT INTO STUDENT VALUES(100,'浮炔',1002);
INSERT INTO STUDENT VALUES(101,'囍旧',1001);
INSERT INTO STUDENT VALUES(102,'心伤',1004);
INSERT INTO STUDENT VALUES(103,'唤命',1001);
INSERT INTO STUDENT VALUES(104,'忆心',1003);
INSERT INTO STUDENT VALUES(105,'漫步',1004);
INSERT INTO STUDENT VALUES(106,'敢吻',1004);
INSERT INTO STUDENT VALUES(107,'南戈',1002);
INSERT INTO STUDENT VALUES(108,'岁吢',1003);
INSERT INTO STUDENT VALUES(109,'冗词',1003);
INSERT INTO STUDENT VALUES(110,'妄腻',1004);
INSERT INTO STUDENT VALUES(111,'诤友',1002);
INSERT INTO STUDENT VALUES(112,'半兮',1002);
INSERT INTO STUDENT VALUES(113,'笙歌',1003);
INSERT INTO STUDENT VALUES(114,'痞性.',1004);
INSERT INTO STUDENT VALUES(115,'剩余',1004);
INSERT INTO STUDENT VALUES(116,'青怏',1002);
INSERT INTO STUDENT VALUES(117,'洒脱',1001);
INSERT INTO STUDENT VALUES(118,'现实',1003);
INSERT INTO STUDENT VALUES(119,'搁浅°',1001);
INSERT INTO STUDENT VALUES(120,'软萌',1001);
INSERT INTO STUDENT VALUES(121,'路途',1002);
INSERT INTO STUDENT VALUES(122,'娼妓',1001);
INSERT INTO STUDENT VALUES(123,'离骚',1001);
INSERT INTO STUDENT VALUES(124,'逐你',1002);
INSERT INTO STUDENT VALUES(125,'浊酒',1003);
INSERT INTO STUDENT VALUES(126,'热欲',1004);
INSERT INTO STUDENT VALUES(127,'独照',1002);
INSERT INTO STUDENT VALUES(128,'幼栀',1002);
INSERT INTO STUDENT VALUES(129,'花岁',1002);
INSERT INTO STUDENT VALUES(130,'千城',1004);
INSERT INTO STUDENT VALUES(131,'墨沫',1002);
INSERT INTO STUDENT VALUES(132,'烂人',1004);
INSERT INTO STUDENT VALUES(133,'展眉',1004);
INSERT INTO STUDENT VALUES(134,'匆匆',1002);
INSERT INTO STUDENT VALUES(135,'旧梦',1003);
INSERT INTO STUDENT VALUES(136,'倘若',1004);
INSERT INTO STUDENT VALUES(137,'懒猪',1002);
INSERT INTO STUDENT VALUES(138,'落殇',1004);
INSERT INTO STUDENT VALUES(139,'敷衍',1001);
INSERT INTO STUDENT VALUES(140,'寒笑',1002);
INSERT INTO STUDENT VALUES(141,'嫑忈',1001);
INSERT INTO STUDENT VALUES(142,'悍纸',1002);
INSERT INTO STUDENT VALUES(143,'瓷柚',1003);
INSERT INTO STUDENT VALUES(144,'倘若',1003);
INSERT INTO STUDENT VALUES(145,'难得',1004);
INSERT INTO STUDENT VALUES(146,'解脱',1004);
INSERT INTO STUDENT VALUES(147,'沙砾',1003);
INSERT INTO STUDENT VALUES(148,'奢侈',1001);
INSERT INTO STUDENT VALUES(149,'冰枷',1002);
INSERT INTO STUDENT VALUES(150,'糜拥',1003);
INSERT INTO STUDENT VALUES(151,'浮梦',1004);
INSERT INTO STUDENT VALUES(152,'过客',1001);
INSERT INTO STUDENT VALUES(153,'初灬嘎',1003);
INSERT INTO STUDENT VALUES(154,'西决丶丶',1002);
INSERT INTO STUDENT VALUES(155,'惬意',1003);
INSERT INTO STUDENT VALUES(156,'习惯',1004);
INSERT INTO STUDENT VALUES(157,'模糊',1001);
INSERT INTO STUDENT VALUES(158,'憧"未',1001);
INSERT INTO STUDENT VALUES(159,'傲骨。',1002);
INSERT INTO STUDENT VALUES(160,'吥ぃ乖',1001);
INSERT INTO STUDENT VALUES(161,'丶忧伤丿',1001);
INSERT INTO STUDENT VALUES(162,'丿丶宿觞',1001);
INSERT INTO STUDENT VALUES(163,'即使',1001);
INSERT INTO STUDENT VALUES(164,'縌丿噯',1004);
INSERT INTO STUDENT VALUES(165,'-╮求佛ミ',1003);
INSERT INTO STUDENT VALUES(166,'丶落墨',1001);
INSERT INTO STUDENT VALUES(167,'春の恋',1001);
INSERT INTO STUDENT VALUES(168,'冰丶翼',1002);
INSERT INTO STUDENT VALUES(169,'悠闲',1004);
INSERT INTO STUDENT VALUES(170,'静谧',1003);
INSERT INTO STUDENT VALUES(171,'薄姬',1001);
INSERT INTO STUDENT VALUES(172,'崇言ぢ',1003);
INSERT INTO STUDENT VALUES(173,'ゞ寶貝`',1004);
INSERT INTO STUDENT VALUES(174,'疼惜ゞ',1003);
INSERT INTO STUDENT VALUES(175,'┾…·錵心’',1002);
INSERT INTO STUDENT VALUES(176,'H_忘情',1001);
INSERT INTO STUDENT VALUES(177,'蔷薇',1004);
INSERT INTO STUDENT VALUES(178,'唯美',1002);
INSERT INTO STUDENT VALUES(179,'朶儿、',1002);
INSERT INTO STUDENT VALUES(180,'じ☆veヤ情心',1001);
INSERT INTO STUDENT VALUES(181,'↗缘份',1003);
INSERT INTO STUDENT VALUES(182,'╰゛逝┆心..',1004);
INSERT INTO STUDENT VALUES(183,'-萝卜-',1002);
INSERT INTO STUDENT VALUES(184,'允芯',1004);
INSERT INTO STUDENT VALUES(185,'晨光°',1002);
INSERT INTO STUDENT VALUES(186,'不二。',1004);
INSERT INTO STUDENT VALUES(187,'丶猫腻',1002);
INSERT INTO STUDENT VALUES(188,'逃离 ',1004);
INSERT INTO STUDENT VALUES(189,'薄姬',1001);
INSERT INTO STUDENT VALUES(190,'茗灬人',1002);
INSERT INTO STUDENT VALUES(191,'薄幸つ。',1003);
INSERT INTO STUDENT VALUES(192,'﹏゛默笙。',1002);
INSERT INTO STUDENT VALUES(193,'囍战',1001);
INSERT INTO STUDENT VALUES(194,'ζ  菇凉',1002);
INSERT INTO STUDENT VALUES(195,'旧梦',1002);
INSERT INTO STUDENT VALUES(196,'旧梦',1002);
INSERT INTO STUDENT VALUES(197,'冗词',1002);
INSERT INTO STUDENT VALUES(198,'久伴',1002);
INSERT INTO STUDENT VALUES(199,'一人浅醉',1002);
INSERT INTO STUDENT VALUES(200,'甜甜圈ii',1002);
CREATE TABLE SUBJECT
(
ID INT(4) COMMENT '编号',
NAME VARCHAR(10) COMMENT '名称'
) COMMENT='学科表';
INSERT INTO SUBJECT VALUES(1,'语文');
INSERT INTO SUBJECT VALUES(2,'数学');
INSERT INTO SUBJECT VALUES(3,'英语');
INSERT INTO SUBJECT VALUES(4,'物理');
INSERT INTO SUBJECT VALUES(5,'化学');
CREATE TABLE SCORE
(
STUDENTID INT(4) COMMENT '学生编号',
SUBJECTID INT(4) COMMENT '学科编号',
SCORE INT(4) COMMENT '成绩'
) COMMENT='成绩表';
INSERT INTO SCORE VALUES(1,'1',46);
INSERT INTO SCORE VALUES(1,'2',49);
INSERT INTO SCORE VALUES(1,'3',64);
INSERT INTO SCORE VALUES(1,'4',81);
INSERT INTO SCORE VALUES(1,'5',96);
INSERT INTO SCORE VALUES(2,'1',28);
INSERT INTO SCORE VALUES(2,'2',30);
INSERT INTO SCORE VALUES(2,'3',63);
INSERT INTO SCORE VALUES(2,'4',4);
INSERT INTO SCORE VALUES(2,'5',10);
INSERT INTO SCORE VALUES(3,'1',25);
INSERT INTO SCORE VALUES(3,'2',15);
INSERT INTO SCORE VALUES(3,'3',80);
INSERT INTO SCORE VALUES(3,'4',14);
INSERT INTO SCORE VALUES(3,'5',85);
INSERT INTO SCORE VALUES(4,'1',90);
INSERT INTO SCORE VALUES(4,'2',19);
INSERT INTO SCORE VALUES(4,'3',44);
INSERT INTO SCORE VALUES(4,'4',32);
INSERT INTO SCORE VALUES(4,'5',50);
INSERT INTO SCORE VALUES(5,'1',83);
INSERT INTO SCORE VALUES(5,'2',48);
INSERT INTO SCORE VALUES(5,'3',56);
INSERT INTO SCORE VALUES(5,'4',82);
INSERT INTO SCORE VALUES(5,'5',61);
INSERT INTO SCORE VALUES(6,'1',78);
INSERT INTO SCORE VALUES(6,'2',13);
INSERT INTO SCORE VALUES(6,'3',92);
INSERT INTO SCORE VALUES(6,'4',12);
INSERT INTO SCORE VALUES(6,'5',39);
INSERT INTO SCORE VALUES(7,'1',47);
INSERT INTO SCORE VALUES(7,'2',29);
INSERT INTO SCORE VALUES(7,'3',94);
INSERT INTO SCORE VALUES(7,'4',38);
INSERT INTO SCORE VALUES(7,'5',53);
INSERT INTO SCORE VALUES(8,'1',51);
INSERT INTO SCORE VALUES(8,'2',20);
INSERT INTO SCORE VALUES(8,'3',74);
INSERT INTO SCORE VALUES(8,'4',8);
INSERT INTO SCORE VALUES(8,'5',18);
INSERT INTO SCORE VALUES(9,'1',16);
INSERT INTO SCORE VALUES(9,'2',49);
INSERT INTO SCORE VALUES(9,'3',21);
INSERT INTO SCORE VALUES(9,'4',16);
INSERT INTO SCORE VALUES(9,'5',54);
INSERT INTO SCORE VALUES(10,'1',86);
INSERT INTO SCORE VALUES(10,'2',3);
INSERT INTO SCORE VALUES(10,'3',3);
INSERT INTO SCORE VALUES(10,'4',52);
INSERT INTO SCORE VALUES(10,'5',52);
INSERT INTO SCORE VALUES(11,'1',56);
INSERT INTO SCORE VALUES(11,'2',29);
INSERT INTO SCORE VALUES(11,'3',23);
INSERT INTO SCORE VALUES(11,'4',78);
INSERT INTO SCORE VALUES(11,'5',50);
INSERT INTO SCORE VALUES(12,'1',96);
INSERT INTO SCORE VALUES(12,'2',40);
INSERT INTO SCORE VALUES(12,'3',80);
INSERT INTO SCORE VALUES(12,'4',45);
INSERT INTO SCORE VALUES(12,'5',84);
INSERT INTO SCORE VALUES(13,'1',28);
INSERT INTO SCORE VALUES(13,'2',8);
INSERT INTO SCORE VALUES(13,'3',20);
INSERT INTO SCORE VALUES(13,'4',80);
INSERT INTO SCORE VALUES(13,'5',69);
INSERT INTO SCORE VALUES(14,'1',11);
INSERT INTO SCORE VALUES(14,'2',77);
INSERT INTO SCORE VALUES(14,'3',65);
INSERT INTO SCORE VALUES(14,'4',85);
INSERT INTO SCORE VALUES(14,'5',19);
INSERT INTO SCORE VALUES(15,'1',71);
INSERT INTO SCORE VALUES(15,'2',87);
INSERT INTO SCORE VALUES(15,'3',12);
INSERT INTO SCORE VALUES(15,'4',48);
INSERT INTO SCORE VALUES(15,'5',91);
INSERT INTO SCORE VALUES(16,'1',23);
INSERT INTO SCORE VALUES(16,'2',42);
INSERT INTO SCORE VALUES(16,'3',7);
INSERT INTO SCORE VALUES(16,'4',23);
INSERT INTO SCORE VALUES(16,'5',14);
INSERT INTO SCORE VALUES(17,'1',86);
INSERT INTO SCORE VALUES(17,'2',95);
INSERT INTO SCORE VALUES(17,'3',7);
INSERT INTO SCORE VALUES(17,'4',83);
INSERT INTO SCORE VALUES(17,'5',99);
INSERT INTO SCORE VALUES(18,'1',11);
INSERT INTO SCORE VALUES(18,'2',14);
INSERT INTO SCORE VALUES(18,'3',96);
INSERT INTO SCORE VALUES(18,'4',90);
INSERT INTO SCORE VALUES(18,'5',5);
INSERT INTO SCORE VALUES(19,'1',70);
INSERT INTO SCORE VALUES(19,'2',7);
INSERT INTO SCORE VALUES(19,'3',97);
INSERT INTO SCORE VALUES(19,'4',93);
INSERT INTO SCORE VALUES(19,'5',99);
INSERT INTO SCORE VALUES(20,'1',72);
INSERT INTO SCORE VALUES(20,'2',35);
INSERT INTO SCORE VALUES(20,'3',51);
INSERT INTO SCORE VALUES(20,'4',14);
INSERT INTO SCORE VALUES(20,'5',76);
INSERT INTO SCORE VALUES(21,'1',17);
INSERT INTO SCORE VALUES(21,'2',76);
INSERT INTO SCORE VALUES(21,'3',25);
INSERT INTO SCORE VALUES(21,'4',68);
INSERT INTO SCORE VALUES(21,'5',49);
INSERT INTO SCORE VALUES(22,'1',8);
INSERT INTO SCORE VALUES(22,'2',40);
INSERT INTO SCORE VALUES(22,'3',84);
INSERT INTO SCORE VALUES(22,'4',25);
INSERT INTO SCORE VALUES(22,'5',72);
INSERT INTO SCORE VALUES(23,'1',31);
INSERT INTO SCORE VALUES(23,'2',95);
INSERT INTO SCORE VALUES(23,'3',82);
INSERT INTO SCORE VALUES(23,'4',78);
INSERT INTO SCORE VALUES(23,'5',43);
INSERT INTO SCORE VALUES(24,'1',59);
INSERT INTO SCORE VALUES(24,'2',99);
INSERT INTO SCORE VALUES(24,'3',21);
INSERT INTO SCORE VALUES(24,'4',64);
INSERT INTO SCORE VALUES(24,'5',79);
INSERT INTO SCORE VALUES(25,'1',30);
INSERT INTO SCORE VALUES(25,'2',65);
INSERT INTO SCORE VALUES(25,'3',83);
INSERT INTO SCORE VALUES(25,'4',30);
INSERT INTO SCORE VALUES(25,'5',59);
INSERT INTO SCORE VALUES(26,'1',76);
INSERT INTO SCORE VALUES(26,'2',22);
INSERT INTO SCORE VALUES(26,'3',84);
INSERT INTO SCORE VALUES(26,'4',33);
INSERT INTO SCORE VALUES(26,'5',59);
INSERT INTO SCORE VALUES(27,'1',61);
INSERT INTO SCORE VALUES(27,'2',63);
INSERT INTO SCORE VALUES(27,'3',58);
INSERT INTO SCORE VALUES(27,'4',24);
INSERT INTO SCORE VALUES(27,'5',56);
INSERT INTO SCORE VALUES(28,'1',50);
INSERT INTO SCORE VALUES(28,'2',54);
INSERT INTO SCORE VALUES(28,'3',96);
INSERT INTO SCORE VALUES(28,'4',63);
INSERT INTO SCORE VALUES(28,'5',6);
INSERT INTO SCORE VALUES(29,'1',75);
INSERT INTO SCORE VALUES(29,'2',98);
INSERT INTO SCORE VALUES(29,'3',81);
INSERT INTO SCORE VALUES(29,'4',26);
INSERT INTO SCORE VALUES(29,'5',63);
INSERT INTO SCORE VALUES(30,'1',58);
INSERT INTO SCORE VALUES(30,'2',6);
INSERT INTO SCORE VALUES(30,'3',2);
INSERT INTO SCORE VALUES(30,'4',27);
INSERT INTO SCORE VALUES(30,'5',33);
INSERT INTO SCORE VALUES(31,'1',32);
INSERT INTO SCORE VALUES(31,'2',90);
INSERT INTO SCORE VALUES(31,'3',57);
INSERT INTO SCORE VALUES(31,'4',62);
INSERT INTO SCORE VALUES(31,'5',45);
INSERT INTO SCORE VALUES(32,'1',56);
INSERT INTO SCORE VALUES(32,'2',58);
INSERT INTO SCORE VALUES(32,'3',38);
INSERT INTO SCORE VALUES(32,'4',36);
INSERT INTO SCORE VALUES(32,'5',71);
INSERT INTO SCORE VALUES(33,'1',47);
INSERT INTO SCORE VALUES(33,'2',73);
INSERT INTO SCORE VALUES(33,'3',45);
INSERT INTO SCORE VALUES(33,'4',3);
INSERT INTO SCORE VALUES(33,'5',45);
INSERT INTO SCORE VALUES(34,'1',65);
INSERT INTO SCORE VALUES(34,'2',51);
INSERT INTO SCORE VALUES(34,'3',10);
INSERT INTO SCORE VALUES(34,'4',75);
INSERT INTO SCORE VALUES(34,'5',64);
INSERT INTO SCORE VALUES(35,'1',57);
INSERT INTO SCORE VALUES(35,'2',29);
INSERT INTO SCORE VALUES(35,'3',0);
INSERT INTO SCORE VALUES(35,'4',41);
INSERT INTO SCORE VALUES(35,'5',64);
INSERT INTO SCORE VALUES(36,'1',80);
INSERT INTO SCORE VALUES(36,'2',50);
INSERT INTO SCORE VALUES(36,'3',96);
INSERT INTO SCORE VALUES(36,'4',61);
INSERT INTO SCORE VALUES(36,'5',28);
INSERT INTO SCORE VALUES(37,'1',71);
INSERT INTO SCORE VALUES(37,'2',7);
INSERT INTO SCORE VALUES(37,'3',18);
INSERT INTO SCORE VALUES(37,'4',99);
INSERT INTO SCORE VALUES(37,'5',78);
INSERT INTO SCORE VALUES(38,'1',18);
INSERT INTO SCORE VALUES(38,'2',32);
INSERT INTO SCORE VALUES(38,'3',74);
INSERT INTO SCORE VALUES(38,'4',38);
INSERT INTO SCORE VALUES(38,'5',7);
INSERT INTO SCORE VALUES(39,'1',61);
INSERT INTO SCORE VALUES(39,'2',83);
INSERT INTO SCORE VALUES(39,'3',7);
INSERT INTO SCORE VALUES(39,'4',15);
INSERT INTO SCORE VALUES(39,'5',47);
INSERT INTO SCORE VALUES(40,'1',99);
INSERT INTO SCORE VALUES(40,'2',58);
INSERT INTO SCORE VALUES(40,'3',85);
INSERT INTO SCORE VALUES(40,'4',6);
INSERT INTO SCORE VALUES(40,'5',82);
INSERT INTO SCORE VALUES(41,'1',45);
INSERT INTO SCORE VALUES(41,'2',33);
INSERT INTO SCORE VALUES(41,'3',49);
INSERT INTO SCORE VALUES(41,'4',70);
INSERT INTO SCORE VALUES(41,'5',35);
INSERT INTO SCORE VALUES(42,'1',21);
INSERT INTO SCORE VALUES(42,'2',40);
INSERT INTO SCORE VALUES(42,'3',99);
INSERT INTO SCORE VALUES(42,'4',66);
INSERT INTO SCORE VALUES(42,'5',47);
INSERT INTO SCORE VALUES(43,'1',79);
INSERT INTO SCORE VALUES(43,'2',16);
INSERT INTO SCORE VALUES(43,'3',82);
INSERT INTO SCORE VALUES(43,'4',59);
INSERT INTO SCORE VALUES(43,'5',59);
INSERT INTO SCORE VALUES(44,'1',55);
INSERT INTO SCORE VALUES(44,'2',25);
INSERT INTO SCORE VALUES(44,'3',84);
INSERT INTO SCORE VALUES(44,'4',84);
INSERT INTO SCORE VALUES(44,'5',43);
INSERT INTO SCORE VALUES(45,'1',38);
INSERT INTO SCORE VALUES(45,'2',31);
INSERT INTO SCORE VALUES(45,'3',33);
INSERT INTO SCORE VALUES(45,'4',23);
INSERT INTO SCORE VALUES(45,'5',52);
INSERT INTO SCORE VALUES(46,'1',25);
INSERT INTO SCORE VALUES(46,'2',35);
INSERT INTO SCORE VALUES(46,'3',0);
INSERT INTO SCORE VALUES(46,'4',5);
INSERT INTO SCORE VALUES(46,'5',29);
INSERT INTO SCORE VALUES(47,'1',33);
INSERT INTO SCORE VALUES(47,'2',79);
INSERT INTO SCORE VALUES(47,'3',23);
INSERT INTO SCORE VALUES(47,'4',97);
INSERT INTO SCORE VALUES(47,'5',5);
INSERT INTO SCORE VALUES(48,'1',1);
INSERT INTO SCORE VALUES(48,'2',26);
INSERT INTO SCORE VALUES(48,'3',34);
INSERT INTO SCORE VALUES(48,'4',74);
INSERT INTO SCORE VALUES(48,'5',20);
INSERT INTO SCORE VALUES(49,'1',23);
INSERT INTO SCORE VALUES(49,'2',48);
INSERT INTO SCORE VALUES(49,'3',33);
INSERT INTO SCORE VALUES(49,'4',19);
INSERT INTO SCORE VALUES(49,'5',86);
INSERT INTO SCORE VALUES(50,'1',36);
INSERT INTO SCORE VALUES(50,'2',61);
INSERT INTO SCORE VALUES(50,'3',39);
INSERT INTO SCORE VALUES(50,'4',63);
INSERT INTO SCORE VALUES(50,'5',33);
INSERT INTO SCORE VALUES(51,'1',96);
INSERT INTO SCORE VALUES(51,'2',40);
INSERT INTO SCORE VALUES(51,'3',12);
INSERT INTO SCORE VALUES(51,'4',49);
INSERT INTO SCORE VALUES(51,'5',24);
INSERT INTO SCORE VALUES(52,'1',67);
INSERT INTO SCORE VALUES(52,'2',7);
INSERT INTO SCORE VALUES(52,'3',61);
INSERT INTO SCORE VALUES(52,'4',29);
INSERT INTO SCORE VALUES(52,'5',45);
INSERT INTO SCORE VALUES(53,'1',94);
INSERT INTO SCORE VALUES(53,'2',1);
INSERT INTO SCORE VALUES(53,'3',72);
INSERT INTO SCORE VALUES(53,'4',74);
INSERT INTO SCORE VALUES(53,'5',49);
INSERT INTO SCORE VALUES(54,'1',46);
INSERT INTO SCORE VALUES(54,'2',7);
INSERT INTO SCORE VALUES(54,'3',17);
INSERT INTO SCORE VALUES(54,'4',43);
INSERT INTO SCORE VALUES(54,'5',7);
INSERT INTO SCORE VALUES(55,'1',8);
INSERT INTO SCORE VALUES(55,'2',27);
INSERT INTO SCORE VALUES(55,'3',34);
INSERT INTO SCORE VALUES(55,'4',54);
INSERT INTO SCORE VALUES(55,'5',31);
INSERT INTO SCORE VALUES(56,'1',52);
INSERT INTO SCORE VALUES(56,'2',1);
INSERT INTO SCORE VALUES(56,'3',91);
INSERT INTO SCORE VALUES(56,'4',70);
INSERT INTO SCORE VALUES(56,'5',57);
INSERT INTO SCORE VALUES(57,'1',20);
INSERT INTO SCORE VALUES(57,'2',19);
INSERT INTO SCORE VALUES(57,'3',28);
INSERT INTO SCORE VALUES(57,'4',48);
INSERT INTO SCORE VALUES(57,'5',3);
INSERT INTO SCORE VALUES(58,'1',39);
INSERT INTO SCORE VALUES(58,'2',23);
INSERT INTO SCORE VALUES(58,'3',75);
INSERT INTO SCORE VALUES(58,'4',78);
INSERT INTO SCORE VALUES(58,'5',25);
INSERT INTO SCORE VALUES(59,'1',80);
INSERT INTO SCORE VALUES(59,'2',3);
INSERT INTO SCORE VALUES(59,'3',25);
INSERT INTO SCORE VALUES(59,'4',56);
INSERT INTO SCORE VALUES(59,'5',67);
INSERT INTO SCORE VALUES(60,'1',33);
INSERT INTO SCORE VALUES(60,'2',40);
INSERT INTO SCORE VALUES(60,'3',96);
INSERT INTO SCORE VALUES(60,'4',7);
INSERT INTO SCORE VALUES(60,'5',46);
INSERT INTO SCORE VALUES(61,'1',36);
INSERT INTO SCORE VALUES(61,'2',53);
INSERT INTO SCORE VALUES(61,'3',72);
INSERT INTO SCORE VALUES(61,'4',49);
INSERT INTO SCORE VALUES(61,'5',10);
INSERT INTO SCORE VALUES(62,'1',77);
INSERT INTO SCORE VALUES(62,'2',93);
INSERT INTO SCORE VALUES(62,'3',67);
INSERT INTO SCORE VALUES(62,'4',44);
INSERT INTO SCORE VALUES(62,'5',60);
INSERT INTO SCORE VALUES(63,'1',97);
INSERT INTO SCORE VALUES(63,'2',7);
INSERT INTO SCORE VALUES(63,'3',70);
INSERT INTO SCORE VALUES(63,'4',32);
INSERT INTO SCORE VALUES(63,'5',70);
INSERT INTO SCORE VALUES(64,'1',84);
INSERT INTO SCORE VALUES(64,'2',70);
INSERT INTO SCORE VALUES(64,'3',83);
INSERT INTO SCORE VALUES(64,'4',33);
INSERT INTO SCORE VALUES(64,'5',71);
INSERT INTO SCORE VALUES(65,'1',13);
INSERT INTO SCORE VALUES(65,'2',72);
INSERT INTO SCORE VALUES(65,'3',64);
INSERT INTO SCORE VALUES(65,'4',13);
INSERT INTO SCORE VALUES(65,'5',82);
INSERT INTO SCORE VALUES(66,'1',27);
INSERT INTO SCORE VALUES(66,'2',3);
INSERT INTO SCORE VALUES(66,'3',58);
INSERT INTO SCORE VALUES(66,'4',84);
INSERT INTO SCORE VALUES(66,'5',93);
INSERT INTO SCORE VALUES(67,'1',71);
INSERT INTO SCORE VALUES(67,'2',86);
INSERT INTO SCORE VALUES(67,'3',75);
INSERT INTO SCORE VALUES(67,'4',64);
INSERT INTO SCORE VALUES(67,'5',84);
INSERT INTO SCORE VALUES(68,'1',0);
INSERT INTO SCORE VALUES(68,'2',84);
INSERT INTO SCORE VALUES(68,'3',9);
INSERT INTO SCORE VALUES(68,'4',74);
INSERT INTO SCORE VALUES(68,'5',93);
INSERT INTO SCORE VALUES(69,'1',24);
INSERT INTO SCORE VALUES(69,'2',87);
INSERT INTO SCORE VALUES(69,'3',23);
INSERT INTO SCORE VALUES(69,'4',39);
INSERT INTO SCORE VALUES(69,'5',91);
INSERT INTO SCORE VALUES(70,'1',23);
INSERT INTO SCORE VALUES(70,'2',88);
INSERT INTO SCORE VALUES(70,'3',8);
INSERT INTO SCORE VALUES(70,'4',30);
INSERT INTO SCORE VALUES(70,'5',85);
INSERT INTO SCORE VALUES(71,'1',89);
INSERT INTO SCORE VALUES(71,'2',6);
INSERT INTO SCORE VALUES(71,'3',79);
INSERT INTO SCORE VALUES(71,'4',3);
INSERT INTO SCORE VALUES(71,'5',99);
INSERT INTO SCORE VALUES(72,'1',88);
INSERT INTO SCORE VALUES(72,'2',84);
INSERT INTO SCORE VALUES(72,'3',95);
INSERT INTO SCORE VALUES(72,'4',43);
INSERT INTO SCORE VALUES(72,'5',7);
INSERT INTO SCORE VALUES(73,'1',76);
INSERT INTO SCORE VALUES(73,'2',79);
INSERT INTO SCORE VALUES(73,'3',5);
INSERT INTO SCORE VALUES(73,'4',86);
INSERT INTO SCORE VALUES(73,'5',93);
INSERT INTO SCORE VALUES(74,'1',52);
INSERT INTO SCORE VALUES(74,'2',98);
INSERT INTO SCORE VALUES(74,'3',98);
INSERT INTO SCORE VALUES(74,'4',59);
INSERT INTO SCORE VALUES(74,'5',6);
INSERT INTO SCORE VALUES(75,'1',66);
INSERT INTO SCORE VALUES(75,'2',42);
INSERT INTO SCORE VALUES(75,'3',43);
INSERT INTO SCORE VALUES(75,'4',99);
INSERT INTO SCORE VALUES(75,'5',22);
INSERT INTO SCORE VALUES(76,'1',15);
INSERT INTO SCORE VALUES(76,'2',55);
INSERT INTO SCORE VALUES(76,'3',45);
INSERT INTO SCORE VALUES(76,'4',47);
INSERT INTO SCORE VALUES(76,'5',82);
INSERT INTO SCORE VALUES(77,'1',63);
INSERT INTO SCORE VALUES(77,'2',55);
INSERT INTO SCORE VALUES(77,'3',73);
INSERT INTO SCORE VALUES(77,'4',38);
INSERT INTO SCORE VALUES(77,'5',60);
INSERT INTO SCORE VALUES(78,'1',48);
INSERT INTO SCORE VALUES(78,'2',15);
INSERT INTO SCORE VALUES(78,'3',68);
INSERT INTO SCORE VALUES(78,'4',1);
INSERT INTO SCORE VALUES(78,'5',33);
INSERT INTO SCORE VALUES(79,'1',83);
INSERT INTO SCORE VALUES(79,'2',38);
INSERT INTO SCORE VALUES(79,'3',76);
INSERT INTO SCORE VALUES(79,'4',69);
INSERT INTO SCORE VALUES(79,'5',9);
INSERT INTO SCORE VALUES(80,'1',1);
INSERT INTO SCORE VALUES(80,'2',43);
INSERT INTO SCORE VALUES(80,'3',72);
INSERT INTO SCORE VALUES(80,'4',29);
INSERT INTO SCORE VALUES(80,'5',29);
INSERT INTO SCORE VALUES(81,'1',43);
INSERT INTO SCORE VALUES(81,'2',1);
INSERT INTO SCORE VALUES(81,'3',87);
INSERT INTO SCORE VALUES(81,'4',69);
INSERT INTO SCORE VALUES(81,'5',42);
INSERT INTO SCORE VALUES(82,'1',30);
INSERT INTO SCORE VALUES(82,'2',67);
INSERT INTO SCORE VALUES(82,'3',73);
INSERT INTO SCORE VALUES(82,'4',9);
INSERT INTO SCORE VALUES(82,'5',45);
INSERT INTO SCORE VALUES(83,'1',86);
INSERT INTO SCORE VALUES(83,'2',29);
INSERT INTO SCORE VALUES(83,'3',22);
INSERT INTO SCORE VALUES(83,'4',31);
INSERT INTO SCORE VALUES(83,'5',37);
INSERT INTO SCORE VALUES(84,'1',98);
INSERT INTO SCORE VALUES(84,'2',20);
INSERT INTO SCORE VALUES(84,'3',73);
INSERT INTO SCORE VALUES(84,'4',72);
INSERT INTO SCORE VALUES(84,'5',28);
INSERT INTO SCORE VALUES(85,'1',59);
INSERT INTO SCORE VALUES(85,'2',68);
INSERT INTO SCORE VALUES(85,'3',7);
INSERT INTO SCORE VALUES(85,'4',38);
INSERT INTO SCORE VALUES(85,'5',28);
INSERT INTO SCORE VALUES(86,'1',60);
INSERT INTO SCORE VALUES(86,'2',68);
INSERT INTO SCORE VALUES(86,'3',96);
INSERT INTO SCORE VALUES(86,'4',71);
INSERT INTO SCORE VALUES(86,'5',17);
INSERT INTO SCORE VALUES(87,'1',82);
INSERT INTO SCORE VALUES(87,'2',63);
INSERT INTO SCORE VALUES(87,'3',9);
INSERT INTO SCORE VALUES(87,'4',93);
INSERT INTO SCORE VALUES(87,'5',23);
INSERT INTO SCORE VALUES(88,'1',39);
INSERT INTO SCORE VALUES(88,'2',29);
INSERT INTO SCORE VALUES(88,'3',2);
INSERT INTO SCORE VALUES(88,'4',83);
INSERT INTO SCORE VALUES(88,'5',79);
INSERT INTO SCORE VALUES(89,'1',45);
INSERT INTO SCORE VALUES(89,'2',19);
INSERT INTO SCORE VALUES(89,'3',26);
INSERT INTO SCORE VALUES(89,'4',99);
INSERT INTO SCORE VALUES(89,'5',37);
INSERT INTO SCORE VALUES(90,'1',78);
INSERT INTO SCORE VALUES(90,'2',3);
INSERT INTO SCORE VALUES(90,'3',22);
INSERT INTO SCORE VALUES(90,'4',76);
INSERT INTO SCORE VALUES(90,'5',86);
INSERT INTO SCORE VALUES(91,'1',20);
INSERT INTO SCORE VALUES(91,'2',52);
INSERT INTO SCORE VALUES(91,'3',20);
INSERT INTO SCORE VALUES(91,'4',35);
INSERT INTO SCORE VALUES(91,'5',63);
INSERT INTO SCORE VALUES(92,'1',42);
INSERT INTO SCORE VALUES(92,'2',9);
INSERT INTO SCORE VALUES(92,'3',34);
INSERT INTO SCORE VALUES(92,'4',78);
INSERT INTO SCORE VALUES(92,'5',86);
INSERT INTO SCORE VALUES(93,'1',50);
INSERT INTO SCORE VALUES(93,'2',19);
INSERT INTO SCORE VALUES(93,'3',55);
INSERT INTO SCORE VALUES(93,'4',30);
INSERT INTO SCORE VALUES(93,'5',84);
INSERT INTO SCORE VALUES(94,'1',3);
INSERT INTO SCORE VALUES(94,'2',50);
INSERT INTO SCORE VALUES(94,'3',52);
INSERT INTO SCORE VALUES(94,'4',7);
INSERT INTO SCORE VALUES(94,'5',96);
INSERT INTO SCORE VALUES(95,'1',93);
INSERT INTO SCORE VALUES(95,'2',12);
INSERT INTO SCORE VALUES(95,'3',48);
INSERT INTO SCORE VALUES(95,'4',51);
INSERT INTO SCORE VALUES(95,'5',55);
INSERT INTO SCORE VALUES(96,'1',57);
INSERT INTO SCORE VALUES(96,'2',20);
INSERT INTO SCORE VALUES(96,'3',28);
INSERT INTO SCORE VALUES(96,'4',16);
INSERT INTO SCORE VALUES(96,'5',82);
INSERT INTO SCORE VALUES(97,'1',44);
INSERT INTO SCORE VALUES(97,'2',61);
INSERT INTO SCORE VALUES(97,'3',33);
INSERT INTO SCORE VALUES(97,'4',85);
INSERT INTO SCORE VALUES(97,'5',62);
INSERT INTO SCORE VALUES(98,'1',61);
INSERT INTO SCORE VALUES(98,'2',83);
INSERT INTO SCORE VALUES(98,'3',40);
INSERT INTO SCORE VALUES(98,'4',55);
INSERT INTO SCORE VALUES(98,'5',93);
INSERT INTO SCORE VALUES(99,'1',51);
INSERT INTO SCORE VALUES(99,'2',0);
INSERT INTO SCORE VALUES(99,'3',84);
INSERT INTO SCORE VALUES(99,'4',34);
INSERT INTO SCORE VALUES(99,'5',5);
INSERT INTO SCORE VALUES(100,'1',16);
INSERT INTO SCORE VALUES(100,'2',65);
INSERT INTO SCORE VALUES(100,'3',42);
INSERT INTO SCORE VALUES(100,'4',34);
INSERT INTO SCORE VALUES(100,'5',46);
INSERT INTO SCORE VALUES(101,'1',62);
INSERT INTO SCORE VALUES(101,'2',83);
INSERT INTO SCORE VALUES(101,'3',33);
INSERT INTO SCORE VALUES(101,'4',19);
INSERT INTO SCORE VALUES(101,'5',29);
INSERT INTO SCORE VALUES(102,'1',22);
INSERT INTO SCORE VALUES(102,'2',8);
INSERT INTO SCORE VALUES(102,'3',58);
INSERT INTO SCORE VALUES(102,'4',33);
INSERT INTO SCORE VALUES(102,'5',37);
INSERT INTO SCORE VALUES(103,'1',97);
INSERT INTO SCORE VALUES(103,'2',62);
INSERT INTO SCORE VALUES(103,'3',7);
INSERT INTO SCORE VALUES(103,'4',68);
INSERT INTO SCORE VALUES(103,'5',12);
INSERT INTO SCORE VALUES(104,'1',75);
INSERT INTO SCORE VALUES(104,'2',70);
INSERT INTO SCORE VALUES(104,'3',15);
INSERT INTO SCORE VALUES(104,'4',76);
INSERT INTO SCORE VALUES(104,'5',91);
INSERT INTO SCORE VALUES(105,'1',53);
INSERT INTO SCORE VALUES(105,'2',5);
INSERT INTO SCORE VALUES(105,'3',38);
INSERT INTO SCORE VALUES(105,'4',89);
INSERT INTO SCORE VALUES(105,'5',60);
INSERT INTO SCORE VALUES(106,'1',78);
INSERT INTO SCORE VALUES(106,'2',29);
INSERT INTO SCORE VALUES(106,'3',31);
INSERT INTO SCORE VALUES(106,'4',75);
INSERT INTO SCORE VALUES(106,'5',21);
INSERT INTO SCORE VALUES(107,'1',45);
INSERT INTO SCORE VALUES(107,'2',72);
INSERT INTO SCORE VALUES(107,'3',65);
INSERT INTO SCORE VALUES(107,'4',49);
INSERT INTO SCORE VALUES(107,'5',19);
INSERT INTO SCORE VALUES(108,'1',6);
INSERT INTO SCORE VALUES(108,'2',0);
INSERT INTO SCORE VALUES(108,'3',19);
INSERT INTO SCORE VALUES(108,'4',42);
INSERT INTO SCORE VALUES(108,'5',38);
INSERT INTO SCORE VALUES(109,'1',87);
INSERT INTO SCORE VALUES(109,'2',37);
INSERT INTO SCORE VALUES(109,'3',77);
INSERT INTO SCORE VALUES(109,'4',91);
INSERT INTO SCORE VALUES(109,'5',81);
INSERT INTO SCORE VALUES(110,'1',58);
INSERT INTO SCORE VALUES(110,'2',72);
INSERT INTO SCORE VALUES(110,'3',89);
INSERT INTO SCORE VALUES(110,'4',72);
INSERT INTO SCORE VALUES(110,'5',1);
INSERT INTO SCORE VALUES(111,'1',16);
INSERT INTO SCORE VALUES(111,'2',50);
INSERT INTO SCORE VALUES(111,'3',7);
INSERT INTO SCORE VALUES(111,'4',12);
INSERT INTO SCORE VALUES(111,'5',84);
INSERT INTO SCORE VALUES(112,'1',75);
INSERT INTO SCORE VALUES(112,'2',36);
INSERT INTO SCORE VALUES(112,'3',50);
INSERT INTO SCORE VALUES(112,'4',46);
INSERT INTO SCORE VALUES(112,'5',61);
INSERT INTO SCORE VALUES(113,'1',27);
INSERT INTO SCORE VALUES(113,'2',75);
INSERT INTO SCORE VALUES(113,'3',43);
INSERT INTO SCORE VALUES(113,'4',12);
INSERT INTO SCORE VALUES(113,'5',51);
INSERT INTO SCORE VALUES(114,'1',20);
INSERT INTO SCORE VALUES(114,'2',67);
INSERT INTO SCORE VALUES(114,'3',56);
INSERT INTO SCORE VALUES(114,'4',86);
INSERT INTO SCORE VALUES(114,'5',38);
INSERT INTO SCORE VALUES(115,'1',29);
INSERT INTO SCORE VALUES(115,'2',74);
INSERT INTO SCORE VALUES(115,'3',10);
INSERT INTO SCORE VALUES(115,'4',11);
INSERT INTO SCORE VALUES(115,'5',28);
INSERT INTO SCORE VALUES(116,'1',23);
INSERT INTO SCORE VALUES(116,'2',71);
INSERT INTO SCORE VALUES(116,'3',20);
INSERT INTO SCORE VALUES(116,'4',18);
INSERT INTO SCORE VALUES(116,'5',56);
INSERT INTO SCORE VALUES(117,'1',0);
INSERT INTO SCORE VALUES(117,'2',34);
INSERT INTO SCORE VALUES(117,'3',49);
INSERT INTO SCORE VALUES(117,'4',15);
INSERT INTO SCORE VALUES(117,'5',78);
INSERT INTO SCORE VALUES(118,'1',64);
INSERT INTO SCORE VALUES(118,'2',44);
INSERT INTO SCORE VALUES(118,'3',78);
INSERT INTO SCORE VALUES(118,'4',71);
INSERT INTO SCORE VALUES(118,'5',15);
INSERT INTO SCORE VALUES(119,'1',28);
INSERT INTO SCORE VALUES(119,'2',81);
INSERT INTO SCORE VALUES(119,'3',44);
INSERT INTO SCORE VALUES(119,'4',1);
INSERT INTO SCORE VALUES(119,'5',94);
INSERT INTO SCORE VALUES(120,'1',98);
INSERT INTO SCORE VALUES(120,'2',22);
INSERT INTO SCORE VALUES(120,'3',41);
INSERT INTO SCORE VALUES(120,'4',2);
INSERT INTO SCORE VALUES(120,'5',25);
INSERT INTO SCORE VALUES(121,'1',55);
INSERT INTO SCORE VALUES(121,'2',3);
INSERT INTO SCORE VALUES(121,'3',48);
INSERT INTO SCORE VALUES(121,'4',82);
INSERT INTO SCORE VALUES(121,'5',53);
INSERT INTO SCORE VALUES(122,'1',4);
INSERT INTO SCORE VALUES(122,'2',2);
INSERT INTO SCORE VALUES(122,'3',83);
INSERT INTO SCORE VALUES(122,'4',72);
INSERT INTO SCORE VALUES(122,'5',80);
INSERT INTO SCORE VALUES(123,'1',9);
INSERT INTO SCORE VALUES(123,'2',3);
INSERT INTO SCORE VALUES(123,'3',46);
INSERT INTO SCORE VALUES(123,'4',68);
INSERT INTO SCORE VALUES(123,'5',58);
INSERT INTO SCORE VALUES(124,'1',45);
INSERT INTO SCORE VALUES(124,'2',1);
INSERT INTO SCORE VALUES(124,'3',4);
INSERT INTO SCORE VALUES(124,'4',44);
INSERT INTO SCORE VALUES(124,'5',79);
INSERT INTO SCORE VALUES(125,'1',80);
INSERT INTO SCORE VALUES(125,'2',5);
INSERT INTO SCORE VALUES(125,'3',7);
INSERT INTO SCORE VALUES(125,'4',38);
INSERT INTO SCORE VALUES(125,'5',82);
INSERT INTO SCORE VALUES(126,'1',25);
INSERT INTO SCORE VALUES(126,'2',56);
INSERT INTO SCORE VALUES(126,'3',23);
INSERT INTO SCORE VALUES(126,'4',44);
INSERT INTO SCORE VALUES(126,'5',3);
INSERT INTO SCORE VALUES(127,'1',58);
INSERT INTO SCORE VALUES(127,'2',56);
INSERT INTO SCORE VALUES(127,'3',2);
INSERT INTO SCORE VALUES(127,'4',31);
INSERT INTO SCORE VALUES(127,'5',64);
INSERT INTO SCORE VALUES(128,'1',61);
INSERT INTO SCORE VALUES(128,'2',58);
INSERT INTO SCORE VALUES(128,'3',60);
INSERT INTO SCORE VALUES(128,'4',3);
INSERT INTO SCORE VALUES(128,'5',87);
INSERT INTO SCORE VALUES(129,'1',60);
INSERT INTO SCORE VALUES(129,'2',28);
INSERT INTO SCORE VALUES(129,'3',91);
INSERT INTO SCORE VALUES(129,'4',47);
INSERT INTO SCORE VALUES(129,'5',78);
INSERT INTO SCORE VALUES(130,'1',37);
INSERT INTO SCORE VALUES(130,'2',83);
INSERT INTO SCORE VALUES(130,'3',44);
INSERT INTO SCORE VALUES(130,'4',64);
INSERT INTO SCORE VALUES(130,'5',29);
INSERT INTO SCORE VALUES(131,'1',41);
INSERT INTO SCORE VALUES(131,'2',26);
INSERT INTO SCORE VALUES(131,'3',57);
INSERT INTO SCORE VALUES(131,'4',44);
INSERT INTO SCORE VALUES(131,'5',23);
INSERT INTO SCORE VALUES(132,'1',34);
INSERT INTO SCORE VALUES(132,'2',53);
INSERT INTO SCORE VALUES(132,'3',46);
INSERT INTO SCORE VALUES(132,'4',29);
INSERT INTO SCORE VALUES(132,'5',31);
INSERT INTO SCORE VALUES(133,'1',62);
INSERT INTO SCORE VALUES(133,'2',72);
INSERT INTO SCORE VALUES(133,'3',49);
INSERT INTO SCORE VALUES(133,'4',11);
INSERT INTO SCORE VALUES(133,'5',63);
INSERT INTO SCORE VALUES(134,'1',1);
INSERT INTO SCORE VALUES(134,'2',97);
INSERT INTO SCORE VALUES(134,'3',0);
INSERT INTO SCORE VALUES(134,'4',15);
INSERT INTO SCORE VALUES(134,'5',50);
INSERT INTO SCORE VALUES(135,'1',91);
INSERT INTO SCORE VALUES(135,'2',3);
INSERT INTO SCORE VALUES(135,'3',20);
INSERT INTO SCORE VALUES(135,'4',39);
INSERT INTO SCORE VALUES(135,'5',34);
INSERT INTO SCORE VALUES(136,'1',43);
INSERT INTO SCORE VALUES(136,'2',16);
INSERT INTO SCORE VALUES(136,'3',62);
INSERT INTO SCORE VALUES(136,'4',45);
INSERT INTO SCORE VALUES(136,'5',36);
INSERT INTO SCORE VALUES(137,'1',76);
INSERT INTO SCORE VALUES(137,'2',17);
INSERT INTO SCORE VALUES(137,'3',82);
INSERT INTO SCORE VALUES(137,'4',22);
INSERT INTO SCORE VALUES(137,'5',88);
INSERT INTO SCORE VALUES(138,'1',79);
INSERT INTO SCORE VALUES(138,'2',81);
INSERT INTO SCORE VALUES(138,'3',84);
INSERT INTO SCORE VALUES(138,'4',15);
INSERT INTO SCORE VALUES(138,'5',41);
INSERT INTO SCORE VALUES(139,'1',87);
INSERT INTO SCORE VALUES(139,'2',13);
INSERT INTO SCORE VALUES(139,'3',29);
INSERT INTO SCORE VALUES(139,'4',66);
INSERT INTO SCORE VALUES(139,'5',2);
INSERT INTO SCORE VALUES(140,'1',21);
INSERT INTO SCORE VALUES(140,'2',62);
INSERT INTO SCORE VALUES(140,'3',29);
INSERT INTO SCORE VALUES(140,'4',6);
INSERT INTO SCORE VALUES(140,'5',22);
INSERT INTO SCORE VALUES(141,'1',37);
INSERT INTO SCORE VALUES(141,'2',68);
INSERT INTO SCORE VALUES(141,'3',7);
INSERT INTO SCORE VALUES(141,'4',20);
INSERT INTO SCORE VALUES(141,'5',23);
INSERT INTO SCORE VALUES(142,'1',14);
INSERT INTO SCORE VALUES(142,'2',2);
INSERT INTO SCORE VALUES(142,'3',92);
INSERT INTO SCORE VALUES(142,'4',63);
INSERT INTO SCORE VALUES(142,'5',74);
INSERT INTO SCORE VALUES(143,'1',94);
INSERT INTO SCORE VALUES(143,'2',60);
INSERT INTO SCORE VALUES(143,'3',40);
INSERT INTO SCORE VALUES(143,'4',70);
INSERT INTO SCORE VALUES(143,'5',69);
INSERT INTO SCORE VALUES(144,'1',95);
INSERT INTO SCORE VALUES(144,'2',18);
INSERT INTO SCORE VALUES(144,'3',60);
INSERT INTO SCORE VALUES(144,'4',64);
INSERT INTO SCORE VALUES(144,'5',31);
INSERT INTO SCORE VALUES(145,'1',41);
INSERT INTO SCORE VALUES(145,'2',0);
INSERT INTO SCORE VALUES(145,'3',35);
INSERT INTO SCORE VALUES(145,'4',93);
INSERT INTO SCORE VALUES(145,'5',99);
INSERT INTO SCORE VALUES(146,'1',74);
INSERT INTO SCORE VALUES(146,'2',17);
INSERT INTO SCORE VALUES(146,'3',66);
INSERT INTO SCORE VALUES(146,'4',48);
INSERT INTO SCORE VALUES(146,'5',40);
INSERT INTO SCORE VALUES(147,'1',0);
INSERT INTO SCORE VALUES(147,'2',80);
INSERT INTO SCORE VALUES(147,'3',13);
INSERT INTO SCORE VALUES(147,'4',24);
INSERT INTO SCORE VALUES(147,'5',78);
INSERT INTO SCORE VALUES(148,'1',56);
INSERT INTO SCORE VALUES(148,'2',90);
INSERT INTO SCORE VALUES(148,'3',28);
INSERT INTO SCORE VALUES(148,'4',33);
INSERT INTO SCORE VALUES(148,'5',97);
INSERT INTO SCORE VALUES(149,'1',41);
INSERT INTO SCORE VALUES(149,'2',83);
INSERT INTO SCORE VALUES(149,'3',56);
INSERT INTO SCORE VALUES(149,'4',26);
INSERT INTO SCORE VALUES(149,'5',61);
INSERT INTO SCORE VALUES(150,'1',11);
INSERT INTO SCORE VALUES(150,'2',11);
INSERT INTO SCORE VALUES(150,'3',66);
INSERT INTO SCORE VALUES(150,'4',87);
INSERT INTO SCORE VALUES(150,'5',45);
INSERT INTO SCORE VALUES(151,'1',71);
INSERT INTO SCORE VALUES(151,'2',45);
INSERT INTO SCORE VALUES(151,'3',25);
INSERT INTO SCORE VALUES(151,'4',81);
INSERT INTO SCORE VALUES(151,'5',68);
INSERT INTO SCORE VALUES(152,'1',8);
INSERT INTO SCORE VALUES(152,'2',5);
INSERT INTO SCORE VALUES(152,'3',56);
INSERT INTO SCORE VALUES(152,'4',94);
INSERT INTO SCORE VALUES(152,'5',62);
INSERT INTO SCORE VALUES(153,'1',57);
INSERT INTO SCORE VALUES(153,'2',5);
INSERT INTO SCORE VALUES(153,'3',39);
INSERT INTO SCORE VALUES(153,'4',98);
INSERT INTO SCORE VALUES(153,'5',85);
INSERT INTO SCORE VALUES(154,'1',3);
INSERT INTO SCORE VALUES(154,'2',55);
INSERT INTO SCORE VALUES(154,'3',92);
INSERT INTO SCORE VALUES(154,'4',96);
INSERT INTO SCORE VALUES(154,'5',29);
INSERT INTO SCORE VALUES(155,'1',32);
INSERT INTO SCORE VALUES(155,'2',27);
INSERT INTO SCORE VALUES(155,'3',88);
INSERT INTO SCORE VALUES(155,'4',87);
INSERT INTO SCORE VALUES(155,'5',78);
INSERT INTO SCORE VALUES(156,'1',9);
INSERT INTO SCORE VALUES(156,'2',70);
INSERT INTO SCORE VALUES(156,'3',69);
INSERT INTO SCORE VALUES(156,'4',39);
INSERT INTO SCORE VALUES(156,'5',91);
INSERT INTO SCORE VALUES(157,'1',59);
INSERT INTO SCORE VALUES(157,'2',67);
INSERT INTO SCORE VALUES(157,'3',24);
INSERT INTO SCORE VALUES(157,'4',5);
INSERT INTO SCORE VALUES(157,'5',14);
INSERT INTO SCORE VALUES(158,'1',39);
INSERT INTO SCORE VALUES(158,'2',76);
INSERT INTO SCORE VALUES(158,'3',62);
INSERT INTO SCORE VALUES(158,'4',99);
INSERT INTO SCORE VALUES(158,'5',44);
INSERT INTO SCORE VALUES(159,'1',93);
INSERT INTO SCORE VALUES(159,'2',85);
INSERT INTO SCORE VALUES(159,'3',15);
INSERT INTO SCORE VALUES(159,'4',16);
INSERT INTO SCORE VALUES(159,'5',10);
INSERT INTO SCORE VALUES(160,'1',14);
INSERT INTO SCORE VALUES(160,'2',6);
INSERT INTO SCORE VALUES(160,'3',69);
INSERT INTO SCORE VALUES(160,'4',24);
INSERT INTO SCORE VALUES(160,'5',76);
INSERT INTO SCORE VALUES(161,'1',22);
INSERT INTO SCORE VALUES(161,'2',13);
INSERT INTO SCORE VALUES(161,'3',62);
INSERT INTO SCORE VALUES(161,'4',81);
INSERT INTO SCORE VALUES(161,'5',14);
INSERT INTO SCORE VALUES(162,'1',15);
INSERT INTO SCORE VALUES(162,'2',60);
INSERT INTO SCORE VALUES(162,'3',33);
INSERT INTO SCORE VALUES(162,'4',83);
INSERT INTO SCORE VALUES(162,'5',51);
INSERT INTO SCORE VALUES(163,'1',10);
INSERT INTO SCORE VALUES(163,'2',89);
INSERT INTO SCORE VALUES(163,'3',2);
INSERT INTO SCORE VALUES(163,'4',37);
INSERT INTO SCORE VALUES(163,'5',70);
INSERT INTO SCORE VALUES(164,'1',67);
INSERT INTO SCORE VALUES(164,'2',13);
INSERT INTO SCORE VALUES(164,'3',19);
INSERT INTO SCORE VALUES(164,'4',20);
INSERT INTO SCORE VALUES(164,'5',54);
INSERT INTO SCORE VALUES(165,'1',8);
INSERT INTO SCORE VALUES(165,'2',89);
INSERT INTO SCORE VALUES(165,'3',99);
INSERT INTO SCORE VALUES(165,'4',99);
INSERT INTO SCORE VALUES(165,'5',41);
INSERT INTO SCORE VALUES(166,'1',34);
INSERT INTO SCORE VALUES(166,'2',26);
INSERT INTO SCORE VALUES(166,'3',79);
INSERT INTO SCORE VALUES(166,'4',19);
INSERT INTO SCORE VALUES(166,'5',37);
INSERT INTO SCORE VALUES(167,'1',85);
INSERT INTO SCORE VALUES(167,'2',65);
INSERT INTO SCORE VALUES(167,'3',43);
INSERT INTO SCORE VALUES(167,'4',49);
INSERT INTO SCORE VALUES(167,'5',97);
INSERT INTO SCORE VALUES(168,'1',20);
INSERT INTO SCORE VALUES(168,'2',5);
INSERT INTO SCORE VALUES(168,'3',59);
INSERT INTO SCORE VALUES(168,'4',62);
INSERT INTO SCORE VALUES(168,'5',74);
INSERT INTO SCORE VALUES(169,'1',13);
INSERT INTO SCORE VALUES(169,'2',65);
INSERT INTO SCORE VALUES(169,'3',16);
INSERT INTO SCORE VALUES(169,'4',21);
INSERT INTO SCORE VALUES(169,'5',96);
INSERT INTO SCORE VALUES(170,'1',89);
INSERT INTO SCORE VALUES(170,'2',22);
INSERT INTO SCORE VALUES(170,'3',43);
INSERT INTO SCORE VALUES(170,'4',25);
INSERT INTO SCORE VALUES(170,'5',80);
INSERT INTO SCORE VALUES(171,'1',4);
INSERT INTO SCORE VALUES(171,'2',25);
INSERT INTO SCORE VALUES(171,'3',66);
INSERT INTO SCORE VALUES(171,'4',89);
INSERT INTO SCORE VALUES(171,'5',15);
INSERT INTO SCORE VALUES(172,'1',64);
INSERT INTO SCORE VALUES(172,'2',8);
INSERT INTO SCORE VALUES(172,'3',9);
INSERT INTO SCORE VALUES(172,'4',51);
INSERT INTO SCORE VALUES(172,'5',35);
INSERT INTO SCORE VALUES(173,'1',18);
INSERT INTO SCORE VALUES(173,'2',96);
INSERT INTO SCORE VALUES(173,'3',76);
INSERT INTO SCORE VALUES(173,'4',77);
INSERT INTO SCORE VALUES(173,'5',11);
INSERT INTO SCORE VALUES(174,'1',56);
INSERT INTO SCORE VALUES(174,'2',58);
INSERT INTO SCORE VALUES(174,'3',88);
INSERT INTO SCORE VALUES(174,'4',46);
INSERT INTO SCORE VALUES(174,'5',95);
INSERT INTO SCORE VALUES(175,'1',4);
INSERT INTO SCORE VALUES(175,'2',16);
INSERT INTO SCORE VALUES(175,'3',72);
INSERT INTO SCORE VALUES(175,'4',19);
INSERT INTO SCORE VALUES(175,'5',37);
INSERT INTO SCORE VALUES(176,'1',38);
INSERT INTO SCORE VALUES(176,'2',73);
INSERT INTO SCORE VALUES(176,'3',29);
INSERT INTO SCORE VALUES(176,'4',98);
INSERT INTO SCORE VALUES(176,'5',89);
INSERT INTO SCORE VALUES(177,'1',19);
INSERT INTO SCORE VALUES(177,'2',94);
INSERT INTO SCORE VALUES(177,'3',47);
INSERT INTO SCORE VALUES(177,'4',54);
INSERT INTO SCORE VALUES(177,'5',60);
INSERT INTO SCORE VALUES(178,'1',6);
INSERT INTO SCORE VALUES(178,'2',36);
INSERT INTO SCORE VALUES(178,'3',68);
INSERT INTO SCORE VALUES(178,'4',62);
INSERT INTO SCORE VALUES(178,'5',51);
INSERT INTO SCORE VALUES(179,'1',28);
INSERT INTO SCORE VALUES(179,'2',66);
INSERT INTO SCORE VALUES(179,'3',22);
INSERT INTO SCORE VALUES(179,'4',86);
INSERT INTO SCORE VALUES(179,'5',14);
INSERT INTO SCORE VALUES(180,'1',42);
INSERT INTO SCORE VALUES(180,'2',27);
INSERT INTO SCORE VALUES(180,'3',6);
INSERT INTO SCORE VALUES(180,'4',13);
INSERT INTO SCORE VALUES(180,'5',44);
INSERT INTO SCORE VALUES(181,'1',41);
INSERT INTO SCORE VALUES(181,'2',30);
INSERT INTO SCORE VALUES(181,'3',46);
INSERT INTO SCORE VALUES(181,'4',15);
INSERT INTO SCORE VALUES(181,'5',38);
INSERT INTO SCORE VALUES(182,'1',74);
INSERT INTO SCORE VALUES(182,'2',8);
INSERT INTO SCORE VALUES(182,'3',25);
INSERT INTO SCORE VALUES(182,'4',64);
INSERT INTO SCORE VALUES(182,'5',14);
INSERT INTO SCORE VALUES(183,'1',88);
INSERT INTO SCORE VALUES(183,'2',65);
INSERT INTO SCORE VALUES(183,'3',30);
INSERT INTO SCORE VALUES(183,'4',1);
INSERT INTO SCORE VALUES(183,'5',78);
INSERT INTO SCORE VALUES(184,'1',94);
INSERT INTO SCORE VALUES(184,'2',49);
INSERT INTO SCORE VALUES(184,'3',4);
INSERT INTO SCORE VALUES(184,'4',80);
INSERT INTO SCORE VALUES(184,'5',15);
INSERT INTO SCORE VALUES(185,'1',11);
INSERT INTO SCORE VALUES(185,'2',52);
INSERT INTO SCORE VALUES(185,'3',94);
INSERT INTO SCORE VALUES(185,'4',25);
INSERT INTO SCORE VALUES(185,'5',95);
INSERT INTO SCORE VALUES(186,'1',35);
INSERT INTO SCORE VALUES(186,'2',24);
INSERT INTO SCORE VALUES(186,'3',2);
INSERT INTO SCORE VALUES(186,'4',6);
INSERT INTO SCORE VALUES(186,'5',75);
INSERT INTO SCORE VALUES(187,'1',33);
INSERT INTO SCORE VALUES(187,'2',4);
INSERT INTO SCORE VALUES(187,'3',2);
INSERT INTO SCORE VALUES(187,'4',13);
INSERT INTO SCORE VALUES(187,'5',41);
INSERT INTO SCORE VALUES(188,'1',72);
INSERT INTO SCORE VALUES(188,'2',45);
INSERT INTO SCORE VALUES(188,'3',33);
INSERT INTO SCORE VALUES(188,'4',9);
INSERT INTO SCORE VALUES(188,'5',25);
INSERT INTO SCORE VALUES(189,'1',67);
INSERT INTO SCORE VALUES(189,'2',87);
INSERT INTO SCORE VALUES(189,'3',70);
INSERT INTO SCORE VALUES(189,'4',47);
INSERT INTO SCORE VALUES(189,'5',30);
INSERT INTO SCORE VALUES(190,'1',2);
INSERT INTO SCORE VALUES(190,'2',20);
INSERT INTO SCORE VALUES(190,'3',56);
INSERT INTO SCORE VALUES(190,'4',63);
INSERT INTO SCORE VALUES(190,'5',33);
INSERT INTO SCORE VALUES(191,'1',42);
INSERT INTO SCORE VALUES(191,'2',49);
INSERT INTO SCORE VALUES(191,'3',61);
INSERT INTO SCORE VALUES(191,'4',94);
INSERT INTO SCORE VALUES(191,'5',13);
INSERT INTO SCORE VALUES(192,'1',80);
INSERT INTO SCORE VALUES(192,'2',20);
INSERT INTO SCORE VALUES(192,'3',51);
INSERT INTO SCORE VALUES(192,'4',17);
INSERT INTO SCORE VALUES(192,'5',75);
INSERT INTO SCORE VALUES(193,'1',76);
INSERT INTO SCORE VALUES(193,'2',4);
INSERT INTO SCORE VALUES(193,'3',91);
INSERT INTO SCORE VALUES(193,'4',33);
INSERT INTO SCORE VALUES(193,'5',73);
INSERT INTO SCORE VALUES(194,'1',4);
INSERT INTO SCORE VALUES(194,'2',44);
INSERT INTO SCORE VALUES(194,'3',65);
INSERT INTO SCORE VALUES(194,'4',53);
INSERT INTO SCORE VALUES(194,'5',68);
INSERT INTO SCORE VALUES(195,'1',38);
INSERT INTO SCORE VALUES(195,'2',11);
INSERT INTO SCORE VALUES(195,'3',12);
INSERT INTO SCORE VALUES(195,'4',94);
INSERT INTO SCORE VALUES(195,'5',10);
INSERT INTO SCORE VALUES(196,'1',38);
INSERT INTO SCORE VALUES(196,'2',11);
INSERT INTO SCORE VALUES(196,'3',12);
INSERT INTO SCORE VALUES(196,'4',94);
INSERT INTO SCORE VALUES(196,'5',10);
INSERT INTO SCORE VALUES(197,'1',66);
INSERT INTO SCORE VALUES(197,'2',55);
INSERT INTO SCORE VALUES(197,'3',77);
INSERT INTO SCORE VALUES(197,'4',99);
INSERT INTO SCORE VALUES(197,'5',100);
INSERT INTO SCORE VALUES(198,'1',100);
INSERT INTO SCORE VALUES(198,'2',100);
INSERT INTO SCORE VALUES(198,'3',100);
INSERT INTO SCORE VALUES(198,'4',100);
INSERT INTO SCORE VALUES(198,'5',100);
INSERT INTO SCORE VALUES(199,'1',85);
INSERT INTO SCORE VALUES(199,'2',90);
INSERT INTO SCORE VALUES(199,'3',95);
INSERT INTO SCORE VALUES(199,'4',94);
INSERT INTO SCORE VALUES(199,'5',100);
INSERT INTO SCORE VALUES(200,'1',88);
INSERT INTO SCORE VALUES(200,'2',77);
INSERT INTO SCORE VALUES(200,'3',66);
INSERT INTO SCORE VALUES(200,'4',94);
INSERT INTO SCORE VALUES(200,'5',100);

评论列表( 0 )

你可以在登录后,发表评论

搜索帮助