数据库第三章作业

第三大题
3.1
SELECT *
FROM S
WHERE A='10';
3.2
SELECT A,B
FROM S;
3.3
SELECT A,B,C,D,E,F
FROM S,T
WHERE S.C=T.C AND S.D=T.D;
3.4
SELECT A,B,C,D,E,F
FROM S,T
WHERE S.C=T.C;
3.5
SELECT *
FROM S,T
WHERE S.A<T.E;
3.6
SELECT

第四题

```create table S(SNO char(2),
			   SNAME char(10),
			   STATUS smallint,
			   CITY char(10))

create table P(PNO char(2),
			   PNAME char(10),
			   COLOR char(2),
			   WEIGHT smallint)

create table J(JNO char(2),
			   JNAME char(10),
			   CITY char(10))

create table SPJ(SNO char(2),
				 PNO char(2),
				 JNO char(2),
				 QTY smallint)


	INSERT INTO S
	VALUES ('S1','精益',20,'天津');
	INSERT INTO S
	VALUES ('S2','盛锡',10,'北京');
	INSERT INTO S
	VALUES (