sub_cj.qpr

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

SELECT xsb.bj AS 班级名称,COUNT(xsb.xh) 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 kcb.kcm = SC1;
GROUP BY xsb.bj;
ORDER BY xsb.bj;
INTO TABLE sub_cj.dbf