SQL练习题

(一)测试表格

–1.学生表
Student(S,Sname,Sage,Ssex)

–S 学生编号,Sname 学生姓名,Sage 出生年月,Ssex 学生性别

–2.课程表
Course(C,Cname,T)

–C --课程编号,Cname 课程名称,T 教师编号

–3.教师表
Teacher(T,Tname)

–T 教师编号,Tname 教师姓名

–4.成绩表
SC(S,C,score)

–S 学生编号,C 课程编号,score 分数

创建测试数据

学生表 Student

create table Student(S# varchar(10),Sname nvarchar(10),Sage datetime,Ssex nvarchar(10))
insert into Student values(‘01’ , ‘赵梅’ , ‘1990-01-01’ , ‘男’)
insert into Student values(‘02’ , ‘王风’ , ‘1990-12-21’ , ‘男’)
insert into Student values(‘03’ , ‘孙电’ , ‘1990-05-20’ , ‘男’)
insert into Student values(‘04’ , ‘李云’ , ‘1990-08-06’ , ‘男’)
insert into Student values(‘05’ , ‘周竹’ , ‘1991-12-01’ , ‘女’)
insert into Student values(‘06’ , ‘吴兰’ , ‘1992-03-01’ , ‘女’)
insert into Student values(‘07’ , ‘郑雷’ , ‘1989-07-01’ , ‘女’)
insert into Student values(‘08’ , ‘钱菊’ , ‘19