select S#,Sname avg(grade) into A from s left outer join 成绩表 on 学生表.S#=成绩表.S# group by 成绩表.s#
insert table a (sname,AvgGrade) select top 1 s.sname,avg(sc.grade) as AvgGrade from s,sc where s.S#=SC.S# group by s.sname order by AvgGrade desc
INSERT INTO A (SELECT S.SNAME,AVG(SC.GRADE) FROM S,C,SC WHERE S.S# = SC.S# GROUP BY S.SNAME HAVING AVG(SC.GRADE) >= ALL( SELECT MAX(AVG(SC.GRADE)) FROM SC GROUP BY SC.S#))
select s.sname, c.cname, A.grade from (select c#, max(grade) as grade from sc group by c#) as A, sc, s, c where A.c# = sc.c# and A.grade = sc.grade and sc.s# = s.s# and sc.c# = c.c#
INSERT INTO A (sname,AvgGrade) ( select s.sname, A.grade from (select s#, avg(grade) as grade from sc group by s#) as A, (select max(avg(grade)) as grade from sc group by s#) as B, s where A.grade = B.grade and A.s# = s.s# )
(sname,AvgGrade)
select top 1 s.sname,avg(sc.grade) as AvgGrade
from s,sc
where s.S#=SC.S#
group by s.sname
order by AvgGrade desc
(SELECT S.SNAME,AVG(SC.GRADE)
FROM S,C,SC
WHERE S.S# = SC.S#
GROUP BY S.SNAME
HAVING AVG(SC.GRADE) >= ALL( SELECT MAX(AVG(SC.GRADE))
FROM SC
GROUP BY SC.S#))
select s.sname, c.cname, A.grade from
(select c#, max(grade) as grade from sc group by c#) as A,
sc, s, c
where A.c# = sc.c#
and A.grade = sc.grade
and sc.s# = s.s#
and sc.c# = c.c#
INSERT INTO A (sname,AvgGrade)
(
select s.sname, A.grade from
(select s#, avg(grade) as grade from sc group by s#) as A,
(select max(avg(grade)) as grade from sc group by s#) as B,
s
where A.grade = B.grade
and A.s# = s.s#
)