专升本选了这个专业，以为远离了高数却迎来了数据库，SQL求高手

(1)
create table S (……)
……
……
详情略，您自己查一查create table语句应该没问题。
注意其中的not null选项、primary key等选项的应用（比如各个表中的no列会用到）
（2）
A、
select distinct SNO from SPJ where JNO in (select JNO where JNAME='J1')
其中distinct选项是选择不重复的。您可以去掉这个选项看看效果不同的情况。
B、
select distinct SNO from SPJ
where JNO in (select JNO where JNAME='J1')
and PNO in (select PNO where PCOLOR='红')
C、
select JNAME from J
where JNO not in (
select a.JNO from SPJ a,S b where b.SNO=a.SNO and b.CITY='天津')
D、
update SPJ set SNO=(select SNO from S where SNAME='S3')
where SNO in (select SNO from S where SNAME='S5')
and PNO in (select PNO from P where PNAME='P6')
and JNO in (select JNO from J where JNAME='J4')
E、
不会

（1）用SQL语句建立上述四个表。
create table S(SNO not null,SNAME not null,STATUS,CITY,primary key(SNO));
create table P(PNO not null,PNAME not null,COLOR,WEIGHT SMALLINT,primary key(PNO));
create table J(JNO not null,JNAME not null,CITY,primary key(PNO));
create table SPJ(SNO not null,PNO not null,JON not null, QTY SMALLINT,primary key (SNO,PNO,JNO),
foreigh key (SNO) references S(SNO),
foreigh key (PNO) references P(PNO),
foreigh key (JNO) references J(JNO),);
（2）完成以下查询：
A、求供求工程J1零件的供应商号码SNO；
select distinct SNO from SPJ where JNO in (select JNO where JNAME='J1')
其中distinct选项是选择不重复的。
B、求供应工程J1零件为红色的供应商号码SNO。
select distinct SNO from SPJ
where JNO in (select JNO where JNAME='J1')
and PNO in (select PNO where PCOLOR='红')
C、找出没有使用天津产的零件的工程名称。
select JNAME from J
where JNO not in (
select a.JNO from SPJ a,S b where b.SNO=a.SNO and b.CITY='天津')
D、由S5供应给J4的零件P6改为由S3供应。
update SPJ set SNO=(select SNO from S where SNAME='S3')
where SNO in (select SNO from S where SNAME='S5')
and PNO in (select PNO from P where PNAME='P6')
and JNO in (select JNO from J where JNAME='J4')
E、把对SPJ表修改QTY属性对权限授予用户李天明。
GRANT UPDATE（Qty）ON TABLE SPJ TO 李天明.