查询5.qpr

VFP做的数据的查询与设计

SELECT IIF(Student.性别,'男','女'), AVG(Scores.数学成绩),;
  SUM(Scores.数学成绩);
 FROM  campus!student INNER JOIN campus!scores ;
   ON  Student.身份证号码 = Scores.身份证号码;
 GROUP BY 1