查询各科成绩前三名的记录_SQL笔记：在一张包含学生ID、课程、成绩的表中，检索各科前三名...

表定义 及 测试数据

CREATE TABLE `score_info` (  `student_id` int NOT NULL AUTO_INCREMENT,  `category` varchar(255) DEFAULT NULL,  `score` int DEFAULT NULL,  PRIMARY KEY (`student_id`)) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;INSERT INTO `score_info` VALUES ('1', '语', '99');INSERT INTO `score_info` VALUES ('2', '数', '32');INSERT INTO `score_info` VALUES ('3', '外', '88');INSERT INTO `score_info` VALUES ('4', '语', '89');INSERT INTO `score_info` VALUES ('5', '数', '57');INSERT INTO `score_info` VALUES ('6', '外', '67');INSERT INTO `score_info` VALUES ('7', '语', '72');INSERT INTO `score_info` VALUES ('8', '数', '48');INSERT INTO `score_info` VALUES ('9', '外', '53');INSERT INTO `score_info` VALUES ('10', '语', '96');INSERT INTO `score_info` VALUES ('11', '数', '69');INSERT INTO `score_info` VALUES ('12', '数', '39');INSERT INTO `score_in