📄 cla_cj.qpr
字号:
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -