数据库应用题（在线等）

1.
SELECT C#,CNAME
FROM C
WHERE TECHER=王老师;
2.
ELECT S#，SNAME
FROM S
WHERE AGE>22 AND SEX='男';
3.
ELECT CNAME,TEACHER
FROM SC,C
WHERE SC.C#=C.C# AND S#=1001;
4.
ELECT SNAME
FROM S,SC,C
WHERE S.S#=SC.S# AND SC.C#=C.C# AND TEACHER=王老
师 AND SEX='女';

1、select c#,cname from c where teacher='王老师'

2、select s#,sname from s where sex='男' and ag>22

3、select cname,teacher from c where c#=(select c# from sc where s#=10001)

4、select sname from s where sex='女' and s# in(select s# from sc where c# in(select c# from c where teacher='王老师'))

1.select c#,CNAME from C where TEACHER='王老师'
2.select s#,SNAME from S where AGE>33 and sSEX='男'
3.select CNAME,TEACHER from C where C# in(select C# from SC,S where s.s#=SC.S# and s.s#='10001')
第四个弄了半天搞不出来，希望高手指导一下

4.select sname from s
where s.sex='女' and exits(
select * from sc where s.s#=sc.s#
and exits(select * from c
where c.c#=s.c# and
teacher like '王%')