stucount)+'%' as 及格率,convert(varchar(10),sum(case when (html+sql)/2>=80 then 1 else 0 end)*100.0/stucount)+'%' as 优秀率 from exam e,(select count(1) as stucount from stuinfo) a
CREATE OR REPLACE PROCEDURE PRO_CHENGJI IS V_AVG NUMBER(12);CURSOR C_STU IS SELECT * FROM 学生表;BEGIN FOR C_S IN C_STU LOOP SELECT AVG(A.成绩) INTO V_AVG FROM 成绩表 A WHERE A.学生编号=C_S.学生编号;IF V_AVG >=80 THEN DBMS_OUTPUT.put_line('优秀学生编号：'||C_...