数据库上机考试、跪求大神 跪求答案、、

1.select sno from spj where sno=j1;
2.select sno from spj where sno=j1 and pno = p1;
3.select sno from spj where sno = j1 and pno in ( select pno from p where color = red)
4.select jno from spj where sno not in ( select sno from s where city = tianjin)
And pno not in ( select pno from p where color = red)
5.select sname city from s
6.select PNAME，COLOR，WEIGHT from p;
7.select jno from spj where sno = s1;
8. select pname ,qty from spj as a ,p as b where a.pno = b.pno and jno = j2
9. select pno from s , spj where s.no = spj.sno and city = shanghai;
10. select jno from s , spj where s.no = spj.sno and city = shanghai
11.select jno from s , spj where s.no = spj.sno and city ! = tianjin