sqlserver经典查询练习.docVIP

经典练习 --创建测试数据 create table Student(S# varchar(10),Sname nvarchar(10),Sage datetime,Ssex nvarchar(10)) insert into Student values(01 , N赵雷 , 1990-01-01 , N男) insert into Student values(02 , N钱电 , 1990-12-21 , N男) insert into Student values(03 , N孙风 , 1990-05-20 , N男) insert into Student values(04 , N李云 , 1990-08-06 , N男) insert into Student values(05 , N周梅 , 1991-12-01 , N女) insert into Student values(06 , N吴兰 , 1992-03-01 , N女) insert into Student values(07 , N郑竹 , 1989-07-01 , N女) insert into Student values(08 , N王菊 , 1990-01-20 , N女) create table Course(C# varchar(10),Cname nvarchar(10),T# v