3.有两个关系S(A,B,C,D)和T(C,D,E,F),写出与下列查询等价的SQL表达式:
(1)σ A=10(S)
SELECT *
FROM S
WHERE A=10;
(2)π A , B ( S )
SELECT A,B
FROM S;
(3)S ⋈ T
SELECT S.A,S.B,C,D,E,F
FROM S,T
WHERE S.C=T.C AND S.D=T.D;
(4)
SELECT *
FROM S,T
WHERE S.C=T.C;
(5)
SELECT *
FROM S,T
WHERE S.A<T.E;
(6)
SELECT S.C,S.D,T.*
FROM S,T;
或
SELECT *
FROM S,T
WHERE S.C=T.C AND S.D=T.D;
4.用SQL语句建立第2章习题6中的4个表;针对建立的4各表用SQL完成第2章习题6中的查询
CREATE TABLE S(SNO CHAR(5) UNIQUE,
SNAME CHAR(20),
STATUS INT,
CITY CHAR(10)
);
CREATE TABLE P(PNO CHAR(5) UNIQUE,
PNAME CHAR(20),
COLOR CHAR(5),
WEIGHT INT
);
CREATE TABLE J(JNO CHAR(5) UNIQUE,
JNAME CHAR(20),
CITY CHAR(10)
);
CREATE TABLE SPJ(SNO CHAR(5),
PNO CHAR(5),
JNO CHAR(5),
QTY INT
);
INSERT INTO S
VALUES ('S1','精益',20,'天津');
INSERT INTO S
VALUES ('S2','盛锡',10,'北京');
INSERT INTO S
VALUES ('S3','东方红',20,'北京');
INSERT INTO S
VALUES ('S4',