数据库原理及应用孟彩霞版实验3~8 - 图文

(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