--11． 把平均成绩大于80分的男同学的学号和平均成绩存入另一个表S——GRADE（SNO，AVG_GRADE）；
//*create view sss_grade(sno,gavg)
as
select sno,avg(grade)
from SC,S
where SC.sno=S.sno and S.ssex='男'
group by sno
having avg(grade)>80;
select *
from sss_grade*/

[此贴子已经被作者于2007-4-16 9:54:54编辑过]

create table ss1_grade
( sno char(9),
avg_grade smallint);
insert
into ss1_grade(SC.sno,avg_grade)
select SC.sno,avg(grade)
from SC,S
where SC.sno=S.sno and S.ssex='男'
group by SC.sno
having avg(grade)>80;*/用这能成功但是我想用视图做做，大家帮帮忙

不行啊
还是谢谢棉花糖了