数据库作业10：第三章课后题

3、有两个关系S(A,B,C,D)和T(C,D,E,F),写出与下列查询等价的SQL表达式；

SELECT *
FROM S
WHERE A='10';

SELECT A,B
FROM S;

SELECT A,B,S.C,S.D,E,F
FROM S,T
WHERE S.C=T.C AND S.D=T.D;
//⋈：自然连接，去掉重复列

SELECT *
FROM S,T
WHERE S.C=T.C;

SELECT *
FROM S,T
WHERE A<E;

SELECT S.C,S.D,T.*
FROM S,T；

/*建表S并插入数据*/
CREATE TABLE S(SNO nchar(10),
			   SNAME nchar(10),
			   STATUS int,
			   CITY char(10))
INSERT INTO S VALUES('S1','精益',20,'天津');
INSERT INTO S VALUES('S2','盛锡',10,'北京');
INSERT INTO S VALUES('S3','东方红',30,'北京');
INSERT INTO S VALUES('S4','丰泰盛',20,'天津');
INSERT INTO S VALUES('S5','为民',30,'上海');

/*建立P表并插入数据*/
CREATE TABLE P(PNO nchar(10),
			   PNAME nchar(10),
			   COLOR nchar(