Question

vfp 统计满足条件的个数我有cj.dbf(成绩表),其部分字段是bj(班级),yw(语文),sx(数学),yy(英语)

Answer 1

select t.bj,t.语文,b.数学 from ;

(select bj,count(yw) as 语文 from cj where yw > 90 group by bj) t ;

left join ;

(select bj,count(sx) as 数学 from cj where sx > 90 group by bj) b ;

on t.bj = b.bj