【学生成绩管理】数据库示例数据（MySQL代码）
目录
- 【学生成绩管理】数据库示例数据（MySQL代码）
- 一、创建数据库
- 二、创建dept（学院）表
- 1、创建表结构
- 2、添加示例数据
- 3、查看表中数据
- 三、创建stu（学生）表
- 1、创建表结构
- 2、添加示例数据
- 3、查看表中数据
- 四、创建course（课程）表
- 1、创建表结构
- 2、添加示例数据
- 3、查看表中数据
- 四、创建xk（选课）表
- 1、创建表结构
- 2、添加示例数据
- 3、查看表中的数据如下
一、创建数据库
/* ========================================================== 代码如下：drop database if exists mydb;create database mydb;use mydb;======================================================*/mysql> drop database if exists mydb;Query OK, 5 rows affected (0.03 sec)mysql> create database mydb;Query OK, 1 row 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> create table dept(-> dept_id char(3) primary key,-> dept_name char(50),-> phone char(20),-> address varchar(20)-> );Query OK, 0 rows 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|+---------+--------------+--------------+----------------+10 rows in set (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> 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)-> );Query OK, 0 rows 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 |+-------------+--------+--------+------------+-------------+---------+162 rows in set (0.00 sec)四、创建course（课程）表
1、创建表结构
/* ========================================================== 代码如下：create table course(c_id char(6) primary key,c_name char(50),credit decimal(4,2));======================================================*/mysql> create table course(-> c_id char(6) primary key,-> c_name char(50),-> credit decimal(4,2)-> );Query OK, 0 rows 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 |+--------+----------------+--------+51 rows in set (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> 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)-> );Query OK, 0 rows 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)