泉州哪个公司网站做的好,网站设计制作发展趋势,宁波网站建设制作网络公司,云空间网站开发【学生成绩管理】数据库示例数据#xff08;MySQL代码#xff09; 目录 【学生成绩管理】数据库示例数据#xff08;MySQL代码#xff09;一、创建数据库二、创建dept#xff08;学院#xff09;表1、创建表结构2、添加示例数据3、查看表中数据 三、创建stu#xff08;学…【学生成绩管理】数据库示例数据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)
