第1个回答 2010-01-04
1:
create table s(s# int primary key,sname varchar(20),age int,sex varchar(2);
2:
insert into s values('20070701','lilin',20,'女')
3:
select c#,cname from c where teacher='张老师';
4:select s#,sname from sc where age>23 and sex='男';
5:
select s# from s where(选修课程 in (select 选修课程 from c where tacher='liu考试'))
第2个回答 2010-01-06
skndkfjnfkank,fjnsk,gjns,jngkljghnkh,egnka
第3个回答 2010-01-02
1.create table S S# char(10),Sname char(20),age integer,sex char(20)
2.insert into S(S#,Sname,age,sex) values('20070101','Li Lin',20,'女')
3.select C#,Cname from C where Teacher='zhang'
4.select S#,Sname from S where age>23 and sex='男'
5.select S# from S inner join SC on S.S#=SC.S# inner join C on SC.C#=C.C# and C.Teacher='Liu'本回答被提问者采纳