qry2.qpr

班级管理数据库系统

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.性别