【学生成绩管理】数据库示例数据（MySQL代码）_百度小程序

【学生成绩管理】数据库示例数据（MySQL代码）

一、创建数据库

/* ======================================================
==== 代码如下：
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)

上一篇：揭秘Spring框架：模块装配的奥秘与实战技巧【Spring|Java】

下一篇：MySQL什么情况下会死锁，发生了死锁怎么处理呢？

【学生成绩管理】数据库示例数据（MySQL代码）

目录

一、创建数据库

二、创建dept（学院）表

1、创建表结构

2、添加示例数据

3、查看表中数据

三、创建stu（学生）表

1、创建表结构

2、添加示例数据

3、查看表中数据

四、创建course（课程）表

1、创建表结构

2、添加示例数据

3、查看表中数据

四、创建xk（选课）表

1、创建表结构

2、添加示例数据

3、查看表中的数据如下