sumcj.prg

学生管理系统本系统由1个数据库、3个查询

close data
public c1,c2,c3,c4,c5,c6,c7 
open data test
use xscj
calculate avg(cj) to c1
calculate avg(cj) for xb="男" to c3
calculate avg(cj) for xb="女" to c4
calculate avg(cj) for bj="物电院04级电子1班" to c2
calculate avg(cj) for bj="物电院04级电子2班" to c5
calculate avg(cj) for bj="物电院04级物理1班" to c7
calculate avg(cj) for bj="物电院04级物理2班" to c6
use