1select jname from jwhere color='red' and weight>2select sno,pno,qty from spjgroup by sno,3select sname from s,j,p,spjwhere ity='北京' and jname='齿轮'and sno=sno and jno=jno and pno=4create view green_j(jno,jname,weight)asselect jno,jname,weight from jwhere color='green'2select 作者名,书名,出版社 from 图书,作者where 图书作者编号=作者作者编号 and 年龄<(select avg(年龄) from 作者)1select 学生学号,max(姓名),max(专业) from 学生,学习where 奖学金 is null and 学生学号=学习学号group by 学生学号having max(分数)>2create view AAA(课程号,名称,学分)asselect 课程号,名称,学分 from 课程,学习where 课程课程号=学习课程号group by 课程号,名称,学分having max(分数)=100速度给分
