题目
有如下三种表及表结构:G1201A(stuID,classID,stuName),分别对应学生编号,班级编号,学生姓名
G1201B(classID,className),分别对应班级编号,班级名称
G1201C(stuID,course,score),分别对应学生编号,课程名称,考试成绩
查询一班各科成绩最高的学生姓名?
测试数据
CREATE TABLE G1201A(
stuID INT,
classID VARCHAR(10),
stuName VARCHAR(20)
)
INSERT INTO G1201A VALUES(1,'A','zhang');
INSERT INTO G1201A VALUES(2,'A','li');
INSERT INTO G1201A VALUES(3,'B','wang');
CREATE TABLE G1201B (
classID VARCHAR(10),
className VARCHAR(20)
)
INSERT INTO G1201B VALUES('A','一班');
INSERT INTO G1201B VALUES('B','二班');
CREATE TABLE G1201C (
stuID INT,
course VARCHAR(20),
score INT
)
INSERT INTO G1201C VALUES (1,'语文',80);
INSERT INTO G1201C VALUES (1,'数学',90);
INSERT INTO G1201C VALUES (1,'英语',70);
INSERT INTO G1201C VALUES (2,'语文',89);
INSERT INTO G1201C VALUES (2,'数学',91);
INSERT INTO G1201C VALUES (2,'英语',88);
INSERT INTO G1201C VALUES (3,'语文',75);
INSERT INTO G1201C VALUES (3,'数学',77);
INSERT INTO G1201C VALUES (3,'英语',72);
参考答案