(select *
from 学生选课表SC SCZ
where SCZ.Sno=SCX.Sno and SCZ.Cno=SCY.Cno));
47.
select Sno from 学生选课表SC where Cno='1' union select Sno
from 学生选课表SC where Cno='2';
（2） 6.
select CustomerID,GoodsID,OrderID from Orders
where Quantity>200 order by OrderDate;
7.
select * from Orders
where CustomerID in (select CustomerID from Customers where City='北京');
8.
select * from Orders
where CustomerID not in (select CustomerID from Customers where City='天津');
9.
select Customers.CustomerID,CName,City,OrderID, GoodsID,Quantity,OrderSum,OrderDate from Customers left outer join Orders
on Customers.CustomerID=Orders.CustomerID where City='西安';
(3) 5.3-4
select jno from J where jno not in (select jno from SPJ,S,P
where SPJ.sno=S.sno and SPJ.pno=P.pno and city='天津'
and color='红');
5.3-5
SELECT DIST PNO FROM SPJ WHERE SNO='S1' SELECT JNO FROM SPJ WHERE PNO='P1'
AND JNO IN (SELECT JNO FROM SPJ WHERE PNO='P2')
(4)
试验6 1
2 （1） 54
Create view c_学生表Student as
