【學生成績管理】數據庫示例數據（MySQL代碼）

【學生成績管理】數據庫示例數據（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)

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/news/167805.shtml
繁體地址，請注明出處：http://hk.pswp.cn/news/167805.shtml
英文地址，請注明出處：http://en.pswp.cn/news/167805.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

35.邏輯運算符

35.邏輯運算符

目錄 一.什么是邏輯運算符 二.C語言中的邏輯運算符 三.邏輯表達式 三.視頻教程 一.什么是邏輯運算符 同時對倆個或者倆個以上的表達式進行判斷的運算符叫做邏輯運算符。 舉例：比如去網吧上網，只有年滿十八周歲并且帶身份證才可以上網。在C語言中如果…
閱讀更多...
為什么 Flink 拋棄了 Scala

為什么 Flink 拋棄了 Scala

曾經紅遍一時的Scala 想當初Spark橫空出世之后，Scala簡直就是語言界的一顆璀璨新星，惹得大家紛紛側目，連Kafka這類技術框架也選擇用Scala語言進行開發重構。 可如今，Flink竟然公開宣布棄用Scala 在Flink1.18的官方文檔里&#x…
閱讀更多...
國家開放大學的學子們 練習題 走起！

國家開放大學的學子們 練習題 走起！

試卷代號：1356 高級英語聽說(2) 參考 試題 Section One (20 points, 2 points each) Directions: Listen to the conversation and fill in the blanks with the words you hear. Write the words on the Answer Sheet The conversation will be read TWICE. M…
閱讀更多...
windows11上安裝WSL

windows11上安裝WSL

Windows電腦上要配置linux（這里指ubuntu）開發環境，主要有三種方式： 1）在windows上裝個虛擬機（比如vmware）。缺點是vmware加載ubuntu后系統會變慢很多，而且需要通過samba來實現window…
閱讀更多...
使用Java連接Hbase

使用Java連接Hbase

我在網上試 了很多代碼，但是大部分都不能實現，Java連接Hbase，一直報一個錯 java.util.concurrent.ExecutionException: org.apache.zookeeper.KeeperException$NoNodeException: KeeperErrorCode NoNode for /hbase/hbaseid一直也不清楚為什…
閱讀更多...
計算機組成原理。3-408

計算機組成原理。3-408

1.動態存儲和靜態存儲 2.雙端口RAM 注意：cpu通過地址線和數據線讀寫數據時，不能同時寫，但可以同時讀，也不能一邊讀一邊寫。 3.多體并行存儲器 分為高位存儲和低位存儲 小結 4.磁盤存儲器的組成 5.磁盤的性能指標 磁盤讀寫尋道…
閱讀更多...
如何對網站進行滲透測試

如何對網站進行滲透測試

信息搜集 信息搜集拿到域名后獲取真實IP，如果存在CDN想辦法繞過端口掃描，針對開放的端口在獲取客戶同意的前提下進行爆破查找網站子域名，后臺目錄判斷網站的CMS 可以使用 Wappalyzer插件 whatcms 是一個可以用來確定特定網站正在使用的什么…
閱讀更多...
Vue中Slot的使用指南

Vue中Slot的使用指南

目錄 前言 什么是slot？ 單個slot的使用 具名slot的使用 作用域插槽 總結 前言 在Vue中，slot是一種非常強大和靈活的功能，它允許你在組件模板中預留出一個或多個"插槽"，然后在使用這個組件的時候動態地填充內容。這…
閱讀更多...
TSINGSEE青犀智能分析網關道路積水識別AI算法方案

TSINGSEE青犀智能分析網關道路積水識別AI算法方案

在各處的街道、路口等區域，及時發現道路積水問題，可以大大減少城市管理部門壓力，及時處理，減少交通事故與人員摔倒事故。通過道路積水AI算法，能有效提高城市管理部門效率，優化城市管理方式。 那么&#xff…
閱讀更多...
【Web】PhpBypassTrick相關例題wp

【Web】PhpBypassTrick相關例題wp

目錄 ①[NSSCTF 2022 Spring Recruit]babyphp ②[鶴城杯 2021]Middle magic ③[WUSTCTF 2020]樸實無華 ④[SWPUCTF 2022 新生賽]funny_php 明天中期考，先整理些小知識點冷靜一下 ①[NSSCTF 2022 Spring Recruit]babyphp payload: a[]1&b1[]1&b2[]2&…
閱讀更多...
NLP的使用

NLP的使用

參考： Apache openNLP 簡介 - 鏈滴 (ld246.com) opennlp 模型下載地址：Index of /apache/opennlp/models/ud-models-1.0/ (tencent.com) OpenNLP是一個流行的開源自然語言處理工具包，它提供了一系列的NLP模型和算法。然而，Open…
閱讀更多...
【模擬開關CH440R】2022-1-20

【模擬開關CH440R】2022-1-20

資料模擬開關CH440芯片手冊 - 百度文庫 ch440R回來了，導通usb設備沒問題，降壓不影響。但是我發現個嚴重的問題，我的電路是直接通過4067控制ch440r接地，低電平，使能三個線路連一起的，郵箱的圖您看看&#xf…
閱讀更多...
N-134基于java實現捕魚達人游戲

N-134基于java實現捕魚達人游戲

開發工具eclipse,jdk1.8 文檔截圖&#xff1a; package com.qd.fish;import java.awt.Graphics; import java.io.File; import java.util.ArrayList; import java.util.List;import javax.imageio.ImageIO;public class Fishes {//定義一個集合來管理魚List<Fish> fish…
閱讀更多...
五種多目標優化算法（NSDBO、NSGA3、MOGWO、NSWOA、MOPSO）求解微電網多目標優化調度（MATLAB代碼）

五種多目標優化算法（NSDBO、NSGA3、MOGWO、NSWOA、MOPSO）求解微電網多目標優化調度（MATLAB代碼）

一、多目標優化算法簡介 &#xff08;1&#xff09;非支配排序的蜣螂優化算法NSDBO 多目標應用&#xff1a;基于非支配排序的蜣螂優化算法NSDBO求解微電網多目標優化調度&#xff08;MATLAB&#xff09;-CSDN博客 &#xff08;2&#xff09;NSGA3 NSGA-III求解微電網多目標…
閱讀更多...
應用場景丨社區燃氣管網監測系統建設

應用場景丨社區燃氣管網監測系統建設

燃氣作為現代社會的重要能源&#xff0c;燃氣被廣泛應用于居民生活、工業生產、商業服務等領域。然而&#xff0c;燃氣泄漏事故時有發生&#xff0c;不僅給人們的生命財產安全帶來嚴重威脅&#xff0c;也給燃氣行業的發展帶來不良影響。因此&#xff0c;對于燃氣管道的監測和管…
閱讀更多...
給虛擬機配置靜態id地址

給虛擬機配置靜態id地址

1.令人頭大的原因 當連接虛擬機的時候 地址不一會就改變&#xff0c;每次都要重新輸入 2.配置虛擬機靜態id地址 打開命令窗口執行 : vim /etc/sysconfig/network-scripts/ifcfg-ens33 按下面操作修改 查看自己子網掩碼 3.重啟網絡 命令行輸入 systemctl restart netwo…
閱讀更多...
【C語言】函數（四）：函數遞歸與迭代，二者有什么區別

【C語言】函數（四）：函數遞歸與迭代，二者有什么區別

目錄 前言遞歸定義遞歸的兩個必要條件接受一個整型值&#xff08;無符號&#xff09;&#xff0c;按照順序打印它的每一位使用函數不允許創建臨時變量&#xff0c;求字符串“abcd”的長度求n的階乘求第n個斐波那契數 迭代總結遞歸與迭代的主要區別用法不同結構不同時間開銷不同…
閱讀更多...
容器args中使用環境變量

容器args中使用環境變量

1 背景 有時候需將變量傳給容器&#xff0c;作為命令的參數。比如定義一個branch name&#xff0c;然后在initcontainer中clone對應的配置&#xff0c;進行后續操作。這時候我們就可以通過ConfigMap來保存這個值&#xff0c;然后在Deployment里讀取這個ConfigMap&#xff0c;并…
閱讀更多...
毛利率創歷史新高，三季度的小米拿出“新王牌”？

毛利率創歷史新高，三季度的小米拿出“新王牌”？

近日&#xff0c;小米正式發布了今年三季度的財報。財報數據顯示&#xff0c;小米第三季度經調整凈利潤為59.9億元人民幣&#xff0c;同比增長182.9%&#xff0c;遠超市場預期的48億元。這其中&#xff0c;手機業務作為小米的基本盤一直是市場的關注焦點。今年三季度&#xff0…
閱讀更多...
Python----函數的參數

Python----函數的參數

在函數定義與調用時&#xff0c;我們可以根據自己的需求來實現參數的傳遞。在Python中&#xff0c;函數的參數一共有兩種形式&#xff1a;① 形參 ② 實參 形參&#xff1a;在函數定義時&#xff0c;所編寫的參數就稱之為形式參數 實參&#xff1a;在函數調用時&#xff0c;所…
閱讀更多...
最新文章

Copyright @ 2022~2023