select institute,classname,a.sno,sname,sum(credithour);
from student a,class b,course c,achievement d;
where a.sno=d.sno;
and a.classno=b.classno;
and c.cno=d.cno;
group by institute,classname;
order by sum(credithour) desc;
to file D:\个人重要资料(勿删)\Owner\桌面\kk.doc ADDITIVE
运行了,但不知道哪里错了,恳请高人解答。