qry2.qpr

来自「班级管理数据库系统」· QPR 代码 · 共 6 行

SELECT Xsqk.性别, Max(语文) As 语文最高分, Min(语文) As 语文最低分,;
  Sum(语文) As 语文总分, Avg(语文) As 语文平均分;
 FROM  db_bjgl!xsqk INNER JOIN db_bjgl!xscj ;
   ON  Xsqk.学号 = Xscj.学号;
 GROUP BY Xsqk.性别