cla_cj.qpr

来自「学生管理系统本系统由1个数据库、3个查询」· QPR 代码 · 共 12 行

SELECT cjb.kch AS 课程号   , kcb.kcm AS 课程名称,;
kcb.js AS 任课教师,kcb.xf AS 学分,AVG(cjb.cj) as 平均分,;
MAX(cjb.cj) as 最高分,MIN(cjb.cj) as 最低分;
FROM test!xsb INNER JOIN test!cjb;
INNER JOIN test!kcb ;
ON kcb.kch = cjb.kch ;
ON xsb.xh = cjb.xh;
WHERE xsb.bj = CC1;
GROUP BY cjb.kch;
ORDER BY cjb.kch;
INTO TABLE class_cj.dbf