【学生成绩管理】数据库示例数据（MySQL代码）
目录
一、创建数据库
/* ======================================================
==== 代码如下：
drop database if exists mydb;
create database mydb;
use mydb;
======================================================*/
mysql>dropdatabaseifexists mydb;
Query OK,5rows affected (0.03 sec)
mysql>createdatabase mydb;
Query OK,1row affected (0.00 sec)
mysql>use mydb;Database changed
二、创建dept（学院）表
1、创建表结构
/* ======================================================
==== 代码如下：
create table dept(
dept_id char(3) primary key,
dept_name char(50),
phone char(20),
address varchar(20)
);
======================================================*/
mysql>createtable dept(-> dept_id char(3)primarykey,-> dept_name char(50),-> phone char(20),-> address varchar(20)->);
Query OK,0rows affected (0.01 sec)
2、添加示例数据
/* ======================================================
==== 代码如下：
insert into dept values('D01','经济学院','0373-3025111','10号教学楼1101');
insert into dept values('D02','管理学院','0373-3025122','12号教学楼602');
insert into dept values('D03','生命科技学院','0373-3025133','8号教学楼204');
insert into dept values('D04','农学院','0373-3025144','7号教学楼612');
insert into dept values('D05','化工学院','0373-3025211','9号教学楼411');
insert into dept values('D06','外国语学院','0373-3025222','6号教学楼312');
insert into dept values('D07','数学学院','0373-3025333','5号教学楼205');
insert into dept values('D08','文法学院','0373-3025555','0号教学楼703');
insert into dept values('D09','教育学院','0373-3025666','11号教学楼806');
insert into dept values('D10','艺术学院','0373-3025999','13号教学楼605');
======================================================*/
3、查看表中数据
mysql>select*from dept;+---------+--------------+--------------+----------------+| dept_id | dept_name | phone | address |+---------+--------------+--------------+----------------+| D01 | 经济学院 |0373-3025111|10号教学楼1101|| D02 | 管理学院 |0373-3025122|12号教学楼602|| D03 | 生命科技学院 |0373-3025133|8号教学楼204|| D04 | 农学院 |0373-3025144|7号教学楼612|| D05 | 化工学院 |0373-3025211|9号教学楼411|| D06 | 外国语学院 |0373-3025222|6号教学楼312|| D07 | 数学学院 |0373-3025333|5号教学楼205|| D08 | 文法学院 |0373-3025555|0号教学楼703|| D09 | 教育学院 |0373-3025666|11号教学楼806|| D10 | 艺术学院 |0373-3025999|13号教学楼605|+---------+--------------+--------------+----------------+10rowsinset(0.00 sec)
三、创建stu（学生）表
1、创建表结构
/* ======================================================
==== 代码如下：
create table stu(
s_id char(11) primary key,
s_name char(20),
gender char(2),
birth date,
phone char(20),
dept_id char(3),
foreign key(dept_id) references dept(dept_id)
);
======================================================*/
mysql>createtable stu(-> s_id char(11)primarykey,-> s_name char(20),-> gender char(2),-> birth date,-> phone char(20),-> dept_id char(3),->foreignkey(dept_id)references dept(dept_id)->);
Query OK,0rows affected (0.01 sec)
2、添加示例数据
/* ======================================================
==== 代码如下：
insert into stu values('20220124001','薛智玲','男','2000-1-15','13637358097','D01');
insert into stu values('20220124002','杨铭华','男','2001-3-6','13637381407','D01');
insert into stu values('20220124003','张从超','女','2003-12-9','13637389129','D01');
insert into stu values('20220124004','孙金航','女','2003-3-7','13637387244','D01');
insert into stu values('20220124005','张赞聪','男','2002-11-10','13637346329','D01');
insert into stu values('20220124006','陈柏媛','女','2003-7-18','13637357663','D01');
insert into stu values('20220124007','赵俊彦','男','2003-5-15','13637356250','D01');
insert into stu values('20220124008','饶麒圭','女','2003-8-13','13637354890','D01');
insert into stu values('20220124009','刘旭俊','女','2002-6-5','13637385794','D01');
insert into stu values('20220124010','许滟钗','男','2001-10-19','13637343935','D01');
insert into stu values('20220124011','刘弈俊','男','2003-7-15','13637317133','D01');
insert into stu values('20220124012','李耀炫','女','2002-5-8','13637315100','D01');
insert into stu values('20220124013','单新阳','男','2004-9-26','13637312764','D01');
insert into stu values('20220214001','谭宝名','男','2002-8-5','13637332439','D02');
insert into stu values('20220214002','赵文瀚','女','2001-3-25','13637381710','D02');
insert into stu values('20220214003','裴天馨','女','2003-4-15','13637381374','D02');
insert into stu values('20220214004','董天邦','女','2000-2-18','13637317690','D02');
insert into stu values('20220214005','李振彬','女','2001-3-28','13637355457','D02');
insert into stu values('20220214006','钱鹏琪','女','2003-10-27','13637318606','D02');
insert into stu values('20220214007','陈翡','男','2001-10-17','13637318317','D02');
insert into stu values('20220214008','葛伟花','男','2004-8-3','13637367011','D02');
insert into stu values('20220214009','吴馨瑞','男','2002-1-16','13637333823','D02');
insert into stu values('20220214010','王惠基','男','2001-10-2','13637371200','D02');
insert into stu values('20220214011','龚海珂','女','2004-12-8','13637360494','D02');
insert into stu values('20220214012','韩凤仿','女','2002-2-22','13637390290','D02');
insert into stu values('20220214013','马明杰','女','2000-2-10','13637347762','D02');
insert into stu values('20220214014','覃柄苑','女','2003-2-20','13637319961','D02');
insert into stu values('20220325101','董雯林','男','2003-12-27','13637357085','D03');
insert into stu values('20220325102','周宜可','男','2002-7-4','13637333898','D03');
insert into stu values('20220325103','张春晶','男','2001-6-21','13637340698','D03');
insert into stu values('20220325104','曹哓明','女','2001-12-13','13637351720','D03');
insert into stu values('20220325105','王泰骧','女','2001-10-7','13637377971','D03');
insert into stu values('20220325106','黄雍军','女','2000-9-1','13637342838','D03');
insert into stu values('20220325107','周聪','女','2003-11-17','13637320247','D03');
insert into stu values('20220325108','段义华','男','2001-5-6','13637343972','D03');
insert into stu values('20220325109','唐金琴','女','2001-1-11','13637329007','D03');
insert into stu values('20220325110','谭榕','男','2002-4-19','13637349912','D03');
insert into stu values('20220325111','吴文真','女','2003-4-18','13637354698','D03');
insert into stu values('20220325112','彭志丹','男','2001-1-12','13637391633','D03');
insert into stu values('20220325113','古鹏为','女','2001-8-5','13637355739','D03');
insert into stu values('20220325114','薛玉龙','男','2003-7-11','13637349887','D03');
insert into stu values('20220410101','夏飞研','女','2002-9-2','13637326693','D04');
insert into stu values('20220410102','聂小龙','男','2002-12-4','13637331432','D04');
insert into stu values('20220410103','赵晨祥','女','2002-5-22','13637388564','D04');
insert into stu values('20220410104','江沐洪','男','2002-2-12','13637345052','D04');
insert into stu values('20220410105','潘玟君','男','2001-5-2','13637383612','D04');
insert into stu values('20220410106','段奕宏','女','2004-10-14','13637382026','D04');
insert into stu values('20220410107','肖青枝','男','2001-8-5','13637319418','D04');
insert into stu values('20220410108','李昕泽','男','2002-7-7','13637389104','D04');
insert into stu values('20220410109','田晓宇','女','2003-7-5','13637357040','D04');
insert into stu values('20220410110','李昌镐','女','2001-5-17','13637382453','D04');
insert into stu values('20220410111','刘长浩','男','2002-9-22','13637379833','D04');
insert into stu values('20220410112','梁文音','女','2000-6-8','13637338905','D04');
insert into stu values('20220410113','李博宇','男','2000-2-9','13637364489','D04');
insert into stu values('20220410114','彭靖开','女','2004-11-9','13637341846','D04');
insert into stu values('20220410115','侯弈劭','女','2003-10-10','13637365164','D04');
insert into stu values('20220410116','陈美西','男','2003-4-6','13637386537','D04');
insert into stu values('20220522101','王俊博','男','2003-9-8','13637328551','D05');
insert into stu values('20220522102','阮建惠','男','2003-5-9','13637356754','D05');
insert into stu values('20220522103','高炫开','女','2000-6-16','13637361567','D05');
insert into stu values('20220522104','粱宣景','女','2001-4-14','13637354909','D05');
insert into stu values('20220522105','蔡思迪','男','2001-10-10','13637326462','D05');
insert into stu values('20220522106','宋昶钦','男','2001-7-11','13637337840','D05');
insert into stu values('20220522107','沈厚捷','女','2003-11-11','13637358553','D05');
insert into stu values('20220522108','董彦舒','男','2003-2-22','13637323877','D05');
insert into stu values('20220522109','姜俞然','男','2003-10-7','13637385118','D05');
insert into stu values('20220522110','龚军皓','女','2001-6-7','13637364996','D05');
insert into stu values('20220522111','丘玟涵','女','2002-1-25','13637319822','D05');
insert into stu values('20220522112','冯奕焜','女','2001-4-3','13637361185','D05');
insert into stu values('20220522113','康弈琇','女','2002-1-13','13637349947','D05');
insert into stu values('20220522114','贺垚珺','男','2004-9-17','13637377303','D05');
insert into stu values('20220522115','夏冠尧','男','2000-5-21','13637387222','D05');
insert into stu values('20220522116','严拓斐','女','2001-4-16','13637339832','D05');
insert into stu values('20220610101','廖亮喻','男','2004-11-20','13637367768','D06');
insert into stu values('20220610102','贺勇杰','女','2002-11-3','13637346860','D06');
insert into stu values('20220610103','陶波韧','女','2003-11-21','13637380211','D06');
insert into stu values('20220610104','阎飞为','女','2000-9-16','13637335583','D06');
insert into stu values('20220610105','郭昱皓','男','2002-6-27','13637386149','D06');
insert into stu values('20220610106','孟俊钦','男','2004-11-27','13637345788','D06');
insert into stu values('20220610107','牛军焜','女','2003-11-19','13637373857','D06');
insert into stu values('20220610108','周奕博','女','2000-11-7','13637373974','D06');
insert into stu values('20220610109','邓弈迪','男','2000-9-8','13637359764','D06');
insert into stu values('20220610110','许思韧','男','2001-8-1','13637373482','D06');
insert into stu values('20220610111','胡宣为','女','2002-2-27','13637372561','D06');
insert into stu values('20220610112','习炫渊','男','2000-3-8','13637342032','D06');
insert into stu values('20220610113','汤昶捷','女','2000-5-11','13637359714','D06');
insert into stu values('20220610114','莫俞惠','男','2000-5-26','13637381480','D06');
insert into stu values('20220610115','朱彦竣','女','2002-7-14','13637386772','D06');
insert into stu values('20220610116','杜建轶','女','2001-7-6','13637328733','D06');
insert into stu values('20220610117','马厚策','男','2003-11-9','13637364688','D06');
insert into stu values('20220610118','庞拓景','男','2002-4-6','13637378295','D06');
insert into stu values('20220714101','何玺皓','女','2001-2-13','13637324918','D07');
insert into stu values('20220714102','凌韬博','女','2001-8-26','13637369542','D07');
insert into stu values('20220714103','白烁渊','男','2002-6-10','13637337634','D07');
insert into stu values('20220714104','姚际惠','男','2001-7-24','13637316005','D07');
insert into stu values('20220714105','伊韵迪','男','2002-7-26','13637367799','D07');
insert into stu values('20220714106','秦卓珈','女','2002-10-8','13637377879','D07');
insert into stu values('20220714107','韩一芳','男','2001-1-28','13637384835','D07');
insert into stu values('20220714108','刘志宝','男','2001-9-10','13637373444','D07');
insert into stu values('20220714109','申莹洋','女','2003-4-26','13637388716','D07');
insert into stu values('20220714110','周岚青','男','2003-3-15','13637367051','D07');
insert into stu values('20220714111','徐如华','男','2000-4-3','13637388342','D07');
insert into stu values('20220714112','张淑馨','男','2004-2-19','13637336095','D07');
insert into stu values('20220714113','郭银汝','女','2001-4-19','13637356116','D07');
insert into stu values('20220714114','屈语盼','女','2004-9-28','13637360546','D07');
insert into stu values('20220714115','柳泳辉','男','2003-4-14','13637316131','D07');
insert into stu values('20220714116','王语勇','男','2000-7-9','13637381460','D07');
insert into stu values('20220820101','陶颢瑶','女','2002-2-20','13637385998','D08');
insert into stu values('20220820102','许丽生','女','2004-4-16','13637357115','D08');
insert into stu values('20220820103','张欣盛','女','2002-4-25','13637357139','D08');
insert into stu values('20220820104','李士浚','女','2001-9-11','13637321159','D08');
insert into stu values('20220820105','王瑜铭','女','2000-2-14','13637314225','D08');
insert into stu values('20220820106','邹家轩','女','2001-11-22','13637337596','D08');
insert into stu values('20220820107','向靖辉','男','2000-3-4','13637382013','D08');
insert into stu values('20220820108','肖浩平','男','2004-6-28','13637331655','D08');
insert into stu values('20220820109','张菲丽','女','2004-2-6','13637318255','D08');
insert into stu values('20220820110','王安青','女','2004-10-14','13637381170','D08');
insert into stu values('20220930111','周星利','女','2001-5-26','13637331407','D09');
insert into stu values('20220930112','张鸣云','女','2004-2-20','13637330474','D09');
insert into stu values('20220930113','纪冉久','男','2003-3-3','13637313600','D09');
insert into stu values('20220930114','贾炳麟','男','2003-2-12','13637350928','D09');
insert into stu values('20220930115','陈丽濠','女','2003-3-28','13637376055','D09');
insert into stu values('20220930116','喻武琰','男','2000-5-17','13637312126','D09');
insert into stu values('20220930117','涂彩珩','男','2001-3-20','13637321286','D09');
insert into stu values('20220930118','冉惠弘','男','2003-3-3','13637313899','D09');
insert into stu values('20220930119','王雪凡','女','2003-3-11','13637360598','D09');
insert into stu values('20220930120','陈露程','男','2001-10-7','13637345077','D09');
insert into stu values('20220930121','曾嘉伊','男','2002-9-3','13637323247','D09');
insert into stu values('20220930122','申仔霁','女','2000-7-21','13637357170','D09');
insert into stu values('20220930123','刘炫玉','女','2002-10-16','13637364086','D09');
insert into stu values('20220930124','钟仁婷','女','2003-9-15','13637379257','D09');
insert into stu values('20220930125','吴姗峰','男','2002-11-18','13637350770','D09');
insert into stu values('20220930126','刘姿凡','男','2003-8-2','13637315098','D09');
insert into stu values('20220930127','林晓凤','男','2000-11-19','13637347620','D09');
insert into stu values('20220930128','赵翊祺','男','2002-8-24','13637364551','D09');
insert into stu values('20221012101','白建屏','女','2002-10-5','13637345427','D10');
insert into stu values('20221012102','魏恬伟','女','2000-10-14','13637383372','D10');
insert into stu values('20221012103','葛卓涵','男','2000-2-13','13637387435','D10');
insert into stu values('20221012104','蒋玉东','男','2001-4-5','13637314258','D10');
insert into stu values('20221012105','曾莘琳','男','2004-9-25','13637363443','D10');
insert into stu values('20221012106','胡本洱','女','2001-10-2','13637362524','D10');
insert into stu values('20221012107','高芳宇','女','2003-4-26','13637315050','D10');
insert into stu values('20221012108','卢琛平','女','2003-3-11','13637316052','D10');
insert into stu values('20221012109','魏宗灵','男','2002-5-13','13637346458','D10');
insert into stu values('20221012110','唐丽冰','男','2004-5-19','13637324777','D10');
insert into stu values('20221012111','龚修东','男','2004-11-8','13637358603','D10');
insert into stu values('20221012112','庞新涵','女','2003-3-17','13637318266','D10');
insert into stu values('20221012113','方键','女','2000-7-21','13637318190','D10');
insert into stu values('20221012114','汤豫毅','女','2004-3-2','13637376468','D10');
insert into stu values('20221012115','龚照东','男','2001-9-8','13637378473','D10');
insert into stu values('20221012116','周二智','男','2001-10-28','13637353275','D10');
insert into stu values('20221012117','刘昊恒','男','2004-4-12','13637384973','D10');
insert into stu values('20221012118','徐川廷','女','2003-6-26','13637327921','D10');
insert into stu values('20221012119','阎栖晨','男','2002-1-22','13637374839','D10');
insert into stu values('20221012120','颜子洋','男','2001-2-6','13637331614','D10');
insert into stu values('20221012121','李俊威','男','2003-3-19','13637379108','D10');
insert into stu values('20221012122','任玉罕','男','2001-2-15','13637376859','D10');
insert into stu values('20221012123','黄莱赫','女','2002-11-13','13637360030','D10');
insert into stu values('20221012124','方欣英','女','2004-4-26','13637343776','D10');
insert into stu values('20221012125','李凌添','男','2002-8-10','13637352757','D10');
insert into stu values('20221012126','余玉一','男','2002-2-1','13637316981','D10');
insert into stu values('20221012127','吴熙达','男','2003-2-7','13637377512','D10');
======================================================*/
3、查看表中数据
mysql>select*from stu;+-------------+--------+--------+------------+-------------+---------+| s_id | s_name | gender | birth | phone | dept_id |+-------------+--------+--------+------------+-------------+---------+|20220124001| 薛智玲 | 男 |2000-01-15|13637358097| D01 ||20220124002| 杨铭华 | 男 |2001-03-06|13637381407| D01 ||20220124003| 张从超 | 女 |2003-12-09|13637389129| D01 ||20220124004| 孙金航 | 女 |2003-03-07|13637387244| D01 ||20220124005| 张赞聪 | 男 |2002-11-10|13637346329| D01 ||20220124006| 陈柏媛 | 女 |2003-07-18|13637357663| D01 ||20220124007| 赵俊彦 | 男 |2003-05-15|13637356250| D01 ||20220124008| 饶麒圭 | 女 |2003-08-13|13637354890| D01 ||20220124009| 刘旭俊 | 女 |2002-06-05|13637385794| D01 ||20220124010| 许滟钗 | 男 |2001-10-19|13637343935| D01 ||20220124011| 刘弈俊 | 男 |2003-07-15|13637317133| D01 ||20220124012| 李耀炫 | 女 |2002-05-08|13637315100| D01 ||20220124013| 单新阳 | 男 |2004-09-26|13637312764| D01 ||20220214001| 谭宝名 | 男 |2002-08-05|13637332439| D02 ||20220214002| 赵文瀚 | 女 |2001-03-25|13637381710| D02 ||20220214003| 裴天馨 | 女 |2003-04-15|13637381374| D02 ||20220214004| 董天邦 | 女 |2000-02-18|13637317690| D02 ||20220214005| 李振彬 | 女 |2001-03-28|13637355457| D02 ||20220214006| 钱鹏琪 | 女 |2003-10-27|13637318606| D02 ||20220214007| 陈翡 | 男 |2001-10-17|13637318317| D02 ||20220214008| 葛伟花 | 男 |2004-08-03|13637367011| D02 ||20220214009| 吴馨瑞 | 男 |2002-01-16|13637333823| D02 ||20220214010| 王惠基 | 男 |2001-10-02|13637371200| D02 ||20220214011| 龚海珂 | 女 |2004-12-08|13637360494| D02 ||20220214012| 韩凤仿 | 女 |2002-02-22|13637390290| D02 ||20220214013| 马明杰 | 女 |2000-02-10|13637347762| D02 ||20220214014| 覃柄苑 | 女 |2003-02-20|13637319961| D02 ||20220325101| 董雯林 | 男 |2003-12-27|13637357085| D03 ||20220325102| 周宜可 | 男 |2002-07-04|13637333898| D03 ||20220325103| 张春晶 | 男 |2001-06-21|13637340698| D03 ||20220325104| 曹哓明 | 女 |2001-12-13|13637351720| D03 ||20220325105| 王泰骧 | 女 |2001-10-07|13637377971| D03 ||20220325106| 黄雍军 | 女 |2000-09-01|13637342838| D03 ||20220325107| 周聪 | 女 |2003-11-17|13637320247| D03 ||20220325108| 段义华 | 男 |2001-05-06|13637343972| D03 ||20220325109| 唐金琴 | 女 |2001-01-11|13637329007| D03 ||20220325110| 谭榕 | 男 |2002-04-19|13637349912| D03 ||20220325111| 吴文真 | 女 |2003-04-18|13637354698| D03 ||20220325112| 彭志丹 | 男 |2001-01-12|13637391633| D03 ||20220325113| 古鹏为 | 女 |2001-08-05|13637355739| D03 ||20220325114| 薛玉龙 | 男 |2003-07-11|13637349887| D03 ||20220410101| 夏飞研 | 女 |2002-09-02|13637326693| D04 ||20220410102| 聂小龙 | 男 |2002-12-04|13637331432| D04 ||20220410103| 赵晨祥 | 女 |2002-05-22|13637388564| D04 ||20220410104| 江沐洪 | 男 |2002-02-12|13637345052| D04 ||20220410105| 潘玟君 | 男 |2001-05-02|13637383612| D04 ||20220410106| 段奕宏 | 女 |2004-10-14|13637382026| D04 ||20220410107| 肖青枝 | 男 |2001-08-05|13637319418| D04 ||20220410108| 李昕泽 | 男 |2002-07-07|13637389104| D04 ||20220410109| 田晓宇 | 女 |2003-07-05|13637357040| D04 ||20220410110| 李昌镐 | 女 |2001-05-17|13637382453| D04 ||20220410111| 刘长浩 | 男 |2002-09-22|13637379833| D04 ||20220410112| 梁文音 | 女 |2000-06-08|13637338905| D04 ||20220410113| 李博宇 | 男 |2000-02-09|13637364489| D04 ||20220410114| 彭靖开 | 女 |2004-11-09|13637341846| D04 ||20220410115| 侯弈劭 | 女 |2003-10-10|13637365164| D04 ||20220410116| 陈美西 | 男 |2003-04-06|13637386537| D04 ||20220522101| 王俊博 | 男 |2003-09-08|13637328551| D05 ||20220522102| 阮建惠 | 男 |2003-05-09|13637356754| D05 ||20220522103| 高炫开 | 女 |2000-06-16|13637361567| D05 ||20220522104| 粱宣景 | 女 |2001-04-14|13637354909| D05 ||20220522105| 蔡思迪 | 男 |2001-10-10|13637326462| D05 ||20220522106| 宋昶钦 | 男 |2001-07-11|13637337840| D05 ||20220522107| 沈厚捷 | 女 |2003-11-11|13637358553| D05 ||20220522108| 董彦舒 | 男 |2003-02-22|13637323877| D05 ||20220522109| 姜俞然 | 男 |2003-10-07|13637385118| D05 ||20220522110| 龚军皓 | 女 |2001-06-07|13637364996| D05 ||20220522111| 丘玟涵 | 女 |2002-01-25|13637319822| D05 ||20220522112| 冯奕焜 | 女 |2001-04-03|13637361185| D05 ||20220522113| 康弈琇 | 女 |2002-01-13|13637349947| D05 ||20220522114| 贺垚珺 | 男 |2004-09-17|13637377303| D05 ||20220522115| 夏冠尧 | 男 |2000-05-21|13637387222| D05 ||20220522116| 严拓斐 | 女 |2001-04-16|13637339832| D05 ||20220610101| 廖亮喻 | 男 |2004-11-20|13637367768| D06 ||20220610102| 贺勇杰 | 女 |2002-11-03|13637346860| D06 ||20220610103| 陶波韧 | 女 |2003-11-21|13637380211| D06 ||20220610104| 阎飞为 | 女 |2000-09-16|13637335583| D06 ||20220610105| 郭昱皓 | 男 |2002-06-27|13637386149| D06 ||20220610106| 孟俊钦 | 男 |2004-11-27|13637345788| D06 ||20220610107| 牛军焜 | 女 |2003-11-19|13637373857| D06 ||20220610108| 周奕博 | 女 |2000-11-07|13637373974| D06 ||20220610109| 邓弈迪 | 男 |2000-09-08|13637359764| D06 ||20220610110| 许思韧 | 男 |2001-08-01|13637373482| D06 ||20220610111| 胡宣为 | 女 |2002-02-27|13637372561| D06 ||20220610112| 习炫渊 | 男 |2000-03-08|13637342032| D06 ||20220610113| 汤昶捷 | 女 |2000-05-11|13637359714| D06 ||20220610114| 莫俞惠 | 男 |2000-05-26|13637381480| D06 ||20220610115| 朱彦竣 | 女 |2002-07-14|13637386772| D06 ||20220610116| 杜建轶 | 女 |2001-07-06|13637328733| D06 ||20220610117| 马厚策 | 男 |2003-11-09|13637364688| D06 ||20220610118| 庞拓景 | 男 |2002-04-06|13637378295| D06 ||20220714101| 何玺皓 | 女 |2001-02-13|13637324918| D07 ||20220714102| 凌韬博 | 女 |2001-08-26|13637369542| D07 ||20220714103| 白烁渊 | 男 |2002-06-10|13637337634| D07 ||20220714104| 姚际惠 | 男 |2001-07-24|13637316005| D07 ||20220714105| 伊韵迪 | 男 |2002-07-26|13637367799| D07 ||20220714106| 秦卓珈 | 女 |2002-10-08|13637377879| D07 ||20220714107| 韩一芳 | 男 |2001-01-28|13637384835| D07 ||20220714108| 刘志宝 | 男 |2001-09-10|13637373444| D07 ||20220714109| 申莹洋 | 女 |2003-04-26|13637388716| D07 ||20220714110| 周岚青 | 男 |2003-03-15|13637367051| D07 ||20220714111| 徐如华 | 男 |2000-04-03|13637388342| D07 ||20220714112| 张淑馨 | 男 |2004-02-19|13637336095| D07 ||20220714113| 郭银汝 | 女 |2001-04-19|13637356116| D07 ||20220714114| 屈语盼 | 女 |2004-09-28|13637360546| D07 ||20220714115| 柳泳辉 | 男 |2003-04-14|13637316131| D07 ||20220714116| 王语勇 | 男 |2000-07-09|13637381460| D07 ||20220820101| 陶颢瑶 | 女 |2002-02-20|13637385998| D08 ||20220820102| 许丽生 | 女 |2004-04-16|13637357115| D08 ||20220820103| 张欣盛 | 女 |2002-04-25|13637357139| D08 ||20220820104| 李士浚 | 女 |2001-09-11|13637321159| D08 ||20220820105| 王瑜铭 | 女 |2000-02-14|13637314225| D08 ||20220820106| 邹家轩 | 女 |2001-11-22|13637337596| D08 ||20220820107| 向靖辉 | 男 |2000-03-04|13637382013| D08 ||20220820108| 肖浩平 | 男 |2004-06-28|13637331655| D08 ||20220820109| 张菲丽 | 女 |2004-02-06|13637318255| D08 ||20220820110| 王安青 | 女 |2004-10-14|13637381170| D08 ||20220930111| 周星利 | 女 |2001-05-26|13637331407| D09 ||20220930112| 张鸣云 | 女 |2004-02-20|13637330474| D09 ||20220930113| 纪冉久 | 男 |2003-03-03|13637313600| D09 ||20220930114| 贾炳麟 | 男 |2003-02-12|13637350928| D09 ||20220930115| 陈丽濠 | 女 |2003-03-28|13637376055| D09 ||20220930116| 喻武琰 | 男 |2000-05-17|13637312126| D09 ||20220930117| 涂彩珩 | 男 |2001-03-20|13637321286| D09 ||20220930118| 冉惠弘 | 男 |2003-03-03|13637313899| D09 ||20220930119| 王雪凡 | 女 |2003-03-11|13637360598| D09 ||20220930120| 陈露程 | 男 |2001-10-07|13637345077| D09 ||20220930121| 曾嘉伊 | 男 |2002-09-03|13637323247| D09 ||20220930122| 申仔霁 | 女 |2000-07-21|13637357170| D09 ||20220930123| 刘炫玉 | 女 |2002-10-16|13637364086| D09 ||20220930124| 钟仁婷 | 女 |2003-09-15|13637379257| D09 ||20220930125| 吴姗峰 | 男 |2002-11-18|13637350770| D09 ||20220930126| 刘姿凡 | 男 |2003-08-02|13637315098| D09 ||20220930127| 林晓凤 | 男 |2000-11-19|13637347620| D09 ||20220930128| 赵翊祺 | 男 |2002-08-24|13637364551| D09 ||20221012101| 白建屏 | 女 |2002-10-05|13637345427| D10 ||20221012102| 魏恬伟 | 女 |2000-10-14|13637383372| D10 ||20221012103| 葛卓涵 | 男 |2000-02-13|13637387435| D10 ||20221012104| 蒋玉东 | 男 |2001-04-05|13637314258| D10 ||20221012105| 曾莘琳 | 男 |2004-09-25|13637363443| D10 ||20221012106| 胡本洱 | 女 |2001-10-02|13637362524| D10 ||20221012107| 高芳宇 | 女 |2003-04-26|13637315050| D10 ||20221012108| 卢琛平 | 女 |2003-03-11|13637316052| D10 ||20221012109| 魏宗灵 | 男 |2002-05-13|13637346458| D10 ||20221012110| 唐丽冰 | 男 |2004-05-19|13637324777| D10 ||20221012111| 龚修东 | 男 |2004-11-08|13637358603| D10 ||20221012112| 庞新涵 | 女 |2003-03-17|13637318266| D10 ||20221012113| 方键 | 女 |2000-07-21|13637318190| D10 ||20221012114| 汤豫毅 | 女 |2004-03-02|13637376468| D10 ||20221012115| 龚照东 | 男 |2001-09-08|13637378473| D10 ||20221012116| 周二智 | 男 |2001-10-28|13637353275| D10 ||20221012117| 刘昊恒 | 男 |2004-04-12|13637384973| D10 ||20221012118| 徐川廷 | 女 |2003-06-26|13637327921| D10 ||20221012119| 阎栖晨 | 男 |2002-01-22|13637374839| D10 ||20221012120| 颜子洋 | 男 |2001-02-06|13637331614| D10 ||20221012121| 李俊威 | 男 |2003-03-19|13637379108| D10 ||20221012122| 任玉罕 | 男 |2001-02-15|13637376859| D10 ||20221012123| 黄莱赫 | 女 |2002-11-13|13637360030| D10 ||20221012124| 方欣英 | 女 |2004-04-26|13637343776| D10 ||20221012125| 李凌添 | 男 |2002-08-10|13637352757| D10 ||20221012126| 余玉一 | 男 |2002-02-01|13637316981| D10 ||20221012127| 吴熙达 | 男 |2003-02-07|13637377512| D10 |+-------------+--------+--------+------------+-------------+---------+162rowsinset(0.00 sec)
四、创建course（课程）表
1、创建表结构
/* ======================================================
==== 代码如下：
create table course(
c_id char(6) primary key,
c_name char(50),
credit decimal(4,2)
);
======================================================*/
mysql>createtable course(-> c_id char(6)primarykey,-> c_name char(50),-> credit decimal(4,2)->);
Query OK,0rows affected (0.01 sec)
2、添加示例数据
/* ======================================================
==== 代码如下：
insert into course values('C01001','微观经济学',4);
insert into course values('C01002','宏观经济学',3);
insert into course values('C01003','财务管理',3);
insert into course values('C01004','计量经济学',4);
insert into course values('C01005','数据分析',4);
insert into course values('C01006','大数据概论',4);
insert into course values('C02101','企业管理概论',3);
insert into course values('C02102','管理学原理',3);
insert into course values('C02103','管理信息系统',4);
insert into course values('C02104','数据库系统原理',3);
insert into course values('C02105','信息组织',3);
insert into course values('C03201','遗传学',3);
insert into course values('C03202','药物学',3);
insert into course values('C03203','药理学',3);
insert into course values('C04111','农业环境学',3);
insert into course values('C04112','土壤肥料学',4);
insert into course values('C04113','作物学',4);
insert into course values('C04114','植物学',4);
insert into course values('C04115','病虫害防治',3);
insert into course values('C05121','无机化学',3);
insert into course values('C05122','有机化学',3);
insert into course values('C05123','生理学',3);
insert into course values('C05124','生物化学',3);
insert into course values('C06311','大学英语',4);
insert into course values('C06312','翻译',4);
insert into course values('C06313','外国语言文学',4);
insert into course values('C06314','英语语法',3);
insert into course values('C06315','日语',2);
insert into course values('C06316','法语',2);
insert into course values('C06317','俄语',2);
insert into course values('C07111','线性代数',3);
insert into course values('C07112','高等数学',3);
insert into course values('C07113','运筹学',4);
insert into course values('C07114','概率与数理统计',4);
insert into course values('C07115','离散数学',4);
insert into course values('C07116','复变函数',3);
insert into course values('C08101','古代汉语',3);
insert into course values('C08102','现代汉语',2);
insert into course values('C08103','诗歌',3);
insert into course values('C08104','刑法',2);
insert into course values('C08105','民法',3);
insert into course values('C08106','行政诉讼法',3);
insert into course values('C08107','刑事诉讼法',4);
insert into course values('C09111','心理学',3);
insert into course values('C09112','教育学',2);
insert into course values('C09113','幼儿心理学',3);
insert into course values('C10121','音乐',4);
insert into course values('C10122','书法',2);
insert into course values('C10123','舞蹈',4);
insert into course values('C10124','钢琴',2);
insert into course values('C10125','电子琴',2);
======================================================*/
3、查看表中数据
mysql>select*from course;+--------+----------------+--------+| c_id | c_name | credit |+--------+----------------+--------+| C01001 | 微观经济学 |4.00|| C01002 | 宏观经济学 |3.00|| C01003 | 财务管理 |3.00|| C01004 | 计量经济学 |4.00|| C01005 | 数据分析 |4.00|| C01006 | 大数据概论 |4.00|| C02101 | 企业管理概论 |3.00|| C02102 | 管理学原理 |3.00|| C02103 | 管理信息系统 |4.00|| C02104 | 数据库系统原理 |3.00|| C02105 | 信息组织 |3.00|| C03201 | 遗传学 |3.00|| C03202 | 药物学 |3.00|| C03203 | 药理学 |3.00|| C04111 | 农业环境学 |3.00|| C04112 | 土壤肥料学 |4.00|| C04113 | 作物学 |4.00|| C04114 | 植物学 |4.00|| C04115 | 病虫害防治 |3.00|| C05121 | 无机化学 |3.00|| C05122 | 有机化学 |3.00|| C05123 | 生理学 |3.00|| C05124 | 生物化学 |3.00|| C06311 | 大学英语 |4.00|| C06312 | 翻译 |4.00|| C06313 | 外国语言文学 |4.00|| C06314 | 英语语法 |3.00|| C06315 | 日语 |2.00|| C06316 | 法语 |2.00|| C06317 | 俄语 |2.00|| C07111 | 线性代数 |3.00|| C07112 | 高等数学 |3.00|| C07113 | 运筹学 |4.00|| C07114 | 概率与数理统计 |4.00|| C07115 | 离散数学 |4.00|| C07116 | 复变函数 |3.00|| C08101 | 古代汉语 |3.00|| C08102 | 现代汉语 |2.00|| C08103 | 诗歌 |3.00|| C08104 | 刑法 |2.00|| C08105 | 民法 |3.00|| C08106 | 行政诉讼法 |3.00|| C08107 | 刑事诉讼法 |4.00|| C09111 | 心理学 |3.00|| C09112 | 教育学 |2.00|| C09113 | 幼儿心理学 |3.00|| C10121 | 音乐 |4.00|| C10122 | 书法 |2.00|| C10123 | 舞蹈 |4.00|| C10124 | 钢琴 |2.00|| C10125 | 电子琴 |2.00|+--------+----------------+--------+51rowsinset(0.00 sec)
四、创建xk（选课）表
1、创建表结构
/* ======================================================
==== 代码如下：
create table xk(
s_id char(11),
c_id char(6),
score decimal(5,2),
primary key(s_id,c_id),
foreign key(s_id) references stu(s_id),
foreign key(c_id) references course(c_id)
);
======================================================*/
mysql>createtable xk(-> s_id char(11),-> c_id char(6),-> score decimal(5,2),->primarykey(s_id,c_id),->foreignkey(s_id)references stu(s_id),->foreignkey(c_id)references course(c_id)->);
Query OK,0rows affected (0.01 sec)
2、添加示例数据
/* ======================================================
==== 代码如下：
insert into xk values('20220124001','C01001',61);
insert into xk values('20220124002','C01001',88);
insert into xk values('20220124003','C01001',95);
insert into xk values('20220124004','C01001',81);
insert into xk values('20220124005','C01001',88);
insert into xk values('20220124006','C01001',90);
insert into xk values('20220124007','C01001',71);
insert into xk values('20220124008','C01001',94);
insert into xk values('20220124009','C01001',86);
insert into xk values('20220124010','C01001',82);
insert into xk values('20220124011','C01001',96);
insert into xk values('20220124012','C01001',100);
insert into xk values('20220124013','C01001',92);
insert into xk values('20220124001','C01002',68);
insert into xk values('20220124002','C01002',69);
insert into xk values('20220124007','C01002',74);
insert into xk values('20220124008','C01002',72);
insert into xk values('20220124009','C01002',79);
insert into xk values('20220124010','C01002',61);
insert into xk values('20220124011','C01002',63);
insert into xk values('20220124012','C01002',93);
insert into xk values('20220124013','C01002',97);
insert into xk values('20220124001','C01003',92);
insert into xk values('20220124002','C01003',69);
insert into xk values('20220124003','C01003',94);
insert into xk values('20220124004','C01003',96);
insert into xk values('20220124005','C01003',69);
insert into xk values('20220124010','C01003',93);
insert into xk values('20220124011','C01003',72);
insert into xk values('20220124012','C01003',99);
insert into xk values('20220124013','C01003',98);
insert into xk values('20220124001','C01004',99);
insert into xk values('20220124002','C01004',97);
insert into xk values('20220124003','C01004',68);
insert into xk values('20220124004','C01004',90);
insert into xk values('20220124005','C01004',70);
insert into xk values('20220124006','C01004',77);
insert into xk values('20220124007','C01004',61);
insert into xk values('20220124008','C01004',83);
insert into xk values('20220124009','C01004',79);
insert into xk values('20220124010','C01004',62);
insert into xk values('20220124011','C01004',66);
insert into xk values('20220124012','C01004',87);
insert into xk values('20220124013','C01004',88);
insert into xk values('20220124001','C01005',72);
insert into xk values('20220124002','C01005',77);
insert into xk values('20220124003','C01005',76);
insert into xk values('20220124004','C01005',99);
insert into xk values('20220124005','C01005',95);
insert into xk values('20220124006','C01005',63);
insert into xk values('20220124007','C01005',97);
insert into xk values('20220124008','C01005',76);
insert into xk values('20220124009','C01005',60);
insert into xk values('20220124010','C01005',100);
insert into xk values('20220124011','C01005',81);
insert into xk values('20220124012','C01005',97);
insert into xk values('20220124013','C01005',97);
insert into xk values('20220124001','C01006',97);
insert into xk values('20220124002','C01006',80);
insert into xk values('20220124003','C01006',65);
insert into xk values('20220124004','C01006',79);
insert into xk values('20220124005','C01006',77);
insert into xk values('20220124010','C01006',80);
insert into xk values('20220124011','C01006',95);
insert into xk values('20220124012','C01006',83);
insert into xk values('20220124013','C01006',88);
insert into xk values('20220214001','C02101',80);
insert into xk values('20220214002','C02101',63);
insert into xk values('20220214003','C02101',72);
insert into xk values('20220214004','C02101',77);
insert into xk values('20220214005','C02101',89);
insert into xk values('20220214006','C02101',74);
insert into xk values('20220214007','C02101',65);
insert into xk values('20220214008','C02101',70);
insert into xk values('20220214009','C02101',90);
insert into xk values('20220214010','C02101',99);
insert into xk values('20220214011','C02101',88);
insert into xk values('20220214012','C02101',95);
insert into xk values('20220214013','C02101',93);
insert into xk values('20220214014','C02101',68);
insert into xk values('20220214001','C02102',80);
insert into xk values('20220214002','C02102',67);
insert into xk values('20220214003','C02102',96);
insert into xk values('20220214009','C02102',71);
insert into xk values('20220214010','C02102',80);
insert into xk values('20220214011','C02102',61);
insert into xk values('20220214012','C02102',64);
insert into xk values('20220214013','C02102',69);
insert into xk values('20220214014','C02102',80);
insert into xk values('20220214001','C02103',97);
insert into xk values('20220214002','C02103',74);
insert into xk values('20220214003','C02103',94);
insert into xk values('20220214004','C02103',65);
insert into xk values('20220214005','C02103',76);
insert into xk values('20220214006','C02103',63);
insert into xk values('20220214007','C02103',92);
insert into xk values('20220214008','C02103',86);
insert into xk values('20220214009','C02103',76);
insert into xk values('20220214010','C02103',62);
insert into xk values('20220214011','C02103',72);
insert into xk values('20220214001','C02104',96);
insert into xk values('20220214002','C02104',79);
insert into xk values('20220214003','C02104',93);
insert into xk values('20220214004','C02104',73);
insert into xk values('20220214005','C02104',67);
insert into xk values('20220214006','C02104',85);
insert into xk values('20220214007','C02104',62);
insert into xk values('20220214008','C02104',70);
insert into xk values('20220214009','C02104',84);
insert into xk values('20220214010','C02104',73);
insert into xk values('20220214011','C02104',100);
insert into xk values('20220214012','C02104',89);
insert into xk values('20220214013','C02104',73);
insert into xk values('20220214014','C02104',86);
insert into xk values('20220214001','C02105',82);
insert into xk values('20220214002','C02105',65);
insert into xk values('20220214003','C02105',67);
insert into xk values('20220214004','C02105',81);
insert into xk values('20220214009','C02105',77);
insert into xk values('20220214010','C02105',75);
insert into xk values('20220214011','C02105',87);
insert into xk values('20220214012','C02105',70);
insert into xk values('20220214013','C02105',82);
insert into xk values('20220214014','C02105',75);
insert into xk values('20220325101','C03201',83);
insert into xk values('20220325102','C03201',90);
insert into xk values('20220325103','C03201',65);
insert into xk values('20220325104','C03201',86);
insert into xk values('20220325105','C03201',68);
insert into xk values('20220325106','C03201',65);
insert into xk values('20220325107','C03201',86);
insert into xk values('20220325108','C03201',72);
insert into xk values('20220325109','C03201',91);
insert into xk values('20220325110','C03201',90);
insert into xk values('20220325111','C03201',92);
insert into xk values('20220325112','C03201',96);
insert into xk values('20220325113','C03201',84);
insert into xk values('20220325114','C03201',94);
insert into xk values('20220325101','C03202',83);
insert into xk values('20220325102','C03202',84);
insert into xk values('20220325103','C03202',77);
insert into xk values('20220325104','C03202',87);
insert into xk values('20220325105','C03202',70);
insert into xk values('20220325106','C03202',87);
insert into xk values('20220325107','C03202',82);
insert into xk values('20220325108','C03202',84);
insert into xk values('20220325109','C03202',99);
insert into xk values('20220325110','C03202',87);
insert into xk values('20220325111','C03202',76);
insert into xk values('20220325112','C03202',94);
insert into xk values('20220325113','C03202',66);
insert into xk values('20220325114','C03202',99);
insert into xk values('20220325101','C03203',74);
insert into xk values('20220325102','C03203',67);
insert into xk values('20220325103','C03203',66);
insert into xk values('20220325104','C03203',81);
insert into xk values('20220325105','C03203',94);
insert into xk values('20220325110','C03203',64);
insert into xk values('20220325111','C03203',97);
insert into xk values('20220325112','C03203',68);
insert into xk values('20220325113','C03203',69);
insert into xk values('20220325114','C03203',67);
insert into xk values('20220410101','C04111',68);
insert into xk values('20220410102','C04111',62);
insert into xk values('20220410103','C04111',64);
insert into xk values('20220410104','C04111',64);
insert into xk values('20220410105','C04111',92);
insert into xk values('20220410106','C04111',75);
insert into xk values('20220410107','C04111',63);
insert into xk values('20220410108','C04111',61);
insert into xk values('20220410109','C04111',89);
insert into xk values('20220410110','C04111',81);
insert into xk values('20220410111','C04111',85);
insert into xk values('20220410112','C04111',72);
insert into xk values('20220410113','C04111',61);
insert into xk values('20220410114','C04111',89);
insert into xk values('20220410115','C04111',72);
insert into xk values('20220410116','C04111',74);
insert into xk values('20220410101','C04112',97);
insert into xk values('20220410102','C04112',78);
insert into xk values('20220410103','C04112',82);
insert into xk values('20220410104','C04112',75);
insert into xk values('20220410105','C04112',100);
insert into xk values('20220410106','C04112',73);
insert into xk values('20220410107','C04112',65);
insert into xk values('20220410108','C04112',96);
insert into xk values('20220410109','C04112',96);
insert into xk values('20220410110','C04112',70);
insert into xk values('20220410111','C04112',69);
insert into xk values('20220410112','C04112',62);
insert into xk values('20220410113','C04112',98);
insert into xk values('20220410114','C04112',98);
insert into xk values('20220410115','C04112',92);
insert into xk values('20220410116','C04112',95);
insert into xk values('20220410101','C04113',83);
insert into xk values('20220410102','C04113',72);
insert into xk values('20220410103','C04113',62);
insert into xk values('20220410109','C04113',70);
insert into xk values('20220410110','C04113',61);
insert into xk values('20220410111','C04113',84);
insert into xk values('20220410112','C04113',98);
insert into xk values('20220410113','C04113',75);
insert into xk values('20220410114','C04113',71);
insert into xk values('20220410115','C04113',71);
insert into xk values('20220410116','C04113',63);
insert into xk values('20220410101','C04114',100);
insert into xk values('20220410102','C04114',72);
insert into xk values('20220410107','C04114',97);
insert into xk values('20220410108','C04114',63);
insert into xk values('20220410109','C04114',86);
insert into xk values('20220410110','C04114',84);
insert into xk values('20220410111','C04114',96);
insert into xk values('20220410112','C04114',90);
insert into xk values('20220410113','C04114',95);
insert into xk values('20220410114','C04114',62);
insert into xk values('20220410115','C04114',60);
insert into xk values('20220410116','C04114',65);
insert into xk values('20220410101','C04115',81);
insert into xk values('20220410102','C04115',97);
insert into xk values('20220410103','C04115',97);
insert into xk values('20220410104','C04115',78);
insert into xk values('20220410105','C04115',76);
insert into xk values('20220410110','C04115',66);
insert into xk values('20220410111','C04115',70);
insert into xk values('20220410112','C04115',62);
insert into xk values('20220410113','C04115',75);
insert into xk values('20220410114','C04115',76);
insert into xk values('20220410115','C04115',80);
insert into xk values('20220410116','C04115',98);
insert into xk values('20220522101','C05121',73);
insert into xk values('20220522102','C05121',77);
insert into xk values('20220522103','C05121',77);
insert into xk values('20220522104','C05121',61);
insert into xk values('20220522105','C05121',94);
insert into xk values('20220522106','C05121',78);
insert into xk values('20220522107','C05121',80);
insert into xk values('20220522108','C05121',63);
insert into xk values('20220522109','C05121',72);
insert into xk values('20220522110','C05121',92);
insert into xk values('20220522111','C05121',77);
insert into xk values('20220522112','C05121',62);
insert into xk values('20220522113','C05121',94);
insert into xk values('20220522114','C05121',74);
insert into xk values('20220522115','C05121',98);
insert into xk values('20220522116','C05121',65);
insert into xk values('20220522101','C05122',88);
insert into xk values('20220522102','C05122',61);
insert into xk values('20220522107','C05122',73);
insert into xk values('20220522108','C05122',65);
insert into xk values('20220522109','C05122',84);
insert into xk values('20220522110','C05122',83);
insert into xk values('20220522111','C05122',70);
insert into xk values('20220522112','C05122',97);
insert into xk values('20220522113','C05122',66);
insert into xk values('20220522114','C05122',91);
insert into xk values('20220522115','C05122',84);
insert into xk values('20220522116','C05122',63);
insert into xk values('20220522101','C05123',72);
insert into xk values('20220522102','C05123',92);
insert into xk values('20220522108','C05123',98);
insert into xk values('20220522109','C05123',62);
insert into xk values('20220522110','C05123',69);
insert into xk values('20220522111','C05123',70);
insert into xk values('20220522112','C05123',99);
insert into xk values('20220522113','C05123',73);
insert into xk values('20220522114','C05123',70);
insert into xk values('20220522115','C05123',62);
insert into xk values('20220522116','C05123',77);
insert into xk values('20220522101','C05124',94);
insert into xk values('20220522102','C05124',63);
insert into xk values('20220522103','C05124',66);
insert into xk values('20220522104','C05124',60);
insert into xk values('20220522105','C05124',100);
insert into xk values('20220522109','C05124',64);
insert into xk values('20220522110','C05124',98);
insert into xk values('20220522111','C05124',64);
insert into xk values('20220522112','C05124',93);
insert into xk values('20220522113','C05124',95);
insert into xk values('20220522114','C05124',65);
insert into xk values('20220522115','C05124',79);
insert into xk values('20220522116','C05124',68);
insert into xk values('20220610101','C06311',90);
insert into xk values('20220610102','C06311',73);
insert into xk values('20220610103','C06311',82);
insert into xk values('20220610104','C06311',94);
insert into xk values('20220610105','C06311',60);
insert into xk values('20220610106','C06311',65);
insert into xk values('20220610107','C06311',68);
insert into xk values('20220610108','C06311',93);
insert into xk values('20220610109','C06311',65);
insert into xk values('20220610110','C06311',70);
insert into xk values('20220610111','C06311',91);
insert into xk values('20220610112','C06311',76);
insert into xk values('20220610113','C06311',90);
insert into xk values('20220610114','C06311',71);
insert into xk values('20220610115','C06311',97);
insert into xk values('20220610116','C06311',100);
insert into xk values('20220610117','C06311',76);
insert into xk values('20220610118','C06311',72);
insert into xk values('20220610101','C06312',93);
insert into xk values('20220610102','C06312',75);
insert into xk values('20220610103','C06312',80);
insert into xk values('20220610104','C06312',80);
insert into xk values('20220610105','C06312',88);
insert into xk values('20220610106','C06312',85);
insert into xk values('20220610107','C06312',91);
insert into xk values('20220610108','C06312',82);
insert into xk values('20220610109','C06312',71);
insert into xk values('20220610110','C06312',71);
insert into xk values('20220610111','C06312',75);
insert into xk values('20220610112','C06312',70);
insert into xk values('20220610113','C06312',69);
insert into xk values('20220610114','C06312',72);
insert into xk values('20220610115','C06312',83);
insert into xk values('20220610116','C06312',61);
insert into xk values('20220610106','C06313',71);
insert into xk values('20220610107','C06313',90);
insert into xk values('20220610108','C06313',100);
insert into xk values('20220610109','C06313',82);
insert into xk values('20220610110','C06313',94);
insert into xk values('20220610111','C06313',89);
insert into xk values('20220610112','C06313',78);
insert into xk values('20220610113','C06313',68);
insert into xk values('20220610114','C06313',70);
insert into xk values('20220610115','C06313',61);
insert into xk values('20220610116','C06313',100);
insert into xk values('20220610117','C06313',90);
insert into xk values('20220610118','C06313',96);
insert into xk values('20220610101','C06314',72);
insert into xk values('20220610102','C06314',99);
insert into xk values('20220610103','C06314',80);
insert into xk values('20220610104','C06314',91);
insert into xk values('20220610105','C06314',66);
insert into xk values('20220610106','C06314',70);
insert into xk values('20220610107','C06314',67);
insert into xk values('20220610108','C06314',84);
insert into xk values('20220610109','C06314',61);
insert into xk values('20220610110','C06314',75);
insert into xk values('20220610111','C06314',64);
insert into xk values('20220610117','C06314',98);
insert into xk values('20220610118','C06314',67);
insert into xk values('20220610101','C06315',72);
insert into xk values('20220610102','C06315',87);
insert into xk values('20220610103','C06315',99);
insert into xk values('20220610104','C06315',68);
insert into xk values('20220610105','C06315',61);
insert into xk values('20220610106','C06315',70);
insert into xk values('20220610107','C06315',63);
insert into xk values('20220610108','C06315',78);
insert into xk values('20220610109','C06315',95);
insert into xk values('20220610110','C06315',75);
insert into xk values('20220610111','C06315',63);
insert into xk values('20220610112','C06315',98);
insert into xk values('20220610113','C06315',87);
insert into xk values('20220610114','C06315',85);
insert into xk values('20220610115','C06315',76);
insert into xk values('20220610116','C06315',97);
insert into xk values('20220610103','C06316',69);
insert into xk values('20220610104','C06316',71);
insert into xk values('20220610105','C06316',80);
insert into xk values('20220610106','C06316',70);
insert into xk values('20220610107','C06316',91);
insert into xk values('20220610108','C06316',90);
insert into xk values('20220610109','C06316',75);
insert into xk values('20220610110','C06316',66);
insert into xk values('20220610111','C06316',77);
insert into xk values('20220610112','C06316',79);
insert into xk values('20220610113','C06316',96);
insert into xk values('20220610114','C06316',85);
insert into xk values('20220610115','C06316',99);
insert into xk values('20220610116','C06316',69);
insert into xk values('20220610117','C06316',81);
insert into xk values('20220610118','C06316',72);
insert into xk values('20220610101','C06317',86);
insert into xk values('20220610102','C06317',78);
insert into xk values('20220610103','C06317',64);
insert into xk values('20220610104','C06317',76);
insert into xk values('20220610105','C06317',68);
insert into xk values('20220610111','C06317',61);
insert into xk values('20220610112','C06317',92);
insert into xk values('20220610113','C06317',85);
insert into xk values('20220610114','C06317',92);
insert into xk values('20220610115','C06317',85);
insert into xk values('20220610116','C06317',95);
insert into xk values('20220610117','C06317',62);
insert into xk values('20220610118','C06317',79);
insert into xk values('20220714101','C07111',80);
insert into xk values('20220714102','C07111',79);
insert into xk values('20220714103','C07111',63);
insert into xk values('20220714104','C07111',80);
insert into xk values('20220714105','C07111',85);
insert into xk values('20220714106','C07111',73);
insert into xk values('20220714107','C07111',96);
insert into xk values('20220714108','C07111',70);
insert into xk values('20220714109','C07111',89);
insert into xk values('20220714110','C07111',98);
insert into xk values('20220714111','C07111',92);
insert into xk values('20220714112','C07111',95);
insert into xk values('20220714113','C07111',72);
insert into xk values('20220714114','C07111',65);
insert into xk values('20220714115','C07111',96);
insert into xk values('20220714116','C07111',85);
insert into xk values('20220714101','C07112',71);
insert into xk values('20220714102','C07112',100);
insert into xk values('20220714103','C07112',82);
insert into xk values('20220714104','C07112',76);
insert into xk values('20220714105','C07112',87);
insert into xk values('20220714106','C07112',83);
insert into xk values('20220714107','C07112',69);
insert into xk values('20220714108','C07112',89);
insert into xk values('20220714109','C07112',61);
insert into xk values('20220714110','C07112',71);
insert into xk values('20220714111','C07112',89);
insert into xk values('20220714112','C07112',81);
insert into xk values('20220714113','C07112',93);
insert into xk values('20220714114','C07112',98);
insert into xk values('20220714103','C07113',91);
insert into xk values('20220714104','C07113',67);
insert into xk values('20220714105','C07113',80);
insert into xk values('20220714106','C07113',70);
insert into xk values('20220714107','C07113',93);
insert into xk values('20220714108','C07113',66);
insert into xk values('20220714109','C07113',70);
insert into xk values('20220714110','C07113',67);
insert into xk values('20220714111','C07113',86);
insert into xk values('20220714112','C07113',97);
insert into xk values('20220714113','C07113',97);
insert into xk values('20220714114','C07113',83);
insert into xk values('20220714115','C07113',65);
insert into xk values('20220714116','C07113',95);
insert into xk values('20220714101','C07114',84);
insert into xk values('20220714102','C07114',91);
insert into xk values('20220714103','C07114',94);
insert into xk values('20220714110','C07114',61);
insert into xk values('20220714111','C07114',79);
insert into xk values('20220714112','C07114',96);
insert into xk values('20220714113','C07114',65);
insert into xk values('20220714114','C07114',60);
insert into xk values('20220714115','C07114',67);
insert into xk values('20220714116','C07114',68);
insert into xk values('20220714101','C07115',76);
insert into xk values('20220714102','C07115',78);
insert into xk values('20220714103','C07115',98);
insert into xk values('20220714104','C07115',79);
insert into xk values('20220714105','C07115',62);
insert into xk values('20220714106','C07115',67);
insert into xk values('20220714107','C07115',76);
insert into xk values('20220714108','C07115',90);
insert into xk values('20220714109','C07115',77);
insert into xk values('20220714110','C07115',86);
insert into xk values('20220714111','C07115',63);
insert into xk values('20220714112','C07115',69);
insert into xk values('20220714106','C07116',63);
insert into xk values('20220714107','C07116',96);
insert into xk values('20220714108','C07116',80);
insert into xk values('20220714109','C07116',93);
insert into xk values('20220714110','C07116',66);
insert into xk values('20220714111','C07116',66);
insert into xk values('20220714112','C07116',90);
insert into xk values('20220714113','C07116',65);
insert into xk values('20220714114','C07116',60);
insert into xk values('20220714115','C07116',92);
insert into xk values('20220714116','C07116',69);
insert into xk values('20220820101','C08101',67);
insert into xk values('20220820102','C08101',91);
insert into xk values('20220820103','C08101',62);
insert into xk values('20220820104','C08101',72);
insert into xk values('20220820105','C08101',63);
insert into xk values('20220820106','C08101',77);
insert into xk values('20220820107','C08101',89);
insert into xk values('20220820108','C08101',84);
insert into xk values('20220820109','C08101',99);
insert into xk values('20220820110','C08101',82);
insert into xk values('20220820101','C08102',65);
insert into xk values('20220820102','C08102',88);
insert into xk values('20220820103','C08102',74);
insert into xk values('20220820104','C08102',60);
insert into xk values('20220820105','C08102',61);
insert into xk values('20220820106','C08102',60);
insert into xk values('20220820107','C08102',94);
insert into xk values('20220820108','C08102',83);
insert into xk values('20220820109','C08102',87);
insert into xk values('20220820110','C08102',88);
insert into xk values('20220820101','C08103',65);
insert into xk values('20220820102','C08103',61);
insert into xk values('20220820103','C08103',61);
insert into xk values('20220820104','C08103',82);
insert into xk values('20220820105','C08103',90);
insert into xk values('20220820106','C08103',100);
insert into xk values('20220820104','C08104',85);
insert into xk values('20220820105','C08104',93);
insert into xk values('20220820106','C08104',86);
insert into xk values('20220820107','C08104',87);
insert into xk values('20220820108','C08104',92);
insert into xk values('20220820109','C08104',65);
insert into xk values('20220820110','C08104',94);
insert into xk values('20220820101','C08105',91);
insert into xk values('20220820102','C08105',85);
insert into xk values('20220820103','C08105',88);
insert into xk values('20220820104','C08105',93);
insert into xk values('20220820105','C08105',77);
insert into xk values('20220820106','C08105',82);
insert into xk values('20220820107','C08105',63);
insert into xk values('20220820108','C08105',71);
insert into xk values('20220820109','C08105',96);
insert into xk values('20220820110','C08105',60);
insert into xk values('20220820101','C08106',66);
insert into xk values('20220820102','C08106',81);
insert into xk values('20220820103','C08106',95);
insert into xk values('20220820104','C08106',72);
insert into xk values('20220820105','C08106',68);
insert into xk values('20220820106','C08106',79);
insert into xk values('20220820107','C08106',71);
insert into xk values('20220820103','C08107',71);
insert into xk values('20220820104','C08107',78);
insert into xk values('20220820105','C08107',95);
insert into xk values('20220820106','C08107',69);
insert into xk values('20220820107','C08107',65);
insert into xk values('20220820108','C08107',94);
insert into xk values('20220820109','C08107',99);
insert into xk values('20220820110','C08107',80);
insert into xk values('20220930111','C09111',81);
insert into xk values('20220930112','C09111',97);
insert into xk values('20220930113','C09111',73);
insert into xk values('20220930114','C09111',79);
insert into xk values('20220930115','C09111',83);
insert into xk values('20220930116','C09111',63);
insert into xk values('20220930117','C09111',94);
insert into xk values('20220930118','C09111',82);
insert into xk values('20220930119','C09111',81);
insert into xk values('20220930120','C09111',90);
insert into xk values('20220930121','C09111',65);
insert into xk values('20220930122','C09111',95);
insert into xk values('20220930123','C09111',66);
insert into xk values('20220930124','C09111',94);
insert into xk values('20220930125','C09111',88);
insert into xk values('20220930126','C09111',97);
insert into xk values('20220930127','C09111',76);
insert into xk values('20220930128','C09111',74);
insert into xk values('20220930111','C09112',65);
insert into xk values('20220930112','C09112',79);
insert into xk values('20220930113','C09112',73);
insert into xk values('20220930114','C09112',67);
insert into xk values('20220930115','C09112',72);
insert into xk values('20220930116','C09112',86);
insert into xk values('20220930117','C09112',66);
insert into xk values('20220930118','C09112',67);
insert into xk values('20220930119','C09112',64);
insert into xk values('20220930120','C09112',90);
insert into xk values('20220930121','C09112',99);
insert into xk values('20220930122','C09112',79);
insert into xk values('20220930123','C09112',96);
insert into xk values('20220930124','C09112',91);
insert into xk values('20220930116','C09113',74);
insert into xk values('20220930117','C09113',79);
insert into xk values('20220930118','C09113',70);
insert into xk values('20220930119','C09113',80);
insert into xk values('20220930120','C09113',82);
insert into xk values('20220930121','C09113',94);
insert into xk values('20220930122','C09113',79);
insert into xk values('20220930123','C09113',88);
insert into xk values('20220930124','C09113',77);
insert into xk values('20220930125','C09113',64);
insert into xk values('20220930126','C09113',75);
insert into xk values('20220930127','C09113',100);
insert into xk values('20220930128','C09113',99);
insert into xk values('20221012101','C10121',92);
insert into xk values('20221012102','C10121',99);
insert into xk values('20221012103','C10121',81);
insert into xk values('20221012104','C10121',65);
insert into xk values('20221012105','C10121',99);
insert into xk values('20221012106','C10121',77);
insert into xk values('20221012107','C10121',81);
insert into xk values('20221012108','C10121',66);
insert into xk values('20221012109','C10121',77);
insert into xk values('20221012110','C10121',80);
insert into xk values('20221012111','C10121',61);
insert into xk values('20221012112','C10121',83);
insert into xk values('20221012113','C10121',86);
insert into xk values('20221012114','C10121',91);
insert into xk values('20221012115','C10121',90);
insert into xk values('20221012116','C10121',75);
insert into xk values('20221012117','C10121',90);
insert into xk values('20221012118','C10121',93);
insert into xk values('20221012119','C10121',82);
insert into xk values('20221012120','C10121',79);
insert into xk values('20221012121','C10121',97);
insert into xk values('20221012122','C10121',98);
insert into xk values('20221012123','C10121',64);
insert into xk values('20221012124','C10121',61);
insert into xk values('20221012125','C10121',63);
insert into xk values('20221012126','C10121',86);
insert into xk values('20221012127','C10121',70);
insert into xk values('20221012101','C10122',73);
insert into xk values('20221012102','C10122',85);
insert into xk values('20221012103','C10122',92);
insert into xk values('20221012104','C10122',78);
insert into xk values('20221012105','C10122',96);
insert into xk values('20221012106','C10122',85);
insert into xk values('20221012107','C10122',65);
insert into xk values('20221012108','C10122',78);
insert into xk values('20221012109','C10122',98);
insert into xk values('20221012110','C10122',98);
insert into xk values('20221012111','C10122',98);
insert into xk values('20221012112','C10122',68);
insert into xk values('20221012113','C10122',64);
insert into xk values('20221012114','C10122',75);
insert into xk values('20221012115','C10122',75);
insert into xk values('20221012116','C10122',67);
insert into xk values('20221012117','C10122',79);
insert into xk values('20221012118','C10122',71);
insert into xk values('20221012119','C10122',65);
insert into xk values('20221012105','C10123',89);
insert into xk values('20221012106','C10123',79);
insert into xk values('20221012107','C10123',71);
insert into xk values('20221012108','C10123',100);
insert into xk values('20221012109','C10123',98);
insert into xk values('20221012110','C10123',82);
insert into xk values('20221012111','C10123',72);
insert into xk values('20221012112','C10123',75);
insert into xk values('20221012113','C10123',92);
insert into xk values('20221012114','C10123',86);
insert into xk values('20221012115','C10123',82);
insert into xk values('20221012116','C10123',73);
insert into xk values('20221012117','C10123',95);
insert into xk values('20221012118','C10123',73);
insert into xk values('20221012119','C10123',76);
insert into xk values('20221012120','C10123',69);
insert into xk values('20221012121','C10123',62);
insert into xk values('20221012122','C10123',65);
insert into xk values('20221012123','C10123',69);
insert into xk values('20221012124','C10123',74);
insert into xk values('20221012125','C10123',67);
insert into xk values('20221012126','C10123',74);
insert into xk values('20221012127','C10123',63);
insert into xk values('20221012101','C10124',89);
insert into xk values('20221012102','C10124',84);
insert into xk values('20221012103','C10124',64);
insert into xk values('20221012104','C10124',91);
insert into xk values('20221012105','C10124',86);
insert into xk values('20221012106','C10124',77);
insert into xk values('20221012107','C10124',98);
insert into xk values('20221012108','C10124',77);
insert into xk values('20221012109','C10124',98);
insert into xk values('20221012110','C10124',82);
insert into xk values('20221012111','C10124',78);
insert into xk values('20221012112','C10124',89);
insert into xk values('20221012113','C10124',90);
insert into xk values('20221012114','C10124',95);
insert into xk values('20221012115','C10124',83);
insert into xk values('20221012116','C10124',68);
insert into xk values('20221012117','C10124',65);
insert into xk values('20221012118','C10124',73);
insert into xk values('20221012119','C10124',76);
insert into xk values('20221012120','C10124',89);
insert into xk values('20221012121','C10124',83);
insert into xk values('20221012122','C10124',74);
insert into xk values('20221012108','C10125',88);
insert into xk values('20221012109','C10125',99);
insert into xk values('20221012110','C10125',77);
insert into xk values('20221012111','C10125',67);
insert into xk values('20221012112','C10125',78);
insert into xk values('20221012113','C10125',68);
insert into xk values('20221012114','C10125',69);
insert into xk values('20221012115','C10125',91);
insert into xk values('20221012116','C10125',78);
insert into xk values('20221012117','C10125',82);
insert into xk values('20221012118','C10125',92);
insert into xk values('20221012119','C10125',83);
insert into xk values('20221012120','C10125',95);
insert into xk values('20221012121','C10125',68);
insert into xk values('20221012122','C10125',61);
insert into xk values('20221012123','C10125',96);
insert into xk values('20221012124','C10125',63);
insert into xk values('20221012125','C10125',91);
insert into xk values('20221012126','C10125',80);
insert into xk values('20221012127','C10125',78);
======================================================*/
3、查看表中的数据如下
mysql> select * from xk;
+-------------+--------+--------+
| s_id | c_id | score |
+-------------+--------+--------+
| 20220124001 | C01001 | 63.00 |
| 20220124001 | C01002 | 68.00 |
| 20220124001 | C01003 | 92.00 |
| 20220124001 | C01004 | 99.00 |
| 20220124001 | C01005 | 72.00 |
| 20220124001 | C01006 | 97.00 |
| 20220124002 | C01001 | 88.00 |
| 20220124002 | C01002 | 69.00 |
| 20220124002 | C01003 | 69.00 |
| 20220124002 | C01004 | 97.00 |
| 20220124002 | C01005 | 77.00 |
| 20220124002 | C01006 | 80.00 |
| 20220124003 | C01001 | 95.00 |
| 20220124003 | C01003 | 94.00 |
| 20220124003 | C01004 | 68.00 |
| 20220124003 | C01005 | 76.00 |
| 20220124003 | C01006 | 65.00 |
| 20220124004 | C01001 | 81.00 |
| 20220124004 | C01003 | 96.00 |
| 20220124004 | C01004 | 90.00 |
| 20220124004 | C01005 | 99.00 |
| 20220124004 | C01006 | 79.00 |
| 20220124005 | C01001 | 88.00 |
| 20220124005 | C01003 | 69.00 |
| 20220124005 | C01004 | 70.00 |
| 20220124005 | C01005 | 95.00 |
| 20220124005 | C01006 | 77.00 |
| 20220124006 | C01001 | 90.00 |
| 20220124006 | C01004 | 77.00 |
| 20220124006 | C01005 | 63.00 |
| 20220124007 | C01001 | 71.00 |
| 20220124007 | C01002 | 74.00 |
| 20220124007 | C01004 | 61.00 |
| 20220124007 | C01005 | 97.00 |
| 20220124008 | C01001 | 94.00 |
| 20220124008 | C01002 | 72.00 |
| 20220124008 | C01004 | 83.00 |
| 20220124008 | C01005 | 76.00 |
| 20220124009 | C01001 | 86.00 |
| 20220124009 | C01002 | 79.00 |
| 20220124009 | C01004 | 79.00 |
| 20220124009 | C01005 | 60.00 |
| 20220124010 | C01001 | 82.00 |
| 20220124010 | C01002 | 61.00 |
| 20220124010 | C01003 | 93.00 |
| 20220124010 | C01004 | 62.00 |
| 20220124010 | C01005 | 100.00 |
| 20220124010 | C01006 | 80.00 |
| 20220124011 | C01001 | 96.00 |
| 20220124011 | C01002 | 63.00 |
| 20220124011 | C01003 | 72.00 |
| 20220124011 | C01004 | 66.00 |
| 20220124011 | C01005 | 81.00 |
| 20220124011 | C01006 | 95.00 |
| 20220124012 | C01001 | 100.00 |
| 20220124012 | C01002 | 93.00 |
| 20220124012 | C01003 | 99.00 |
| 20220124012 | C01004 | 87.00 |
| 20220124012 | C01005 | 97.00 |
| 20220124012 | C01006 | 83.00 |
| 20220124013 | C01001 | 92.00 |
| 20220124013 | C01002 | 97.00 |
| 20220124013 | C01003 | 98.00 |
| 20220124013 | C01004 | 88.00 |
| 20220124013 | C01005 | 97.00 |
| 20220124013 | C01006 | 88.00 |
| 20220214001 | C02101 | 80.00 |
| 20220214001 | C02102 | 80.00 |
| 20220214001 | C02103 | 97.00 |
| 20220214001 | C02104 | 96.00 |
| 20220214001 | C02105 | 82.00 |
| 20220214002 | C02101 | 63.00 |
| 20220214002 | C02102 | 67.00 |
| 20220214002 | C02103 | 74.00 |
| 20220214002 | C02104 | 79.00 |
| 20220214002 | C02105 | 65.00 |
| 20220214003 | C02101 | 72.00 |
| 20220214003 | C02102 | 96.00 |
| 20220214003 | C02103 | 94.00 |
| 20220214003 | C02104 | 93.00 |
| 20220214003 | C02105 | 67.00 |
| 20220214004 | C02101 | 77.00 |
| 20220214004 | C02103 | 65.00 |
| 20220214004 | C02104 | 73.00 |
| 20220214004 | C02105 | 81.00 |
| 20220214005 | C02101 | 89.00 |
| 20220214005 | C02103 | 76.00 |
| 20220214005 | C02104 | 67.00 |
| 20220214006 | C02101 | 74.00 |
| 20220214006 | C02103 | 63.00 |
| 20220214006 | C02104 | 85.00 |
| 20220214007 | C02101 | 65.00 |
| 20220214007 | C02103 | 92.00 |
| 20220214007 | C02104 | 62.00 |
| 20220214008 | C02101 | 70.00 |
| 20220214008 | C02103 | 86.00 |
| 20220214008 | C02104 | 70.00 |
| 20220214009 | C02101 | 90.00 |
| 20220214009 | C02102 | 71.00 |
| 20220214009 | C02103 | 76.00 |
| 20220214009 | C02104 | 84.00 |
| 20220214009 | C02105 | 77.00 |
| 20220214010 | C02101 | 99.00 |
| 20220214010 | C02102 | 80.00 |
| 20220214010 | C02103 | 62.00 |
| 20220214010 | C02104 | 73.00 |
| 20220214010 | C02105 | 75.00 |
| 20220214011 | C02101 | 88.00 |
| 20220214011 | C02102 | 61.00 |
| 20220214011 | C02103 | 72.00 |
| 20220214011 | C02104 | 100.00 |
| 20220214011 | C02105 | 87.00 |
| 20220214012 | C02101 | 95.00 |
| 20220214012 | C02102 | 64.00 |
| 20220214012 | C02104 | 89.00 |
| 20220214012 | C02105 | 70.00 |
| 20220214013 | C02101 | 93.00 |
| 20220214013 | C02102 | 69.00 |
| 20220214013 | C02104 | 73.00 |
| 20220214013 | C02105 | 82.00 |
| 20220214014 | C02101 | 68.00 |
| 20220214014 | C02102 | 80.00 |
| 20220214014 | C02104 | 86.00 |
| 20220214014 | C02105 | 75.00 |
| 20220325101 | C03201 | 83.00 |
| 20220325101 | C03202 | 83.00 |
| 20220325101 | C03203 | 74.00 |
| 20220325102 | C03201 | 90.00 |
| 20220325102 | C03202 | 84.00 |
| 20220325102 | C03203 | 67.00 |
| 20220325103 | C03201 | 65.00 |
| 20220325103 | C03202 | 77.00 |
| 20220325103 | C03203 | 66.00 |
| 20220325104 | C03201 | 86.00 |
| 20220325104 | C03202 | 87.00 |
| 20220325104 | C03203 | 81.00 |
| 20220325105 | C03201 | 68.00 |
| 20220325105 | C03202 | 70.00 |
| 20220325105 | C03203 | 94.00 |
| 20220325106 | C03201 | 65.00 |
| 20220325106 | C03202 | 87.00 |
| 20220325107 | C03201 | 86.00 |
| 20220325107 | C03202 | 82.00 |
| 20220325108 | C03201 | 72.00 |
| 20220325108 | C03202 | 84.00 |
| 20220325109 | C03201 | 91.00 |
| 20220325109 | C03202 | 99.00 |
| 20220325110 | C03201 | 90.00 |
| 20220325110 | C03202 | 87.00 |
| 20220325110 | C03203 | 64.00 |
| 20220325111 | C03201 | 92.00 |
| 20220325111 | C03202 | 76.00 |
| 20220325111 | C03203 | 97.00 |
| 20220325112 | C03201 | 96.00 |
| 20220325112 | C03202 | 94.00 |
| 20220325112 | C03203 | 68.00 |
| 20220325113 | C03201 | 84.00 |
| 20220325113 | C03202 | 66.00 |
| 20220325113 | C03203 | 69.00 |
| 20220325114 | C03201 | 94.00 |
| 20220325114 | C03202 | 99.00 |
| 20220325114 | C03203 | 67.00 |
| 20220410101 | C04111 | 68.00 |
| 20220410101 | C04112 | 97.00 |
| 20220410101 | C04113 | 83.00 |
| 20220410101 | C04114 | 100.00 |
| 20220410101 | C04115 | 81.00 |
| 20220410102 | C04111 | 62.00 |
| 20220410102 | C04112 | 78.00 |
| 20220410102 | C04113 | 72.00 |
| 20220410102 | C04114 | 72.00 |
| 20220410102 | C04115 | 97.00 |
| 20220410103 | C04111 | 64.00 |
| 20220410103 | C04112 | 82.00 |
| 20220410103 | C04113 | 62.00 |
| 20220410103 | C04115 | 97.00 |
| 20220410104 | C04111 | 64.00 |
| 20220410104 | C04112 | 75.00 |
| 20220410104 | C04115 | 78.00 |
| 20220410105 | C04111 | 92.00 |
| 20220410105 | C04112 | 100.00 |
| 20220410105 | C04115 | 76.00 |
| 20220410106 | C04111 | 75.00 |
| 20220410106 | C04112 | 73.00 |
| 20220410107 | C04111 | 63.00 |
| 20220410107 | C04112 | 65.00 |
| 20220410107 | C04114 | 97.00 |
| 20220410108 | C04111 | 61.00 |
| 20220410108 | C04112 | 96.00 |
| 20220410108 | C04114 | 63.00 |
| 20220410109 | C04111 | 89.00 |
| 20220410109 | C04112 | 96.00 |
| 20220410109 | C04113 | 70.00 |
| 20220410109 | C04114 | 86.00 |
| 20220410110 | C04111 | 81.00 |
| 20220410110 | C04112 | 70.00 |
| 20220410110 | C04113 | 61.00 |
| 20220410110 | C04114 | 84.00 |
| 20220410110 | C04115 | 66.00 |
| 20220410111 | C04111 | 85.00 |
| 20220410111 | C04112 | 69.00 |
| 20220410111 | C04113 | 84.00 |
| 20220410111 | C04114 | 96.00 |
| 20220410111 | C04115 | 70.00 |
| 20220410112 | C04111 | 72.00 |
| 20220410112 | C04112 | 62.00 |
| 20220410112 | C04113 | 98.00 |
| 20220410112 | C04114 | 90.00 |
| 20220410112 | C04115 | 62.00 |
| 20220410113 | C04111 | 61.00 |
| 20220410113 | C04112 | 98.00 |
| 20220410113 | C04113 | 75.00 |
| 20220410113 | C04114 | 95.00 |
| 20220410113 | C04115 | 75.00 |
| 20220410114 | C04111 | 89.00 |
| 20220410114 | C04112 | 98.00 |
| 20220410114 | C04113 | 71.00 |
| 20220410114 | C04114 | 62.00 |
| 20220410114 | C04115 | 76.00 |
| 20220410115 | C04111 | 72.00 |
| 20220410115 | C04112 | 92.00 |
| 20220410115 | C04113 | 71.00 |
| 20220410115 | C04114 | 60.00 |
| 20220410115 | C04115 | 80.00 |
| 20220410116 | C04111 | 74.00 |
| 20220410116 | C04112 | 95.00 |
| 20220410116 | C04113 | 63.00 |
| 20220410116 | C04114 | 65.00 |
| 20220410116 | C04115 | 98.00 |
| 20220522101 | C05121 | 73.00 |
| 20220522101 | C05122 | 88.00 |
| 20220522101 | C05123 | 72.00 |
| 20220522101 | C05124 | 94.00 |
| 20220522102 | C05121 | 77.00 |
| 20220522102 | C05122 | 61.00 |
| 20220522102 | C05123 | 92.00 |
| 20220522102 | C05124 | 63.00 |
| 20220522103 | C05121 | 77.00 |
| 20220522103 | C05124 | 66.00 |
| 20220522104 | C05121 | 61.00 |
| 20220522104 | C05124 | 60.00 |
| 20220522105 | C05121 | 94.00 |
| 20220522105 | C05124 | 100.00 |
| 20220522106 | C05121 | 78.00 |
| 20220522107 | C05121 | 80.00 |
| 20220522107 | C05122 | 73.00 |
| 20220522108 | C05121 | 63.00 |
| 20220522108 | C05122 | 65.00 |
| 20220522108 | C05123 | 98.00 |
| 20220522109 | C05121 | 72.00 |
| 20220522109 | C05122 | 84.00 |
| 20220522109 | C05123 | 62.00 |
| 20220522109 | C05124 | 64.00 |
| 20220522110 | C05121 | 92.00 |
| 20220522110 | C05122 | 83.00 |
| 20220522110 | C05123 | 69.00 |
| 20220522110 | C05124 | 98.00 |
| 20220522111 | C05121 | 77.00 |
| 20220522111 | C05122 | 70.00 |
| 20220522111 | C05123 | 70.00 |
| 20220522111 | C05124 | 64.00 |
| 20220522112 | C05121 | 62.00 |
| 20220522112 | C05122 | 97.00 |
| 20220522112 | C05123 | 99.00 |
| 20220522112 | C05124 | 93.00 |
| 20220522113 | C05121 | 94.00 |
| 20220522113 | C05122 | 66.00 |
| 20220522113 | C05123 | 73.00 |
| 20220522113 | C05124 | 95.00 |
| 20220522114 | C05121 | 74.00 |
| 20220522114 | C05122 | 91.00 |
| 20220522114 | C05123 | 70.00 |
| 20220522114 | C05124 | 65.00 |
| 20220522115 | C05121 | 98.00 |
| 20220522115 | C05122 | 84.00 |
| 20220522115 | C05123 | 62.00 |
| 20220522115 | C05124 | 79.00 |
| 20220522116 | C05121 | 65.00 |
| 20220522116 | C05122 | 63.00 |
| 20220522116 | C05123 | 77.00 |
| 20220522116 | C05124 | 68.00 |
| 20220610101 | C06311 | 90.00 |
| 20220610101 | C06312 | 93.00 |
| 20220610101 | C06314 | 72.00 |
| 20220610101 | C06315 | 72.00 |
| 20220610101 | C06317 | 86.00 |
| 20220610102 | C06311 | 73.00 |
| 20220610102 | C06312 | 75.00 |
| 20220610102 | C06314 | 99.00 |
| 20220610102 | C06315 | 87.00 |
| 20220610102 | C06317 | 78.00 |
| 20220610103 | C06311 | 82.00 |
| 20220610103 | C06312 | 80.00 |
| 20220610103 | C06314 | 80.00 |
| 20220610103 | C06315 | 99.00 |
| 20220610103 | C06316 | 69.00 |
| 20220610103 | C06317 | 64.00 |
| 20220610104 | C06311 | 94.00 |
| 20220610104 | C06312 | 80.00 |
| 20220610104 | C06314 | 91.00 |
| 20220610104 | C06315 | 68.00 |
| 20220610104 | C06316 | 71.00 |
| 20220610104 | C06317 | 76.00 |
| 20220610105 | C06311 | 60.00 |
| 20220610105 | C06312 | 88.00 |
| 20220610105 | C06314 | 66.00 |
| 20220610105 | C06315 | 61.00 |
| 20220610105 | C06316 | 80.00 |
| 20220610105 | C06317 | 68.00 |
| 20220610106 | C06311 | 65.00 |
| 20220610106 | C06312 | 85.00 |
| 20220610106 | C06313 | 71.00 |
| 20220610106 | C06314 | 70.00 |
| 20220610106 | C06315 | 70.00 |
| 20220610106 | C06316 | 70.00 |
| 20220610107 | C06311 | 68.00 |
| 20220610107 | C06312 | 91.00 |
| 20220610107 | C06313 | 90.00 |
| 20220610107 | C06314 | 67.00 |
| 20220610107 | C06315 | 63.00 |
| 20220610107 | C06316 | 91.00 |
| 20220610108 | C06311 | 93.00 |
| 20220610108 | C06312 | 82.00 |
| 20220610108 | C06313 | 100.00 |
| 20220610108 | C06314 | 84.00 |
| 20220610108 | C06315 | 78.00 |
| 20220610108 | C06316 | 90.00 |
| 20220610109 | C06311 | 65.00 |
| 20220610109 | C06312 | 71.00 |
| 20220610109 | C06313 | 82.00 |
| 20220610109 | C06314 | 61.00 |
| 20220610109 | C06315 | 95.00 |
| 20220610109 | C06316 | 75.00 |
| 20220610110 | C06311 | 70.00 |
| 20220610110 | C06312 | 71.00 |
| 20220610110 | C06313 | 94.00 |
| 20220610110 | C06314 | 75.00 |
| 20220610110 | C06315 | 75.00 |
| 20220610110 | C06316 | 66.00 |
| 20220610111 | C06311 | 91.00 |
| 20220610111 | C06312 | 75.00 |
| 20220610111 | C06313 | 89.00 |
| 20220610111 | C06314 | 64.00 |
| 20220610111 | C06315 | 63.00 |
| 20220610111 | C06316 | 77.00 |
| 20220610111 | C06317 | 61.00 |
| 20220610112 | C06311 | 76.00 |
| 20220610112 | C06312 | 70.00 |
| 20220610112 | C06313 | 78.00 |
| 20220610112 | C06315 | 98.00 |
| 20220610112 | C06316 | 79.00 |
| 20220610112 | C06317 | 92.00 |
| 20220610113 | C06311 | 90.00 |
| 20220610113 | C06312 | 69.00 |
| 20220610113 | C06313 | 68.00 |
| 20220610113 | C06315 | 87.00 |
| 20220610113 | C06316 | 96.00 |
| 20220610113 | C06317 | 85.00 |
| 20220610114 | C06311 | 71.00 |
| 20220610114 | C06312 | 72.00 |
| 20220610114 | C06313 | 70.00 |
| 20220610114 | C06315 | 85.00 |
| 20220610114 | C06316 | 85.00 |
| 20220610114 | C06317 | 92.00 |
| 20220610115 | C06311 | 97.00 |
| 20220610115 | C06312 | 83.00 |
| 20220610115 | C06313 | 61.00 |
| 20220610115 | C06315 | 76.00 |
| 20220610115 | C06316 | 99.00 |
| 20220610115 | C06317 | 85.00 |
| 20220610116 | C06311 | 100.00 |
| 20220610116 | C06312 | 61.00 |
| 20220610116 | C06313 | 100.00 |
| 20220610116 | C06315 | 97.00 |
| 20220610116 | C06316 | 69.00 |
| 20220610116 | C06317 | 95.00 |
| 20220610117 | C06311 | 76.00 |
| 20220610117 | C06313 | 90.00 |
| 20220610117 | C06314 | 98.00 |
| 20220610117 | C06316 | 81.00 |
| 20220610117 | C06317 | 62.00 |
| 20220610118 | C06311 | 72.00 |
| 20220610118 | C06313 | 96.00 |
| 20220610118 | C06314 | 67.00 |
| 20220610118 | C06316 | 72.00 |
| 20220610118 | C06317 | 79.00 |
| 20220714101 | C07111 | 80.00 |
| 20220714101 | C07112 | 71.00 |
| 20220714101 | C07114 | 84.00 |
| 20220714101 | C07115 | 76.00 |
| 20220714102 | C07111 | 79.00 |
| 20220714102 | C07112 | 100.00 |
| 20220714102 | C07114 | 91.00 |
| 20220714102 | C07115 | 78.00 |
| 20220714103 | C07111 | 63.00 |
| 20220714103 | C07112 | 82.00 |
| 20220714103 | C07113 | 91.00 |
| 20220714103 | C07114 | 94.00 |
| 20220714103 | C07115 | 98.00 |
| 20220714104 | C07111 | 80.00 |
| 20220714104 | C07112 | 76.00 |
| 20220714104 | C07113 | 67.00 |
| 20220714104 | C07115 | 79.00 |
| 20220714105 | C07111 | 85.00 |
| 20220714105 | C07112 | 87.00 |
| 20220714105 | C07113 | 80.00 |
| 20220714105 | C07115 | 62.00 |
| 20220714106 | C07111 | 73.00 |
| 20220714106 | C07112 | 83.00 |
| 20220714106 | C07113 | 70.00 |
| 20220714106 | C07115 | 67.00 |
| 20220714106 | C07116 | 63.00 |
| 20220714107 | C07111 | 96.00 |
| 20220714107 | C07112 | 69.00 |
| 20220714107 | C07113 | 93.00 |
| 20220714107 | C07115 | 76.00 |
| 20220714107 | C07116 | 96.00 |
| 20220714108 | C07111 | 70.00 |
| 20220714108 | C07112 | 89.00 |
| 20220714108 | C07113 | 66.00 |
| 20220714108 | C07115 | 90.00 |
| 20220714108 | C07116 | 80.00 |
| 20220714109 | C07111 | 89.00 |
| 20220714109 | C07112 | 61.00 |
| 20220714109 | C07113 | 70.00 |
| 20220714109 | C07115 | 77.00 |
| 20220714109 | C07116 | 93.00 |
| 20220714110 | C07111 | 98.00 |
| 20220714110 | C07112 | 71.00 |
| 20220714110 | C07113 | 67.00 |
| 20220714110 | C07114 | 61.00 |
| 20220714110 | C07115 | 86.00 |
| 20220714110 | C07116 | 66.00 |
| 20220714111 | C07111 | 92.00 |
| 20220714111 | C07112 | 89.00 |
| 20220714111 | C07113 | 86.00 |
| 20220714111 | C07114 | 79.00 |
| 20220714111 | C07115 | 63.00 |
| 20220714111 | C07116 | 66.00 |
| 20220714112 | C07111 | 95.00 |
| 20220714112 | C07112 | 81.00 |
| 20220714112 | C07113 | 97.00 |
| 20220714112 | C07114 | 96.00 |
| 20220714112 | C07115 | 69.00 |
| 20220714112 | C07116 | 90.00 |
| 20220714113 | C07111 | 72.00 |
| 20220714113 | C07112 | 93.00 |
| 20220714113 | C07113 | 97.00 |
| 20220714113 | C07114 | 65.00 |
| 20220714113 | C07116 | 65.00 |
| 20220714114 | C07111 | 65.00 |
| 20220714114 | C07112 | 98.00 |
| 20220714114 | C07113 | 83.00 |
| 20220714114 | C07114 | 60.00 |
| 20220714114 | C07116 | 60.00 |
| 20220714115 | C07111 | 96.00 |
| 20220714115 | C07113 | 65.00 |
| 20220714115 | C07114 | 67.00 |
| 20220714115 | C07116 | 92.00 |
| 20220714116 | C07111 | 85.00 |
| 20220714116 | C07113 | 95.00 |
| 20220714116 | C07114 | 68.00 |
| 20220714116 | C07116 | 69.00 |
| 20220820101 | C08101 | 67.00 |
| 20220820101 | C08102 | 65.00 |
| 20220820101 | C08103 | 65.00 |
| 20220820101 | C08105 | 91.00 |
| 20220820101 | C08106 | 66.00 |
| 20220820102 | C08101 | 91.00 |
| 20220820102 | C08102 | 88.00 |
| 20220820102 | C08103 | 61.00 |
| 20220820102 | C08105 | 85.00 |
| 20220820102 | C08106 | 81.00 |
| 20220820103 | C08101 | 62.00 |
| 20220820103 | C08102 | 74.00 |
| 20220820103 | C08103 | 61.00 |
| 20220820103 | C08105 | 88.00 |
| 20220820103 | C08106 | 95.00 |
| 20220820103 | C08107 | 71.00 |
| 20220820104 | C08101 | 72.00 |
| 20220820104 | C08102 | 60.00 |
| 20220820104 | C08103 | 82.00 |
| 20220820104 | C08104 | 85.00 |
| 20220820104 | C08105 | 93.00 |
| 20220820104 | C08106 | 72.00 |
| 20220820104 | C08107 | 78.00 |
| 20220820105 | C08101 | 63.00 |
| 20220820105 | C08102 | 61.00 |
| 20220820105 | C08103 | 90.00 |
| 20220820105 | C08104 | 93.00 |
| 20220820105 | C08105 | 77.00 |
| 20220820105 | C08106 | 68.00 |
| 20220820105 | C08107 | 95.00 |
| 20220820106 | C08101 | 77.00 |
| 20220820106 | C08102 | 60.00 |
| 20220820106 | C08103 | 100.00 |
| 20220820106 | C08104 | 86.00 |
| 20220820106 | C08105 | 82.00 |
| 20220820106 | C08106 | 79.00 |
| 20220820106 | C08107 | 69.00 |
| 20220820107 | C08101 | 89.00 |
| 20220820107 | C08102 | 94.00 |
| 20220820107 | C08104 | 87.00 |
| 20220820107 | C08105 | 63.00 |
| 20220820107 | C08106 | 71.00 |
| 20220820107 | C08107 | 65.00 |
| 20220820108 | C08101 | 84.00 |
| 20220820108 | C08102 | 83.00 |
| 20220820108 | C08104 | 92.00 |
| 20220820108 | C08105 | 71.00 |
| 20220820108 | C08107 | 94.00 |
| 20220820109 | C08101 | 99.00 |
| 20220820109 | C08102 | 87.00 |
| 20220820109 | C08104 | 65.00 |
| 20220820109 | C08105 | 96.00 |
| 20220820109 | C08107 | 99.00 |
| 20220820110 | C08101 | 82.00 |
| 20220820110 | C08102 | 88.00 |
| 20220820110 | C08104 | 94.00 |
| 20220820110 | C08105 | 60.00 |
| 20220820110 | C08107 | 80.00 |
| 20220930111 | C09111 | 81.00 |
| 20220930111 | C09112 | 65.00 |
| 20220930112 | C09111 | 97.00 |
| 20220930112 | C09112 | 79.00 |
| 20220930113 | C09111 | 73.00 |
| 20220930113 | C09112 | 73.00 |
| 20220930114 | C09111 | 79.00 |
| 20220930114 | C09112 | 67.00 |
| 20220930115 | C09111 | 83.00 |
| 20220930115 | C09112 | 72.00 |
| 20220930116 | C09111 | 63.00 |
| 20220930116 | C09112 | 86.00 |
| 20220930116 | C09113 | 74.00 |
| 20220930117 | C09111 | 94.00 |
| 20220930117 | C09112 | 66.00 |
| 20220930117 | C09113 | 79.00 |
| 20220930118 | C09111 | 82.00 |
| 20220930118 | C09112 | 67.00 |
| 20220930118 | C09113 | 70.00 |
| 20220930119 | C09111 | 81.00 |
| 20220930119 | C09112 | 64.00 |
| 20220930119 | C09113 | 80.00 |
| 20220930120 | C09111 | 90.00 |
| 20220930120 | C09112 | 90.00 |
| 20220930120 | C09113 | 82.00 |
| 20220930121 | C09111 | 65.00 |
| 20220930121 | C09112 | 99.00 |
| 20220930121 | C09113 | 94.00 |
| 20220930122 | C09111 | 95.00 |
| 20220930122 | C09112 | 79.00 |
| 20220930122 | C09113 | 79.00 |
| 20220930123 | C09111 | 66.00 |
| 20220930123 | C09112 | 96.00 |
| 20220930123 | C09113 | 88.00 |
| 20220930124 | C09111 | 94.00 |
| 20220930124 | C09112 | 91.00 |
| 20220930124 | C09113 | 77.00 |
| 20220930125 | C09111 | 88.00 |
| 20220930125 | C09113 | 64.00 |
| 20220930126 | C09111 | 97.00 |
| 20220930126 | C09113 | 75.00 |
| 20220930127 | C09111 | 76.00 |
| 20220930127 | C09113 | 100.00 |
| 20220930128 | C09111 | 74.00 |
| 20220930128 | C09113 | 99.00 |
| 20221012101 | C10121 | 92.00 |
| 20221012101 | C10122 | 73.00 |
| 20221012101 | C10124 | 89.00 |
| 20221012102 | C10121 | 99.00 |
| 20221012102 | C10122 | 85.00 |
| 20221012102 | C10124 | 84.00 |
| 20221012103 | C10121 | 81.00 |
| 20221012103 | C10122 | 92.00 |
| 20221012103 | C10124 | 64.00 |
| 20221012104 | C10121 | 65.00 |
| 20221012104 | C10122 | 78.00 |
| 20221012104 | C10124 | 91.00 |
| 20221012105 | C10121 | 99.00 |
| 20221012105 | C10122 | 96.00 |
| 20221012105 | C10123 | 89.00 |
| 20221012105 | C10124 | 86.00 |
| 20221012106 | C10121 | 77.00 |
| 20221012106 | C10122 | 85.00 |
| 20221012106 | C10123 | 79.00 |
| 20221012106 | C10124 | 77.00 |
| 20221012107 | C10121 | 81.00 |
| 20221012107 | C10122 | 65.00 |
| 20221012107 | C10123 | 71.00 |
| 20221012107 | C10124 | 98.00 |
| 20221012108 | C10121 | 66.00 |
| 20221012108 | C10122 | 78.00 |
| 20221012108 | C10123 | 100.00 |
| 20221012108 | C10124 | 77.00 |
| 20221012108 | C10125 | 88.00 |
| 20221012109 | C10121 | 77.00 |
| 20221012109 | C10122 | 98.00 |
| 20221012109 | C10123 | 98.00 |
| 20221012109 | C10124 | 98.00 |
| 20221012109 | C10125 | 99.00 |
| 20221012110 | C10121 | 80.00 |
| 20221012110 | C10122 | 98.00 |
| 20221012110 | C10123 | 82.00 |
| 20221012110 | C10124 | 82.00 |
| 20221012110 | C10125 | 77.00 |
| 20221012111 | C10121 | 61.00 |
| 20221012111 | C10122 | 98.00 |
| 20221012111 | C10123 | 72.00 |
| 20221012111 | C10124 | 78.00 |
| 20221012111 | C10125 | 67.00 |
| 20221012112 | C10121 | 83.00 |
| 20221012112 | C10122 | 68.00 |
| 20221012112 | C10123 | 75.00 |
| 20221012112 | C10124 | 89.00 |
| 20221012112 | C10125 | 78.00 |
| 20221012113 | C10121 | 86.00 |
| 20221012113 | C10122 | 64.00 |
| 20221012113 | C10123 | 92.00 |
| 20221012113 | C10124 | 90.00 |
| 20221012113 | C10125 | 68.00 |
| 20221012114 | C10121 | 91.00 |
| 20221012114 | C10122 | 75.00 |
| 20221012114 | C10123 | 86.00 |
| 20221012114 | C10124 | 95.00 |
| 20221012114 | C10125 | 69.00 |
| 20221012115 | C10121 | 90.00 |
| 20221012115 | C10122 | 75.00 |
| 20221012115 | C10123 | 82.00 |
| 20221012115 | C10124 | 83.00 |
| 20221012115 | C10125 | 91.00 |
| 20221012116 | C10121 | 75.00 |
| 20221012116 | C10122 | 67.00 |
| 20221012116 | C10123 | 73.00 |
| 20221012116 | C10124 | 68.00 |
| 20221012116 | C10125 | 78.00 |
| 20221012117 | C10121 | 90.00 |
| 20221012117 | C10122 | 79.00 |
| 20221012117 | C10123 | 95.00 |
| 20221012117 | C10124 | 65.00 |
| 20221012117 | C10125 | 82.00 |
| 20221012118 | C10121 | 93.00 |
| 20221012118 | C10122 | 71.00 |
| 20221012118 | C10123 | 73.00 |
| 20221012118 | C10124 | 73.00 |
| 20221012118 | C10125 | 92.00 |
| 20221012119 | C10121 | 82.00 |
| 20221012119 | C10122 | 65.00 |
| 20221012119 | C10123 | 76.00 |
| 20221012119 | C10124 | 76.00 |
| 20221012119 | C10125 | 83.00 |
| 20221012120 | C10121 | 79.00 |
| 20221012120 | C10123 | 69.00 |
| 20221012120 | C10124 | 89.00 |
| 20221012120 | C10125 | 95.00 |
| 20221012121 | C10121 | 97.00 |
| 20221012121 | C10123 | 62.00 |
| 20221012121 | C10124 | 83.00 |
| 20221012121 | C10125 | 68.00 |
| 20221012122 | C10121 | 98.00 |
| 20221012122 | C10123 | 65.00 |
| 20221012122 | C10124 | 74.00 |
| 20221012122 | C10125 | 61.00 |
| 20221012123 | C10121 | 64.00 |
| 20221012123 | C10123 | 69.00 |
| 20221012123 | C10125 | 96.00 |
| 20221012124 | C10121 | 61.00 |
| 20221012124 | C10123 | 74.00 |
| 20221012124 | C10125 | 63.00 |
| 20221012125 | C10121 | 63.00 |
| 20221012125 | C10123 | 67.00 |
| 20221012125 | C10125 | 91.00 |
| 20221012126 | C10121 | 86.00 |
| 20221012126 | C10123 | 74.00 |
| 20221012126 | C10125 | 80.00 |
| 20221012127 | C10121 | 70.00 |
| 20221012127 | C10123 | 63.00 |
| 20221012127 | C10125 | 78.00 |
+-------------+--------+--------+
677 rows in set (0.00 sec)
本文转载自: https://blog.csdn.net/weixin_44377973/article/details/134607856
版权归原作者 睿思达DBA_WGX 所有， 如有侵权，请联系我们删除。
版权归原作者 睿思达DBA_WGX 所有， 如有侵权，请联系我们删除。