stu查询练习.docVIP

样例数据库结构 数据库名:stu 数据库有以下几表: student 学员表 列名 数据类型 含义 stu_id int 主键,标识列 stu_name nvarchar(20) 性名 stu_age int 年龄，默认15 stu_sex bit 姓别，1男，0女 teacher 教师表 列名 数据类型 含义 tea_id int 主键,标识列 tea_name nvarchar(20) 教师名，唯一 course 课程项 列名 数据类型 含义 cou_id int 主键 cou_name nvarchar(20) 课程名 cou_tea_id int 外键，教师 score 成绩表 列名 数据类型 含义 stu_id int 外键，学员 cou_id int 外键，课程 score varchar(50) 分数 测试数据 SET IDENTITY_INSERT student ON GO INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (1,李红,17,0) INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (2,王米,17,0) INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (3,戴小凤,19,0) INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (4,李小凤,17,0) INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (5,陈红,18,0) INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (6,张喜,17,1) INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (7,李刚,16,1) INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (8,张正峰,16,1) INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (9,王君,16,1) INSERT INTO student(stu_id,stu_name,stu_age,stu_sex) VALUES (10,吴越,17,1) SET IDENTITY_INSERT student OFF SET IDENTITY_INSERT teacher ON INSERT INTO teacher (tea_id,tea_name) VALUES (1,李果) INSERT INTO teacher (tea_id,tea_name) VALUES (2,毛勇军) INSERT INTO teacher (tea_id,tea_name) VALUES (3,范君蒲) INSERT INTO teacher (tea_id,tea_name) VALUES (4,卢君红) SET IDENTITY_INSERT teacher OFF INSERT INTO course(cou_id,cou_name,cou_tea_id) VALUES (1,数学,2) INSERT INTO course(cou_id,cou_name,cou_tea_id) VALUES (2,历史,3) INSERT INTO course(cou_id,cou_name,cou_tea_id) VALUES (3,语文,1) INSERT INTO course(cou_id,cou_name,cou_tea_id) VALUES (4,英语,4) INSERT INTO score(stu_id,cou_id,score) VALUES (1,1,67) INSERT INTO score(stu_id,cou_id,score) VALUES (1,2,59) INSERT INTO score(stu_id,cou_id,score) VALUES (1,3,77) INSERT INTO score(stu_id,cou_id,score) VALUES (1,4,54) INSERT INTO score(stu_id,cou_id,score) VALUES (2,1,78) INSERT INTO score(st