一、背景简介
1、使用场景
我有一个做年级主任教师的朋友，想分析一下他年纪下学生的考试成绩，这里我们使用模拟数据。
学生所属于某一个专业，每个专业开设不同的课程，每门课程会自发的组织测试，进而会有成绩，测试不通过还可以进行补考。测试的频率随科目不同而有差异。
需求1：支持查看全班总成绩，便于分析学生成绩变化，以及出题的难易程度变化。
需求2：支持查看全班及格线，每个专业可以有自己的及格线，甚至每门课程都要有自己的几个线，这里为了方便说明技术点，进而将需求简化。将每个学生的总成绩作为基数，每个专业在每次考试后选取一个分数作为及格线，使得60%的人及格
需求3：支持查看每一次考试，也可以按月汇总查看每月的总成绩，因为学生考试完某一专业的所有课程是有时间跨度的
2、表结构
2.1 专业表
2.2 课程表
2.3 学生表
2.4 成绩表
2.5 成绩次数汇总表
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_profession -- ---------------------------- DROP TABLE IF EXISTS `tb_profession`; CREATE TABLE `tb_profession` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profession_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `add_time` datetime(6) NOT NULL, `modify_time` datetime(6) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_profession -- ---------------------------- INSERT INTO `tb_profession` VALUES (1, '经济与管理', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_profession` VALUES (2, '计算机', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_profession` VALUES (3, '文学与历史', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_profession` VALUES (4, '挖掘机', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); SET FOREIGN_KEY_CHECKS = 1; /* Navicat Premium Data Transfer Source Server : 工作站(日志分析mysql) Source Server Type : MySQL Source Server Version : 50736 Source Host : 10.245.136.238:3306 Source Schema : yango Target Server Type : MySQL Target Server Version : 50736 File Encoding : 65001 Date: 05/03/2022 18:01:30 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_course -- ---------------------------- DROP TABLE IF EXISTS `tb_course`; CREATE TABLE `tb_course` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '课程id大有深意，第一位表示专业，第二位表可以看出名称', `profession_id` int(11) NULL DEFAULT NULL COMMENT '专业id', `subject_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程名称', `add_time` datetime(6) NOT NULL, `modify_time` datetime(6) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_course -- ---------------------------- INSERT INTO `tb_course` VALUES (11, 1, '语文-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (12, 1, '数学-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (13, 1, '英语-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (14, 1, '经济学-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (21, 2, '语文-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (22, 2, '数学-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (23, 2, '英语-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (24, 2, '计算机-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (31, 3, '语文-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (32, 3, '数学-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (33, 3, '英语-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (34, 3, '世界史-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (41, 4, '语文-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (42, 4, '数学-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (43, 4, '英语-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_course` VALUES (44, 4, '挖掘机实操-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_student -- ---------------------------- DROP TABLE IF EXISTS `tb_student`; CREATE TABLE `tb_student` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号大有含义（第一位代表学院id，第二位代表性别，第三位：1表示名称是张三、2表示名称是李四）', `gender` int(2) NULL DEFAULT NULL COMMENT '性别：0表示女，1表示男', `student_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生姓名：经代表经济学院简称', `add_time` datetime(6) NULL DEFAULT NULL, `modify_time` datetime(6) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 414 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_student -- ---------------------------- INSERT INTO `tb_student` VALUES (101, 0, '小明-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (102, 0, '小红-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (103, 0, '小花-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (114, 1, '张三-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (115, 1, '李四-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (116, 1, '王五-经', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (201, 0, '小明-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (202, 0, '小红-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (203, 0, '小花-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (214, 1, '张三-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (215, 1, '李四-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (216, 1, '王五-计', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (301, 0, '小明-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (302, 0, '小红-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (303, 0, '小花-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (314, 1, '张三-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (315, 1, '李四-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (316, 1, '王五-文', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (401, 0, '小明-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (402, 0, '小红-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (403, 0, '小花-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (414, 1, '张三-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (415, 1, '李四-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_student` VALUES (416, 1, '王五-挖', '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_score -- ---------------------------- DROP TABLE IF EXISTS `tb_score`; CREATE TABLE `tb_score` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gender` smallint(6) NOT NULL COMMENT '性别，0表示女，1表示男', `profession_id` int(11) NOT NULL COMMENT '专业id', `profession_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '专业名称', `course_id` int(11) NOT NULL COMMENT '课程id', `course_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '课程名称', `student_id` int(11) NOT NULL COMMENT '学生id', `student_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学生姓名', `exams_version` int(11) NOT NULL COMMENT '考试次数，第一次考不过可以补考，觉得自己没发挥好也可以再考', `exams_date` date NOT NULL COMMENT '考试日期', `score_total` bigint(20) NOT NULL COMMENT '考试成绩', `add_time` datetime(6) NOT NULL, `modify_time` datetime(6) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 487 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_score -- ---------------------------- INSERT INTO `tb_score` VALUES (7, 0, 1, '经济与管理', 11, '语文-经', 101, '小明-经', 1, '2022-02-11', 77, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (8, 0, 1, '经济与管理', 11, '语文-经', 102, '小红-经', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (9, 0, 1, '经济与管理', 11, '语文-经', 103, '小花-经', 1, '2022-02-11', 50, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (10, 1, 1, '经济与管理', 11, '语文-经', 114, '张三-经', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (11, 1, 1, '经济与管理', 11, '语文-经', 115, '李四-经', 1, '2022-02-11', 80, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (12, 1, 1, '经济与管理', 11, '语文-经', 116, '王五-经', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (13, 0, 1, '经济与管理', 12, '数学-经', 101, '小明-经', 1, '2022-02-11', 69, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (14, 0, 1, '经济与管理', 12, '数学-经', 102, '小红-经', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (15, 0, 1, '经济与管理', 12, '数学-经', 103, '小花-经', 1, '2022-02-11', 55, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (16, 1, 1, '经济与管理', 12, '数学-经', 114, '张三-经', 1, '2022-02-11', 35, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (17, 1, 1, '经济与管理', 12, '数学-经', 115, '李四-经', 1, '2022-02-11', 88, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (18, 1, 1, '经济与管理', 12, '数学-经', 116, '王五-经', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (19, 0, 1, '经济与管理', 13, '英语-经', 101, '小明-经', 1, '2022-02-11', 89, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (20, 0, 1, '经济与管理', 13, '英语-经', 102, '小红-经', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (21, 0, 1, '经济与管理', 13, '英语-经', 103, '小花-经', 1, '2022-02-11', 70, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (22, 1, 1, '经济与管理', 13, '英语-经', 114, '张三-经', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (23, 1, 1, '经济与管理', 13, '英语-经', 115, '李四-经', 1, '2022-02-11', 10, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (24, 1, 1, '经济与管理', 13, '英语-经', 116, '王五-经', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (25, 0, 1, '经济与管理', 14, '经济学-经', 101, '小明-经', 1, '2022-02-11', 5, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (26, 0, 1, '经济与管理', 14, '经济学-经', 102, '小红-经', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (27, 0, 1, '经济与管理', 14, '经济学-经', 103, '小花-经', 1, '2022-02-11', 9, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (28, 1, 1, '经济与管理', 14, '经济学-经', 114, '张三-经', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (29, 1, 1, '经济与管理', 14, '经济学-经', 115, '李四-经', 1, '2022-02-11', 80, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (30, 1, 1, '经济与管理', 14, '经济学-经', 116, '王五-经', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (31, 0, 2, '计算机', 21, '语文-计', 201, '小明-计', 1, '2022-02-11', 77, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (32, 0, 2, '计算机', 21, '语文-计', 202, '小红-计', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (33, 0, 2, '计算机', 21, '语文-计', 203, '小花-计', 1, '2022-02-11', 50, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (34, 1, 2, '计算机', 21, '语文-计', 214, '张三-计', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (35, 1, 2, '计算机', 21, '语文-计', 215, '李四-计', 1, '2022-02-11', 80, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (36, 1, 2, '计算机', 21, '语文-计', 216, '王五-计', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (37, 0, 2, '计算机', 22, '数学-计', 201, '小明-计', 1, '2022-02-11', 69, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (38, 0, 2, '计算机', 22, '数学-计', 202, '小红-计', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (39, 0, 2, '计算机', 22, '数学-计', 203, '小花-计', 1, '2022-02-11', 55, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (40, 1, 2, '计算机', 22, '数学-计', 214, '张三-计', 1, '2022-02-11', 35, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (41, 1, 2, '计算机', 22, '数学-计', 215, '李四-计', 1, '2022-02-11', 88, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (42, 1, 2, '计算机', 22, '数学-计', 216, '王五-计', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (43, 0, 2, '计算机', 23, '英语-计', 201, '小明-计', 1, '2022-02-11', 89, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (44, 0, 2, '计算机', 23, '英语-计', 202, '小红-计', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (45, 0, 2, '计算机', 23, '英语-计', 203, '小花-计', 1, '2022-02-11', 70, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (46, 1, 2, '计算机', 23, '英语-计', 214, '张三-计', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (47, 1, 2, '计算机', 23, '英语-计', 215, '李四-计', 1, '2022-02-11', 10, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (48, 1, 2, '计算机', 23, '英语-计', 216, '王五-计', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (49, 0, 2, '计算机', 24, '计算机-计', 201, '小明-计', 1, '2022-02-11', 5, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (50, 0, 2, '计算机', 24, '计算机-计', 202, '小红-计', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (51, 0, 2, '计算机', 24, '计算机-计', 203, '小花-计', 1, '2022-02-11', 9, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (52, 1, 2, '计算机', 24, '计算机-计', 214, '张三-计', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (53, 1, 2, '计算机', 24, '计算机-计', 215, '李四-计', 1, '2022-02-11', 80, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (54, 1, 2, '计算机', 24, '计算机-计', 216, '王五-计', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (55, 0, 3, '文学与历史', 31, '语文-文', 301, '小明-文', 1, '2022-02-11', 77, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (56, 0, 3, '文学与历史', 31, '语文-文', 302, '小红-文', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (57, 0, 3, '文学与历史', 31, '语文-文', 303, '小花-文', 1, '2022-02-11', 50, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (58, 1, 3, '文学与历史', 31, '语文-文', 314, '张三-文', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (59, 1, 3, '文学与历史', 31, '语文-文', 315, '李四-文', 1, '2022-02-11', 80, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (60, 1, 3, '文学与历史', 31, '语文-文', 316, '王五-文', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (61, 0, 3, '文学与历史', 32, '数学-文', 301, '小明-文', 1, '2022-02-11', 69, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (62, 0, 3, '文学与历史', 32, '数学-文', 302, '小红-文', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (63, 0, 3, '文学与历史', 32, '数学-文', 303, '小花-文', 1, '2022-02-11', 55, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (64, 1, 3, '文学与历史', 32, '数学-文', 314, '张三-文', 1, '2022-02-11', 35, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (65, 1, 3, '文学与历史', 32, '数学-文', 315, '李四-文', 1, '2022-02-11', 88, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (66, 1, 3, '文学与历史', 32, '数学-文', 316, '王五-文', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (67, 0, 3, '文学与历史', 33, '英语-文', 301, '小明-文', 1, '2022-02-11', 89, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (68, 0, 3, '文学与历史', 33, '英语-文', 302, '小红-文', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (69, 0, 3, '文学与历史', 33, '英语-文', 303, '小花-文', 1, '2022-02-11', 70, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (70, 1, 3, '文学与历史', 33, '英语-文', 314, '张三-文', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (71, 1, 3, '文学与历史', 33, '英语-文', 315, '李四-文', 1, '2022-02-11', 10, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (72, 1, 3, '文学与历史', 33, '英语-文', 316, '王五-文', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (73, 0, 3, '文学与历史', 34, '世界史-文', 301, '小明-文', 1, '2022-02-11', 5, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (74, 0, 3, '文学与历史', 34, '世界史-文', 302, '小红-文', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (75, 0, 3, '文学与历史', 34, '世界史-文', 303, '小花-文', 1, '2022-02-11', 9, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (76, 1, 3, '文学与历史', 34, '世界史-文', 314, '张三-文', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (77, 1, 3, '文学与历史', 34, '世界史-文', 315, '李四-文', 1, '2022-02-11', 80, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (78, 1, 3, '文学与历史', 34, '世界史-文', 316, '王五-文', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (79, 0, 4, '挖掘机', 41, '语文-挖', 401, '小明-挖', 1, '2022-02-11', 77, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (80, 0, 4, '挖掘机', 41, '语文-挖', 402, '小红-挖', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (81, 0, 4, '挖掘机', 41, '语文-挖', 403, '小花-挖', 1, '2022-02-11', 50, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (82, 1, 4, '挖掘机', 41, '语文-挖', 414, '张三-挖', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (83, 1, 4, '挖掘机', 41, '语文-挖', 415, '李四-挖', 1, '2022-02-11', 80, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (84, 1, 4, '挖掘机', 41, '语文-挖', 416, '王五-挖', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (85, 0, 4, '挖掘机', 42, '数学-挖', 401, '小明-挖', 1, '2022-02-11', 69, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (86, 0, 4, '挖掘机', 42, '数学-挖', 402, '小红-挖', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (87, 0, 4, '挖掘机', 42, '数学-挖', 403, '小花-挖', 1, '2022-02-11', 55, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (88, 1, 4, '挖掘机', 42, '数学-挖', 414, '张三-挖', 1, '2022-02-11', 35, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (89, 1, 4, '挖掘机', 42, '数学-挖', 415, '李四-挖', 1, '2022-02-11', 88, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (90, 1, 4, '挖掘机', 42, '数学-挖', 416, '王五-挖', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (91, 0, 4, '挖掘机', 43, '英语-挖', 401, '小明-挖', 1, '2022-02-11', 89, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (92, 0, 4, '挖掘机', 43, '英语-挖', 402, '小红-挖', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (93, 0, 4, '挖掘机', 43, '英语-挖', 403, '小花-挖', 1, '2022-02-11', 70, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (94, 1, 4, '挖掘机', 43, '英语-挖', 414, '张三-挖', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (95, 1, 4, '挖掘机', 43, '英语-挖', 415, '李四-挖', 1, '2022-02-11', 10, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (96, 1, 4, '挖掘机', 43, '英语-挖', 416, '王五-挖', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (97, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 401, '小明-挖', 1, '2022-02-11', 5, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (98, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 402, '小红-挖', 1, '2022-02-11', 60, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (99, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 403, '小花-挖', 1, '2022-02-11', 9, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (100, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 414, '张三-挖', 1, '2022-02-11', 100, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (101, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 415, '李四-挖', 1, '2022-02-11', 80, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (102, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 416, '王五-挖', 1, '2022-02-11', 90, '2022-02-11 17:16:52.000000', '2022-02-11 17:16:54.000000'); INSERT INTO `tb_score` VALUES (103, 0, 1, '经济与管理', 11, '语文-经', 101, '小明-经', 1, '2022-02-22', 77, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (104, 0, 1, '经济与管理', 11, '语文-经', 102, '小红-经', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (105, 0, 1, '经济与管理', 11, '语文-经', 103, '小花-经', 1, '2022-02-22', 50, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (106, 1, 1, '经济与管理', 11, '语文-经', 114, '张三-经', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (107, 1, 1, '经济与管理', 11, '语文-经', 115, '李四-经', 1, '2022-02-22', 80, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (108, 1, 1, '经济与管理', 11, '语文-经', 116, '王五-经', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (109, 0, 1, '经济与管理', 12, '数学-经', 101, '小明-经', 1, '2022-02-22', 69, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (110, 0, 1, '经济与管理', 12, '数学-经', 102, '小红-经', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (111, 0, 1, '经济与管理', 12, '数学-经', 103, '小花-经', 1, '2022-02-22', 55, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (112, 1, 1, '经济与管理', 12, '数学-经', 114, '张三-经', 1, '2022-02-22', 35, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (113, 1, 1, '经济与管理', 12, '数学-经', 115, '李四-经', 1, '2022-02-22', 88, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (114, 1, 1, '经济与管理', 12, '数学-经', 116, '王五-经', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (115, 0, 1, '经济与管理', 13, '英语-经', 101, '小明-经', 1, '2022-02-22', 89, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (116, 0, 1, '经济与管理', 13, '英语-经', 102, '小红-经', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (117, 0, 1, '经济与管理', 13, '英语-经', 103, '小花-经', 1, '2022-02-22', 70, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (118, 1, 1, '经济与管理', 13, '英语-经', 114, '张三-经', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (119, 1, 1, '经济与管理', 13, '英语-经', 115, '李四-经', 1, '2022-02-22', 10, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (120, 1, 1, '经济与管理', 13, '英语-经', 116, '王五-经', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (121, 0, 1, '经济与管理', 14, '经济学-经', 101, '小明-经', 1, '2022-02-22', 5, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (122, 0, 1, '经济与管理', 14, '经济学-经', 102, '小红-经', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (123, 0, 1, '经济与管理', 14, '经济学-经', 103, '小花-经', 1, '2022-02-22', 9, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (124, 1, 1, '经济与管理', 14, '经济学-经', 114, '张三-经', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (125, 1, 1, '经济与管理', 14, '经济学-经', 115, '李四-经', 1, '2022-02-22', 80, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (126, 1, 1, '经济与管理', 14, '经济学-经', 116, '王五-经', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (127, 0, 2, '计算机', 21, '语文-计', 201, '小明-计', 1, '2022-02-22', 77, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (128, 0, 2, '计算机', 21, '语文-计', 202, '小红-计', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (129, 0, 2, '计算机', 21, '语文-计', 203, '小花-计', 1, '2022-02-22', 50, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (130, 1, 2, '计算机', 21, '语文-计', 214, '张三-计', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (131, 1, 2, '计算机', 21, '语文-计', 215, '李四-计', 1, '2022-02-22', 80, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (132, 1, 2, '计算机', 21, '语文-计', 216, '王五-计', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (133, 0, 2, '计算机', 22, '数学-计', 201, '小明-计', 1, '2022-02-22', 69, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (134, 0, 2, '计算机', 22, '数学-计', 202, '小红-计', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (135, 0, 2, '计算机', 22, '数学-计', 203, '小花-计', 1, '2022-02-22', 55, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (136, 1, 2, '计算机', 22, '数学-计', 214, '张三-计', 1, '2022-02-22', 35, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (137, 1, 2, '计算机', 22, '数学-计', 215, '李四-计', 1, '2022-02-22', 88, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (138, 1, 2, '计算机', 22, '数学-计', 216, '王五-计', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (139, 0, 2, '计算机', 23, '英语-计', 201, '小明-计', 1, '2022-02-22', 89, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (140, 0, 2, '计算机', 23, '英语-计', 202, '小红-计', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (141, 0, 2, '计算机', 23, '英语-计', 203, '小花-计', 1, '2022-02-22', 70, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (142, 1, 2, '计算机', 23, '英语-计', 214, '张三-计', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (143, 1, 2, '计算机', 23, '英语-计', 215, '李四-计', 1, '2022-02-22', 10, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (144, 1, 2, '计算机', 23, '英语-计', 216, '王五-计', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (145, 0, 2, '计算机', 24, '计算机-计', 201, '小明-计', 1, '2022-02-22', 5, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (146, 0, 2, '计算机', 24, '计算机-计', 202, '小红-计', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (147, 0, 2, '计算机', 24, '计算机-计', 203, '小花-计', 1, '2022-02-22', 9, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (148, 1, 2, '计算机', 24, '计算机-计', 214, '张三-计', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (149, 1, 2, '计算机', 24, '计算机-计', 215, '李四-计', 1, '2022-02-22', 80, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (150, 1, 2, '计算机', 24, '计算机-计', 216, '王五-计', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (151, 0, 3, '文学与历史', 31, '语文-文', 301, '小明-文', 1, '2022-02-22', 77, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (152, 0, 3, '文学与历史', 31, '语文-文', 302, '小红-文', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (153, 0, 3, '文学与历史', 31, '语文-文', 303, '小花-文', 1, '2022-02-22', 50, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (154, 1, 3, '文学与历史', 31, '语文-文', 314, '张三-文', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (155, 1, 3, '文学与历史', 31, '语文-文', 315, '李四-文', 1, '2022-02-22', 80, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (156, 1, 3, '文学与历史', 31, '语文-文', 316, '王五-文', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (157, 0, 3, '文学与历史', 32, '数学-文', 301, '小明-文', 1, '2022-02-22', 69, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (158, 0, 3, '文学与历史', 32, '数学-文', 302, '小红-文', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (159, 0, 3, '文学与历史', 32, '数学-文', 303, '小花-文', 1, '2022-02-22', 55, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (160, 1, 3, '文学与历史', 32, '数学-文', 314, '张三-文', 1, '2022-02-22', 35, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (161, 1, 3, '文学与历史', 32, '数学-文', 315, '李四-文', 1, '2022-02-22', 88, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (162, 1, 3, '文学与历史', 32, '数学-文', 316, '王五-文', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (163, 0, 3, '文学与历史', 33, '英语-文', 301, '小明-文', 1, '2022-02-22', 89, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (164, 0, 3, '文学与历史', 33, '英语-文', 302, '小红-文', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (165, 0, 3, '文学与历史', 33, '英语-文', 303, '小花-文', 1, '2022-02-22', 70, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (166, 1, 3, '文学与历史', 33, '英语-文', 314, '张三-文', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (167, 1, 3, '文学与历史', 33, '英语-文', 315, '李四-文', 1, '2022-02-22', 10, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (168, 1, 3, '文学与历史', 33, '英语-文', 316, '王五-文', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (169, 0, 3, '文学与历史', 34, '世界史-文', 301, '小明-文', 1, '2022-02-22', 5, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (170, 0, 3, '文学与历史', 34, '世界史-文', 302, '小红-文', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (171, 0, 3, '文学与历史', 34, '世界史-文', 303, '小花-文', 1, '2022-02-22', 9, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (172, 1, 3, '文学与历史', 34, '世界史-文', 314, '张三-文', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (173, 1, 3, '文学与历史', 34, '世界史-文', 315, '李四-文', 1, '2022-02-22', 80, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (174, 1, 3, '文学与历史', 34, '世界史-文', 316, '王五-文', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (175, 0, 4, '挖掘机', 41, '语文-挖', 401, '小明-挖', 1, '2022-02-22', 77, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (176, 0, 4, '挖掘机', 41, '语文-挖', 402, '小红-挖', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (177, 0, 4, '挖掘机', 41, '语文-挖', 403, '小花-挖', 1, '2022-02-22', 50, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (178, 1, 4, '挖掘机', 41, '语文-挖', 414, '张三-挖', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (179, 1, 4, '挖掘机', 41, '语文-挖', 415, '李四-挖', 1, '2022-02-22', 80, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (180, 1, 4, '挖掘机', 41, '语文-挖', 416, '王五-挖', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (181, 0, 4, '挖掘机', 42, '数学-挖', 401, '小明-挖', 1, '2022-02-22', 69, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (182, 0, 4, '挖掘机', 42, '数学-挖', 402, '小红-挖', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (183, 0, 4, '挖掘机', 42, '数学-挖', 403, '小花-挖', 1, '2022-02-22', 55, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (184, 1, 4, '挖掘机', 42, '数学-挖', 414, '张三-挖', 1, '2022-02-22', 35, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (185, 1, 4, '挖掘机', 42, '数学-挖', 415, '李四-挖', 1, '2022-02-22', 88, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (186, 1, 4, '挖掘机', 42, '数学-挖', 416, '王五-挖', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (187, 0, 4, '挖掘机', 43, '英语-挖', 401, '小明-挖', 1, '2022-02-22', 89, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (188, 0, 4, '挖掘机', 43, '英语-挖', 402, '小红-挖', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (189, 0, 4, '挖掘机', 43, '英语-挖', 403, '小花-挖', 1, '2022-02-22', 70, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (190, 1, 4, '挖掘机', 43, '英语-挖', 414, '张三-挖', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (191, 1, 4, '挖掘机', 43, '英语-挖', 415, '李四-挖', 1, '2022-02-22', 10, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (192, 1, 4, '挖掘机', 43, '英语-挖', 416, '王五-挖', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (193, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 401, '小明-挖', 1, '2022-02-22', 5, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (194, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 402, '小红-挖', 1, '2022-02-22', 60, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (195, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 403, '小花-挖', 1, '2022-02-22', 9, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (196, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 414, '张三-挖', 1, '2022-02-22', 100, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (197, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 415, '李四-挖', 1, '2022-02-22', 80, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (198, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 416, '王五-挖', 1, '2022-02-22', 90, '2022-02-22 17:16:52.000000', '2022-02-22 17:16:54.000000'); INSERT INTO `tb_score` VALUES (199, 0, 1, '经济与管理', 11, '语文-经', 101, '小明-经', 1, '2022-02-15', 77, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (200, 0, 1, '经济与管理', 11, '语文-经', 102, '小红-经', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (201, 0, 1, '经济与管理', 11, '语文-经', 103, '小花-经', 1, '2022-02-15', 50, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (202, 1, 1, '经济与管理', 11, '语文-经', 114, '张三-经', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (203, 1, 1, '经济与管理', 11, '语文-经', 115, '李四-经', 1, '2022-02-15', 80, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (204, 1, 1, '经济与管理', 11, '语文-经', 116, '王五-经', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (205, 0, 1, '经济与管理', 12, '数学-经', 101, '小明-经', 1, '2022-02-15', 69, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (206, 0, 1, '经济与管理', 12, '数学-经', 102, '小红-经', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (207, 0, 1, '经济与管理', 12, '数学-经', 103, '小花-经', 1, '2022-02-15', 55, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (208, 1, 1, '经济与管理', 12, '数学-经', 114, '张三-经', 1, '2022-02-15', 35, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (209, 1, 1, '经济与管理', 12, '数学-经', 115, '李四-经', 1, '2022-02-15', 88, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (210, 1, 1, '经济与管理', 12, '数学-经', 116, '王五-经', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (211, 0, 1, '经济与管理', 13, '英语-经', 101, '小明-经', 1, '2022-02-15', 89, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (212, 0, 1, '经济与管理', 13, '英语-经', 102, '小红-经', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (213, 0, 1, '经济与管理', 13, '英语-经', 103, '小花-经', 1, '2022-02-15', 70, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (214, 1, 1, '经济与管理', 13, '英语-经', 114, '张三-经', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (215, 1, 1, '经济与管理', 13, '英语-经', 115, '李四-经', 1, '2022-02-15', 10, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (216, 1, 1, '经济与管理', 13, '英语-经', 116, '王五-经', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (217, 0, 1, '经济与管理', 14, '经济学-经', 101, '小明-经', 1, '2022-02-15', 5, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (218, 0, 1, '经济与管理', 14, '经济学-经', 102, '小红-经', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (219, 0, 1, '经济与管理', 14, '经济学-经', 103, '小花-经', 1, '2022-02-15', 9, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (220, 1, 1, '经济与管理', 14, '经济学-经', 114, '张三-经', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (221, 1, 1, '经济与管理', 14, '经济学-经', 115, '李四-经', 1, '2022-02-15', 80, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (222, 1, 1, '经济与管理', 14, '经济学-经', 116, '王五-经', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (223, 0, 2, '计算机', 21, '语文-计', 201, '小明-计', 1, '2022-02-15', 77, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (224, 0, 2, '计算机', 21, '语文-计', 202, '小红-计', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (225, 0, 2, '计算机', 21, '语文-计', 203, '小花-计', 1, '2022-02-15', 50, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (226, 1, 2, '计算机', 21, '语文-计', 214, '张三-计', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (227, 1, 2, '计算机', 21, '语文-计', 215, '李四-计', 1, '2022-02-15', 80, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (228, 1, 2, '计算机', 21, '语文-计', 216, '王五-计', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (229, 0, 2, '计算机', 22, '数学-计', 201, '小明-计', 1, '2022-02-15', 69, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (230, 0, 2, '计算机', 22, '数学-计', 202, '小红-计', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (231, 0, 2, '计算机', 22, '数学-计', 203, '小花-计', 1, '2022-02-15', 55, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (232, 1, 2, '计算机', 22, '数学-计', 214, '张三-计', 1, '2022-02-15', 35, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (233, 1, 2, '计算机', 22, '数学-计', 215, '李四-计', 1, '2022-02-15', 88, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (234, 1, 2, '计算机', 22, '数学-计', 216, '王五-计', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (235, 0, 2, '计算机', 23, '英语-计', 201, '小明-计', 1, '2022-02-15', 89, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (236, 0, 2, '计算机', 23, '英语-计', 202, '小红-计', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (237, 0, 2, '计算机', 23, '英语-计', 203, '小花-计', 1, '2022-02-15', 70, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (238, 1, 2, '计算机', 23, '英语-计', 214, '张三-计', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (239, 1, 2, '计算机', 23, '英语-计', 215, '李四-计', 1, '2022-02-15', 10, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (240, 1, 2, '计算机', 23, '英语-计', 216, '王五-计', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (241, 0, 2, '计算机', 24, '计算机-计', 201, '小明-计', 1, '2022-02-15', 5, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (242, 0, 2, '计算机', 24, '计算机-计', 202, '小红-计', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (243, 0, 2, '计算机', 24, '计算机-计', 203, '小花-计', 1, '2022-02-15', 9, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (244, 1, 2, '计算机', 24, '计算机-计', 214, '张三-计', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (245, 1, 2, '计算机', 24, '计算机-计', 215, '李四-计', 1, '2022-02-15', 80, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (246, 1, 2, '计算机', 24, '计算机-计', 216, '王五-计', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (247, 0, 3, '文学与历史', 31, '语文-文', 301, '小明-文', 1, '2022-02-15', 77, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (248, 0, 3, '文学与历史', 31, '语文-文', 302, '小红-文', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (249, 0, 3, '文学与历史', 31, '语文-文', 303, '小花-文', 1, '2022-02-15', 50, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (250, 1, 3, '文学与历史', 31, '语文-文', 314, '张三-文', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (251, 1, 3, '文学与历史', 31, '语文-文', 315, '李四-文', 1, '2022-02-15', 80, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (252, 1, 3, '文学与历史', 31, '语文-文', 316, '王五-文', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (253, 0, 3, '文学与历史', 32, '数学-文', 301, '小明-文', 1, '2022-02-15', 69, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (254, 0, 3, '文学与历史', 32, '数学-文', 302, '小红-文', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (255, 0, 3, '文学与历史', 32, '数学-文', 303, '小花-文', 1, '2022-02-15', 55, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (256, 1, 3, '文学与历史', 32, '数学-文', 314, '张三-文', 1, '2022-02-15', 35, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (257, 1, 3, '文学与历史', 32, '数学-文', 315, '李四-文', 1, '2022-02-15', 88, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (258, 1, 3, '文学与历史', 32, '数学-文', 316, '王五-文', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (259, 0, 3, '文学与历史', 33, '英语-文', 301, '小明-文', 1, '2022-02-15', 89, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (260, 0, 3, '文学与历史', 33, '英语-文', 302, '小红-文', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (261, 0, 3, '文学与历史', 33, '英语-文', 303, '小花-文', 1, '2022-02-15', 70, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (262, 1, 3, '文学与历史', 33, '英语-文', 314, '张三-文', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (263, 1, 3, '文学与历史', 33, '英语-文', 315, '李四-文', 1, '2022-02-15', 10, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (264, 1, 3, '文学与历史', 33, '英语-文', 316, '王五-文', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (265, 0, 3, '文学与历史', 34, '世界史-文', 301, '小明-文', 1, '2022-02-15', 5, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (266, 0, 3, '文学与历史', 34, '世界史-文', 302, '小红-文', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (267, 0, 3, '文学与历史', 34, '世界史-文', 303, '小花-文', 1, '2022-02-15', 9, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (268, 1, 3, '文学与历史', 34, '世界史-文', 314, '张三-文', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (269, 1, 3, '文学与历史', 34, '世界史-文', 315, '李四-文', 1, '2022-02-15', 80, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (270, 1, 3, '文学与历史', 34, '世界史-文', 316, '王五-文', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (271, 0, 4, '挖掘机', 41, '语文-挖', 401, '小明-挖', 1, '2022-02-15', 77, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (272, 0, 4, '挖掘机', 41, '语文-挖', 402, '小红-挖', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (273, 0, 4, '挖掘机', 41, '语文-挖', 403, '小花-挖', 1, '2022-02-15', 50, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (274, 1, 4, '挖掘机', 41, '语文-挖', 414, '张三-挖', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (275, 1, 4, '挖掘机', 41, '语文-挖', 415, '李四-挖', 1, '2022-02-15', 80, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (276, 1, 4, '挖掘机', 41, '语文-挖', 416, '王五-挖', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (277, 0, 4, '挖掘机', 42, '数学-挖', 401, '小明-挖', 1, '2022-02-15', 69, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (278, 0, 4, '挖掘机', 42, '数学-挖', 402, '小红-挖', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (279, 0, 4, '挖掘机', 42, '数学-挖', 403, '小花-挖', 1, '2022-02-15', 55, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (280, 1, 4, '挖掘机', 42, '数学-挖', 414, '张三-挖', 1, '2022-02-15', 35, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (281, 1, 4, '挖掘机', 42, '数学-挖', 415, '李四-挖', 1, '2022-02-15', 88, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (282, 1, 4, '挖掘机', 42, '数学-挖', 416, '王五-挖', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (283, 0, 4, '挖掘机', 43, '英语-挖', 401, '小明-挖', 1, '2022-02-15', 89, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (284, 0, 4, '挖掘机', 43, '英语-挖', 402, '小红-挖', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (285, 0, 4, '挖掘机', 43, '英语-挖', 403, '小花-挖', 1, '2022-02-15', 70, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (286, 1, 4, '挖掘机', 43, '英语-挖', 414, '张三-挖', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (287, 1, 4, '挖掘机', 43, '英语-挖', 415, '李四-挖', 1, '2022-02-15', 10, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (288, 1, 4, '挖掘机', 43, '英语-挖', 416, '王五-挖', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (289, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 401, '小明-挖', 1, '2022-02-15', 5, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (290, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 402, '小红-挖', 1, '2022-02-15', 60, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (291, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 403, '小花-挖', 1, '2022-02-15', 9, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (292, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 414, '张三-挖', 1, '2022-02-15', 100, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (293, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 415, '李四-挖', 1, '2022-02-15', 80, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (294, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 416, '王五-挖', 1, '2022-02-15', 90, '2022-02-15 17:16:52.000000', '2022-02-15 17:16:54.000000'); INSERT INTO `tb_score` VALUES (295, 0, 1, '经济与管理', 11, '语文-经', 101, '小明-经', 1, '2022-03-08', 77, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (296, 0, 1, '经济与管理', 11, '语文-经', 102, '小红-经', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (297, 0, 1, '经济与管理', 11, '语文-经', 103, '小花-经', 1, '2022-03-08', 50, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (298, 1, 1, '经济与管理', 11, '语文-经', 114, '张三-经', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (299, 1, 1, '经济与管理', 11, '语文-经', 115, '李四-经', 1, '2022-03-08', 80, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (300, 1, 1, '经济与管理', 11, '语文-经', 116, '王五-经', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (301, 0, 1, '经济与管理', 12, '数学-经', 101, '小明-经', 1, '2022-03-08', 69, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (302, 0, 1, '经济与管理', 12, '数学-经', 102, '小红-经', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (303, 0, 1, '经济与管理', 12, '数学-经', 103, '小花-经', 1, '2022-03-08', 55, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (304, 1, 1, '经济与管理', 12, '数学-经', 114, '张三-经', 1, '2022-03-08', 35, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (305, 1, 1, '经济与管理', 12, '数学-经', 115, '李四-经', 1, '2022-03-08', 88, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (306, 1, 1, '经济与管理', 12, '数学-经', 116, '王五-经', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (307, 0, 1, '经济与管理', 13, '英语-经', 101, '小明-经', 1, '2022-03-08', 89, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (308, 0, 1, '经济与管理', 13, '英语-经', 102, '小红-经', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (309, 0, 1, '经济与管理', 13, '英语-经', 103, '小花-经', 1, '2022-03-08', 70, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (310, 1, 1, '经济与管理', 13, '英语-经', 114, '张三-经', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (311, 1, 1, '经济与管理', 13, '英语-经', 115, '李四-经', 1, '2022-03-08', 10, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (312, 1, 1, '经济与管理', 13, '英语-经', 116, '王五-经', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (313, 0, 1, '经济与管理', 14, '经济学-经', 101, '小明-经', 1, '2022-03-08', 5, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (314, 0, 1, '经济与管理', 14, '经济学-经', 102, '小红-经', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (315, 0, 1, '经济与管理', 14, '经济学-经', 103, '小花-经', 1, '2022-03-08', 9, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (316, 1, 1, '经济与管理', 14, '经济学-经', 114, '张三-经', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (317, 1, 1, '经济与管理', 14, '经济学-经', 115, '李四-经', 1, '2022-03-08', 80, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (318, 1, 1, '经济与管理', 14, '经济学-经', 116, '王五-经', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (319, 0, 2, '计算机', 21, '语文-计', 201, '小明-计', 1, '2022-03-08', 77, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (320, 0, 2, '计算机', 21, '语文-计', 202, '小红-计', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (321, 0, 2, '计算机', 21, '语文-计', 203, '小花-计', 1, '2022-03-08', 50, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (322, 1, 2, '计算机', 21, '语文-计', 214, '张三-计', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (323, 1, 2, '计算机', 21, '语文-计', 215, '李四-计', 1, '2022-03-08', 80, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (324, 1, 2, '计算机', 21, '语文-计', 216, '王五-计', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (325, 0, 2, '计算机', 22, '数学-计', 201, '小明-计', 1, '2022-03-08', 69, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (326, 0, 2, '计算机', 22, '数学-计', 202, '小红-计', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (327, 0, 2, '计算机', 22, '数学-计', 203, '小花-计', 1, '2022-03-08', 55, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (328, 1, 2, '计算机', 22, '数学-计', 214, '张三-计', 1, '2022-03-08', 35, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (329, 1, 2, '计算机', 22, '数学-计', 215, '李四-计', 1, '2022-03-08', 88, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (330, 1, 2, '计算机', 22, '数学-计', 216, '王五-计', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (331, 0, 2, '计算机', 23, '英语-计', 201, '小明-计', 1, '2022-03-08', 89, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (332, 0, 2, '计算机', 23, '英语-计', 202, '小红-计', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (333, 0, 2, '计算机', 23, '英语-计', 203, '小花-计', 1, '2022-03-08', 70, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (334, 1, 2, '计算机', 23, '英语-计', 214, '张三-计', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (335, 1, 2, '计算机', 23, '英语-计', 215, '李四-计', 1, '2022-03-08', 10, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (336, 1, 2, '计算机', 23, '英语-计', 216, '王五-计', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (337, 0, 2, '计算机', 24, '计算机-计', 201, '小明-计', 1, '2022-03-08', 5, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (338, 0, 2, '计算机', 24, '计算机-计', 202, '小红-计', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (339, 0, 2, '计算机', 24, '计算机-计', 203, '小花-计', 1, '2022-03-08', 9, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (340, 1, 2, '计算机', 24, '计算机-计', 214, '张三-计', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (341, 1, 2, '计算机', 24, '计算机-计', 215, '李四-计', 1, '2022-03-08', 80, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (342, 1, 2, '计算机', 24, '计算机-计', 216, '王五-计', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (343, 0, 3, '文学与历史', 31, '语文-文', 301, '小明-文', 1, '2022-03-08', 77, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (344, 0, 3, '文学与历史', 31, '语文-文', 302, '小红-文', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (345, 0, 3, '文学与历史', 31, '语文-文', 303, '小花-文', 1, '2022-03-08', 50, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (346, 1, 3, '文学与历史', 31, '语文-文', 314, '张三-文', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (347, 1, 3, '文学与历史', 31, '语文-文', 315, '李四-文', 1, '2022-03-08', 80, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (348, 1, 3, '文学与历史', 31, '语文-文', 316, '王五-文', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (349, 0, 3, '文学与历史', 32, '数学-文', 301, '小明-文', 1, '2022-03-08', 69, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (350, 0, 3, '文学与历史', 32, '数学-文', 302, '小红-文', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (351, 0, 3, '文学与历史', 32, '数学-文', 303, '小花-文', 1, '2022-03-08', 55, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (352, 1, 3, '文学与历史', 32, '数学-文', 314, '张三-文', 1, '2022-03-08', 35, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (353, 1, 3, '文学与历史', 32, '数学-文', 315, '李四-文', 1, '2022-03-08', 88, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (354, 1, 3, '文学与历史', 32, '数学-文', 316, '王五-文', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (355, 0, 3, '文学与历史', 33, '英语-文', 301, '小明-文', 1, '2022-03-08', 89, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (356, 0, 3, '文学与历史', 33, '英语-文', 302, '小红-文', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (357, 0, 3, '文学与历史', 33, '英语-文', 303, '小花-文', 1, '2022-03-08', 70, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (358, 1, 3, '文学与历史', 33, '英语-文', 314, '张三-文', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (359, 1, 3, '文学与历史', 33, '英语-文', 315, '李四-文', 1, '2022-03-08', 10, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (360, 1, 3, '文学与历史', 33, '英语-文', 316, '王五-文', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (361, 0, 3, '文学与历史', 34, '世界史-文', 301, '小明-文', 1, '2022-03-08', 5, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (362, 0, 3, '文学与历史', 34, '世界史-文', 302, '小红-文', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (363, 0, 3, '文学与历史', 34, '世界史-文', 303, '小花-文', 1, '2022-03-08', 9, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (364, 1, 3, '文学与历史', 34, '世界史-文', 314, '张三-文', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (365, 1, 3, '文学与历史', 34, '世界史-文', 315, '李四-文', 1, '2022-03-08', 80, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (366, 1, 3, '文学与历史', 34, '世界史-文', 316, '王五-文', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (367, 0, 4, '挖掘机', 41, '语文-挖', 401, '小明-挖', 1, '2022-03-08', 77, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (368, 0, 4, '挖掘机', 41, '语文-挖', 402, '小红-挖', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (369, 0, 4, '挖掘机', 41, '语文-挖', 403, '小花-挖', 1, '2022-03-08', 50, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (370, 1, 4, '挖掘机', 41, '语文-挖', 414, '张三-挖', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (371, 1, 4, '挖掘机', 41, '语文-挖', 415, '李四-挖', 1, '2022-03-08', 80, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (372, 1, 4, '挖掘机', 41, '语文-挖', 416, '王五-挖', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (373, 0, 4, '挖掘机', 42, '数学-挖', 401, '小明-挖', 1, '2022-03-08', 69, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (374, 0, 4, '挖掘机', 42, '数学-挖', 402, '小红-挖', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (375, 0, 4, '挖掘机', 42, '数学-挖', 403, '小花-挖', 1, '2022-03-08', 55, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (376, 1, 4, '挖掘机', 42, '数学-挖', 414, '张三-挖', 1, '2022-03-08', 35, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (377, 1, 4, '挖掘机', 42, '数学-挖', 415, '李四-挖', 1, '2022-03-08', 88, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (378, 1, 4, '挖掘机', 42, '数学-挖', 416, '王五-挖', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (379, 0, 4, '挖掘机', 43, '英语-挖', 401, '小明-挖', 1, '2022-03-08', 89, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (380, 0, 4, '挖掘机', 43, '英语-挖', 402, '小红-挖', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (381, 0, 4, '挖掘机', 43, '英语-挖', 403, '小花-挖', 1, '2022-03-08', 70, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (382, 1, 4, '挖掘机', 43, '英语-挖', 414, '张三-挖', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (383, 1, 4, '挖掘机', 43, '英语-挖', 415, '李四-挖', 1, '2022-03-08', 10, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (384, 1, 4, '挖掘机', 43, '英语-挖', 416, '王五-挖', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (385, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 401, '小明-挖', 1, '2022-03-08', 5, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (386, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 402, '小红-挖', 1, '2022-03-08', 60, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (387, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 403, '小花-挖', 1, '2022-03-08', 9, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (388, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 414, '张三-挖', 1, '2022-03-08', 100, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (389, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 415, '李四-挖', 1, '2022-03-08', 80, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (390, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 416, '王五-挖', 1, '2022-03-08', 90, '2022-03-08 17:16:52.000000', '2022-03-08 17:16:54.000000'); INSERT INTO `tb_score` VALUES (391, 0, 1, '经济与管理', 11, '语文-经', 101, '小明-经', 1, '2022-03-14', 77, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (392, 0, 1, '经济与管理', 11, '语文-经', 102, '小红-经', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (393, 0, 1, '经济与管理', 11, '语文-经', 103, '小花-经', 1, '2022-03-14', 50, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (394, 1, 1, '经济与管理', 11, '语文-经', 114, '张三-经', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (395, 1, 1, '经济与管理', 11, '语文-经', 115, '李四-经', 1, '2022-03-14', 80, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (396, 1, 1, '经济与管理', 11, '语文-经', 116, '王五-经', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (397, 0, 1, '经济与管理', 12, '数学-经', 101, '小明-经', 1, '2022-03-14', 69, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (398, 0, 1, '经济与管理', 12, '数学-经', 102, '小红-经', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (399, 0, 1, '经济与管理', 12, '数学-经', 103, '小花-经', 1, '2022-03-14', 55, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (400, 1, 1, '经济与管理', 12, '数学-经', 114, '张三-经', 1, '2022-03-14', 35, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (401, 1, 1, '经济与管理', 12, '数学-经', 115, '李四-经', 1, '2022-03-14', 88, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (402, 1, 1, '经济与管理', 12, '数学-经', 116, '王五-经', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (403, 0, 1, '经济与管理', 13, '英语-经', 101, '小明-经', 1, '2022-03-14', 89, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (404, 0, 1, '经济与管理', 13, '英语-经', 102, '小红-经', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (405, 0, 1, '经济与管理', 13, '英语-经', 103, '小花-经', 1, '2022-03-14', 70, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (406, 1, 1, '经济与管理', 13, '英语-经', 114, '张三-经', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (407, 1, 1, '经济与管理', 13, '英语-经', 115, '李四-经', 1, '2022-03-14', 10, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (408, 1, 1, '经济与管理', 13, '英语-经', 116, '王五-经', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (409, 0, 1, '经济与管理', 14, '经济学-经', 101, '小明-经', 1, '2022-03-14', 5, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (410, 0, 1, '经济与管理', 14, '经济学-经', 102, '小红-经', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (411, 0, 1, '经济与管理', 14, '经济学-经', 103, '小花-经', 1, '2022-03-14', 9, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (412, 1, 1, '经济与管理', 14, '经济学-经', 114, '张三-经', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (413, 1, 1, '经济与管理', 14, '经济学-经', 115, '李四-经', 1, '2022-03-14', 80, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (414, 1, 1, '经济与管理', 14, '经济学-经', 116, '王五-经', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (415, 0, 2, '计算机', 21, '语文-计', 201, '小明-计', 1, '2022-03-14', 77, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (416, 0, 2, '计算机', 21, '语文-计', 202, '小红-计', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (417, 0, 2, '计算机', 21, '语文-计', 203, '小花-计', 1, '2022-03-14', 50, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (418, 1, 2, '计算机', 21, '语文-计', 214, '张三-计', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (419, 1, 2, '计算机', 21, '语文-计', 215, '李四-计', 1, '2022-03-14', 80, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (420, 1, 2, '计算机', 21, '语文-计', 216, '王五-计', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (421, 0, 2, '计算机', 22, '数学-计', 201, '小明-计', 1, '2022-03-14', 69, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (422, 0, 2, '计算机', 22, '数学-计', 202, '小红-计', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (423, 0, 2, '计算机', 22, '数学-计', 203, '小花-计', 1, '2022-03-14', 55, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (424, 1, 2, '计算机', 22, '数学-计', 214, '张三-计', 1, '2022-03-14', 35, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (425, 1, 2, '计算机', 22, '数学-计', 215, '李四-计', 1, '2022-03-14', 88, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (426, 1, 2, '计算机', 22, '数学-计', 216, '王五-计', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (427, 0, 2, '计算机', 23, '英语-计', 201, '小明-计', 1, '2022-03-14', 89, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (428, 0, 2, '计算机', 23, '英语-计', 202, '小红-计', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (429, 0, 2, '计算机', 23, '英语-计', 203, '小花-计', 1, '2022-03-14', 70, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (430, 1, 2, '计算机', 23, '英语-计', 214, '张三-计', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (431, 1, 2, '计算机', 23, '英语-计', 215, '李四-计', 1, '2022-03-14', 10, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (432, 1, 2, '计算机', 23, '英语-计', 216, '王五-计', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (433, 0, 2, '计算机', 24, '计算机-计', 201, '小明-计', 1, '2022-03-14', 5, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (434, 0, 2, '计算机', 24, '计算机-计', 202, '小红-计', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (435, 0, 2, '计算机', 24, '计算机-计', 203, '小花-计', 1, '2022-03-14', 9, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (436, 1, 2, '计算机', 24, '计算机-计', 214, '张三-计', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (437, 1, 2, '计算机', 24, '计算机-计', 215, '李四-计', 1, '2022-03-14', 80, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (438, 1, 2, '计算机', 24, '计算机-计', 216, '王五-计', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (439, 0, 3, '文学与历史', 31, '语文-文', 301, '小明-文', 1, '2022-03-14', 77, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (440, 0, 3, '文学与历史', 31, '语文-文', 302, '小红-文', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (441, 0, 3, '文学与历史', 31, '语文-文', 303, '小花-文', 1, '2022-03-14', 50, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (442, 1, 3, '文学与历史', 31, '语文-文', 314, '张三-文', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (443, 1, 3, '文学与历史', 31, '语文-文', 315, '李四-文', 1, '2022-03-14', 80, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (444, 1, 3, '文学与历史', 31, '语文-文', 316, '王五-文', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (445, 0, 3, '文学与历史', 32, '数学-文', 301, '小明-文', 1, '2022-03-14', 69, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (446, 0, 3, '文学与历史', 32, '数学-文', 302, '小红-文', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (447, 0, 3, '文学与历史', 32, '数学-文', 303, '小花-文', 1, '2022-03-14', 55, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (448, 1, 3, '文学与历史', 32, '数学-文', 314, '张三-文', 1, '2022-03-14', 35, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (449, 1, 3, '文学与历史', 32, '数学-文', 315, '李四-文', 1, '2022-03-14', 88, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (450, 1, 3, '文学与历史', 32, '数学-文', 316, '王五-文', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (451, 0, 3, '文学与历史', 33, '英语-文', 301, '小明-文', 1, '2022-03-14', 89, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (452, 0, 3, '文学与历史', 33, '英语-文', 302, '小红-文', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (453, 0, 3, '文学与历史', 33, '英语-文', 303, '小花-文', 1, '2022-03-14', 70, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (454, 1, 3, '文学与历史', 33, '英语-文', 314, '张三-文', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (455, 1, 3, '文学与历史', 33, '英语-文', 315, '李四-文', 1, '2022-03-14', 10, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (456, 1, 3, '文学与历史', 33, '英语-文', 316, '王五-文', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (457, 0, 3, '文学与历史', 34, '世界史-文', 301, '小明-文', 1, '2022-03-14', 5, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (458, 0, 3, '文学与历史', 34, '世界史-文', 302, '小红-文', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (459, 0, 3, '文学与历史', 34, '世界史-文', 303, '小花-文', 1, '2022-03-14', 9, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (460, 1, 3, '文学与历史', 34, '世界史-文', 314, '张三-文', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (461, 1, 3, '文学与历史', 34, '世界史-文', 315, '李四-文', 1, '2022-03-14', 80, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (462, 1, 3, '文学与历史', 34, '世界史-文', 316, '王五-文', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (463, 0, 4, '挖掘机', 41, '语文-挖', 401, '小明-挖', 1, '2022-03-14', 77, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (464, 0, 4, '挖掘机', 41, '语文-挖', 402, '小红-挖', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (465, 0, 4, '挖掘机', 41, '语文-挖', 403, '小花-挖', 1, '2022-03-14', 50, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (466, 1, 4, '挖掘机', 41, '语文-挖', 414, '张三-挖', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (467, 1, 4, '挖掘机', 41, '语文-挖', 415, '李四-挖', 1, '2022-03-14', 80, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (468, 1, 4, '挖掘机', 41, '语文-挖', 416, '王五-挖', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (469, 0, 4, '挖掘机', 42, '数学-挖', 401, '小明-挖', 1, '2022-03-14', 69, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (470, 0, 4, '挖掘机', 42, '数学-挖', 402, '小红-挖', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (471, 0, 4, '挖掘机', 42, '数学-挖', 403, '小花-挖', 1, '2022-03-14', 55, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (472, 1, 4, '挖掘机', 42, '数学-挖', 414, '张三-挖', 1, '2022-03-14', 35, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (473, 1, 4, '挖掘机', 42, '数学-挖', 415, '李四-挖', 1, '2022-03-14', 88, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (474, 1, 4, '挖掘机', 42, '数学-挖', 416, '王五-挖', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (475, 0, 4, '挖掘机', 43, '英语-挖', 401, '小明-挖', 1, '2022-03-14', 89, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (476, 0, 4, '挖掘机', 43, '英语-挖', 402, '小红-挖', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (477, 0, 4, '挖掘机', 43, '英语-挖', 403, '小花-挖', 1, '2022-03-14', 70, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (478, 1, 4, '挖掘机', 43, '英语-挖', 414, '张三-挖', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (479, 1, 4, '挖掘机', 43, '英语-挖', 415, '李四-挖', 1, '2022-03-14', 10, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (480, 1, 4, '挖掘机', 43, '英语-挖', 416, '王五-挖', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (481, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 401, '小明-挖', 1, '2022-03-14', 5, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (482, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 402, '小红-挖', 1, '2022-03-14', 60, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (483, 0, 4, '挖掘机', 44, '挖掘机实操-挖', 403, '小花-挖', 1, '2022-03-14', 9, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (484, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 414, '张三-挖', 1, '2022-03-14', 100, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (485, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 415, '李四-挖', 1, '2022-03-14', 80, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); INSERT INTO `tb_score` VALUES (486, 1, 4, '挖掘机', 44, '挖掘机实操-挖', 416, '王五-挖', 1, '2022-03-14', 90, '2022-03-14 17:16:52.000000', '2022-03-14 17:16:54.000000'); SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_score_summary -- ---------------------------- DROP TABLE IF EXISTS `tb_score_summary`; CREATE TABLE `tb_score_summary` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profession_id` int(11) NOT NULL COMMENT '专业id', `exams_version` int(11) NOT NULL COMMENT '考试次数，第一次考不过可以补考，觉得自己没发挥好也可以再考', `exams_date` date NOT NULL COMMENT '考试日期', `score_total` bigint(20) NOT NULL COMMENT '考试成绩', `total_concat` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '以{标注员：总成绩}组成的json字符串', `add_time` datetime(6) NOT NULL, `modify_time` datetime(6) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 123 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_score_summary -- ---------------------------- INSERT INTO `tb_score_summary` VALUES (103, 1, 1, '2022-02-11', 1617, '{\"student_id\":101, \"score_total\":77};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":50};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":69};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":55};{\"student_id\":114, \"score_total\":35};{\"student_id\":115, \"score_total\":88};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":89};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":70};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":10};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":5};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":9};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (104, 1, 1, '2022-02-15', 1617, '{\"student_id\":101, \"score_total\":77};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":50};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":69};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":55};{\"student_id\":114, \"score_total\":35};{\"student_id\":115, \"score_total\":88};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":89};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":70};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":10};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":5};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":9};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (105, 1, 1, '2022-02-22', 1617, '{\"student_id\":101, \"score_total\":77};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":50};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":69};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":55};{\"student_id\":114, \"score_total\":35};{\"student_id\":115, \"score_total\":88};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":89};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":70};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":10};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":5};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":9};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (106, 1, 1, '2022-03-08', 1617, '{\"student_id\":101, \"score_total\":77};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":50};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":69};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":55};{\"student_id\":114, \"score_total\":35};{\"student_id\":115, \"score_total\":88};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":89};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":70};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":10};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":5};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":9};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (107, 1, 1, '2022-03-14', 1617, '{\"student_id\":101, \"score_total\":77};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":50};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":69};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":55};{\"student_id\":114, \"score_total\":35};{\"student_id\":115, \"score_total\":88};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":89};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":70};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":10};{\"student_id\":116, \"score_total\":90};{\"student_id\":101, \"score_total\":5};{\"student_id\":102, \"score_total\":60};{\"student_id\":103, \"score_total\":9};{\"student_id\":114, \"score_total\":100};{\"student_id\":115, \"score_total\":80};{\"student_id\":116, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (108, 2, 1, '2022-02-11', 1617, '{\"student_id\":201, \"score_total\":77};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":50};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":69};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":55};{\"student_id\":214, \"score_total\":35};{\"student_id\":215, \"score_total\":88};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":89};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":70};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":10};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":5};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":9};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (109, 2, 1, '2022-02-15', 1617, '{\"student_id\":201, \"score_total\":77};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":50};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":69};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":55};{\"student_id\":214, \"score_total\":35};{\"student_id\":215, \"score_total\":88};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":89};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":70};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":10};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":5};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":9};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (110, 2, 1, '2022-02-22', 1617, '{\"student_id\":201, \"score_total\":77};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":50};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":69};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":55};{\"student_id\":214, \"score_total\":35};{\"student_id\":215, \"score_total\":88};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":89};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":70};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":10};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":5};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":9};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (111, 2, 1, '2022-03-08', 1617, '{\"student_id\":201, \"score_total\":77};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":50};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":69};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":55};{\"student_id\":214, \"score_total\":35};{\"student_id\":215, \"score_total\":88};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":89};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":70};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":10};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":5};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":9};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (112, 2, 1, '2022-03-14', 1617, '{\"student_id\":201, \"score_total\":77};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":50};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":69};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":55};{\"student_id\":214, \"score_total\":35};{\"student_id\":215, \"score_total\":88};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":89};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":70};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":10};{\"student_id\":216, \"score_total\":90};{\"student_id\":201, \"score_total\":5};{\"student_id\":202, \"score_total\":60};{\"student_id\":203, \"score_total\":9};{\"student_id\":214, \"score_total\":100};{\"student_id\":215, \"score_total\":80};{\"student_id\":216, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (113, 3, 1, '2022-02-11', 1617, '{\"student_id\":301, \"score_total\":77};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":50};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":69};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":55};{\"student_id\":314, \"score_total\":35};{\"student_id\":315, \"score_total\":88};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":89};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":70};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":10};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":5};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":9};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (114, 3, 1, '2022-02-15', 1617, '{\"student_id\":301, \"score_total\":77};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":50};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":69};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":55};{\"student_id\":314, \"score_total\":35};{\"student_id\":315, \"score_total\":88};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":89};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":70};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":10};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":5};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":9};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (115, 3, 1, '2022-02-22', 1617, '{\"student_id\":301, \"score_total\":77};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":50};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":69};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":55};{\"student_id\":314, \"score_total\":35};{\"student_id\":315, \"score_total\":88};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":89};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":70};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":10};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":5};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":9};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (116, 3, 1, '2022-03-08', 1617, '{\"student_id\":301, \"score_total\":77};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":50};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":69};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":55};{\"student_id\":314, \"score_total\":35};{\"student_id\":315, \"score_total\":88};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":89};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":70};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":10};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":5};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":9};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (117, 3, 1, '2022-03-14', 1617, '{\"student_id\":301, \"score_total\":77};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":50};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":69};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":55};{\"student_id\":314, \"score_total\":35};{\"student_id\":315, \"score_total\":88};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":89};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":70};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":10};{\"student_id\":316, \"score_total\":90};{\"student_id\":301, \"score_total\":5};{\"student_id\":302, \"score_total\":60};{\"student_id\":303, \"score_total\":9};{\"student_id\":314, \"score_total\":100};{\"student_id\":315, \"score_total\":80};{\"student_id\":316, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (118, 4, 1, '2022-02-11', 1617, '{\"student_id\":401, \"score_total\":77};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":50};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":69};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":55};{\"student_id\":414, \"score_total\":35};{\"student_id\":415, \"score_total\":88};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":89};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":70};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":10};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":5};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":9};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (119, 4, 1, '2022-02-15', 1617, '{\"student_id\":401, \"score_total\":77};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":50};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":69};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":55};{\"student_id\":414, \"score_total\":35};{\"student_id\":415, \"score_total\":88};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":89};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":70};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":10};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":5};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":9};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (120, 4, 1, '2022-02-22', 1617, '{\"student_id\":401, \"score_total\":77};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":50};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":69};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":55};{\"student_id\":414, \"score_total\":35};{\"student_id\":415, \"score_total\":88};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":89};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":70};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":10};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":5};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":9};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (121, 4, 1, '2022-03-08', 1617, '{\"student_id\":401, \"score_total\":77};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":50};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":69};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":55};{\"student_id\":414, \"score_total\":35};{\"student_id\":415, \"score_total\":88};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":89};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":70};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":10};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":5};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":9};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); INSERT INTO `tb_score_summary` VALUES (122, 4, 1, '2022-03-14', 1617, '{\"student_id\":401, \"score_total\":77};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":50};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":69};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":55};{\"student_id\":414, \"score_total\":35};{\"student_id\":415, \"score_total\":88};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":89};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":70};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":10};{\"student_id\":416, \"score_total\":90};{\"student_id\":401, \"score_total\":5};{\"student_id\":402, \"score_total\":60};{\"student_id\":403, \"score_total\":9};{\"student_id\":414, \"score_total\":100};{\"student_id\":415, \"score_total\":80};{\"student_id\":416, \"score_total\":90}', '2022-03-05 15:47:43.768280', '2022-03-05 15:47:43.768280'); SET FOREIGN_KEY_CHECKS = 1;
DELETE FROM tb_score_summary; INSERT INTO tb_score_summary (profession_id,exams_date,exams_version,score_total,total_concat) SELECT profession_id,exams_date,exams_version,score_total,total_concat FROM (SELECT profession_id,exams_date,exams_version,SUM(score_total) AS score_total, GROUP_CONCAT(CONCAT('{"student_id":', student_id, ', "score_total":',score_total,'}') SEPARATOR ';') as total_concat FROM tb_score GROUP BY profession_id,exams_date,exams_version) AS tb