第三大题
3.1SELECT*FROM S
WHERE A='10';3.2SELECT A,B
FROM S;3.3SELECT A,B,C,D,E,F
FROM S,T
WHERE S.C=T.C AND S.D=T.D;3.4SELECT A,B,C,D,E,F
FROM S,T
WHERE S.C=T.C;3.5SELECT*FROM S,T
WHERE S.A<T.E;3.6SELECT
第四题
```createtable S(SNO char(2),
SNAME char(10),STATUSsmallint,
CITY char(10))createtable P(PNO char(2),
PNAME char(10),
COLOR char(2),
WEIGHT smallint)createtable J(JNO char(2),
JNAME char(10),
CITY char(10))createtable SPJ(SNO char(2),
PNO char(2),
JNO char(2),
QTY smallint)INSERTINTO S
VALUES('S1','精益',20,'天津');INSERTINTO S
VALUES('S2','盛锡',10,'北京');INSERTINTO S
VALUES(